OGG-00303 ORA-01804 Unable to connect to database using user. Ensure that the necessary privileges are granted to the user

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/