Goldengate: ERROR: Unable to connect to database using user ggate. Please check privileges. allocating error handle.

Unable To Connect To Database Using User <goldengate user>. Please Check Privileges.

GGSCI (ggsource.doyensys.com) 5> dblogin  USERID gguser, PASSWORD xxxxxxxx
ERROR: Unable to connect to database using user ggate. Please check privileges.
allocating error handle.

Golden gate issue, I am able to connect to sqlplus via this password but using ggsci shell we cannot login.

1. Please check the below environment variables settings

ORACLE_HOME
ORACLE_SID
LD_LIBRARY_PATH
PATH

2. Once all the above settings is made correctly,

Exit all ggsci sessions,
Start a new ggsci session
restart the OGG mgr process.

3. Login again

dblogin  USERID ggate, PASSWORD xxxxxxxx

  • August 20, 2018 | 14 views
  • Comments