Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047_FBO
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:

Thanks
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 12.2.0.1.0 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 12.2.0.1.0 - 64bit Production

SQL> show user;
USER is "GGUSER"

Comments
Post Details
Added on Jan 11 2024
3 comments
114 views