I got ” OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value ” error in Oracle database.
OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value
Details of error are as follows.
OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value 1000
When starting the Extracts for the first time after installation failing with below error.
ERROR OGG-02039 Oracle GoldenGate Capture for Oracle, NMS1AAX.prm: Failed to set logmining server parameter _LOGMINER_GET_CTAS_DML to value N.
ERROR OGG-02042 Oracle GoldenGate Capture for Oracle, NMS1AAX.prm: OCI Error 26,895.
ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, NMS1AAX.prm: PROCESS ABENDING.
Pleas add parameter to extract to set the PARALLELISM parameter
TRANLOGOPTIONS INTEGRATEDPARAMS PARALLELISM #
ORA-23605: invalid value “” for GoldenGate parameter PARALLELISM
The default for PARALLELISM was changed from 0 to 2, but Standard Edition does not allow a value > 1
Apply following RDBMS bug fix
Bug 29374604 – IE not starting against 18c Oracle RDBMS Standard Edition.
To solve this error, increase the streams_pool_size as follows.
SQL> show parameter streams_pool
NAME TYPE VALUE
———————————— ———– ——————————
streams_pool_size big integer 100M
SQL> alter system set streams_pool_size =1000M scope=both sid='*'; System altered. SQL> show parameter streams_pool_size; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ streams_pool_size big integer 1000M SQL>
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )