Hi,
Sometimes you can get ” OGG-00303 ORA-01804 ” error during start extract process.
Details of error are as follows.
: [/ggatea01/goldengate/product/19.1.0.0.4/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/ggatea01/goldengate/product/19.1.0.0.4/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/ggatea01/goldengate/product/19.1.0.0.4/extract()]
2020-04-13 16:56:15 ERROR OGG-00303 Unable to connect to database using user. Ensure that the necessary privileges are granted to the user.
Login to the database as user GGS_ADMIN failed because of error Error while trying to retrieve text for error ORA-01804.
2020-04-13 16:56:15 ERROR OGG-01668 PROCESS ABENDING.
This error means Incorrect oracle home used in setenv parameter as follows.
SETENV (ORACLE_SID='WRONG_ORACLE_SID') SETENV (ORACLE_HOME = '<wrong_ORACLE_HOME>')
To solve this problem, Specify correct oracle home in setenv as follows.
SETENV (ORACLE_HOME = '<correct_ORACLE_HOME>') SETENV (ORACLE_HOME="/u01/app/oracle/product/18.7.0/dbhome_1")
Or Use the following command to grant right permission to the Goldengate user
exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE (grantee=>'GGS_ADMIN', privilege_type=>'capture',grant_select_privileges=>true, do_grants=>TRUE); SQL> exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE (grantee=>'GGS_ADMIN', privilege_type=>'capture',grant_select_privileges=>true, do_grants=>TRUE);
Now Please check the below environment variables settings
ORACLE_HOME
ORACLE_SID
TNS_ADMIN
LD_LIBRARY_PATH
PATH
Once all the above settings is made correctly,
Exit all ggsci sessions and start a new ggsci session, then restart the manager process.
Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.
https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/