Skip to Main Content



For appeals, questions and feedback, please email

DBLogin is not allowing to connect GGUSER using GGSCI

JhilJan 11 2024

Dear Experts,

I am not able to connect as GGUSER using GGSCI but the same user is able to conenct using SQL*Plus with TNS Connect String. I am not sure , how can i fix this.

OGG S/w Version is 21c

DB S/w Version is 12.2

$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version OGGCORE_21.
Oracle Linux 7, x64, 64bit (optimized), Oracle Database 21c and lower supported versions on Jul 29 2021 03:59:23
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved.

GGSCI (dgprim) 1> dblogin userid gguser password Oracle123

2024-01-11 23:10:55 INFO OGG-03542 Failed to connect to the database. Verify that the connection string and following environment variables are correct:

TNS_ADMIN = /u01/app/oracle/product/12.2.0/dbhome_1/network/admin
LD_LIBRARY_PATH = /u01/app/oracle/product/21c/ogg_home::/u01/app/oracle/product/12.2.0/dbhome_1/lib:/u01/app/oracle/product/12.2.0/dbhome_1/lib:/u01/app/oracle/product/12.2.0/dbhome_1/lib:/u01/app/oracle/product/12.2.0/dbhome_1/lib.
Error: OCI Error ORA (status = 12545-ORA-12545: Connect failed because target host or object does not exist

[oracle@dgprim admin]$ sqlplus gguser@HRMSS

SQL*Plus: Release Production on Thu Jan 11 23:06:45 2024

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Enter password:
Last Successful login time: Thu Jan 11 2024 22:50:07 +11:00

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production

SQL> show user;

Post Details
Added on Jan 11 2024