By the way.... the same connection string works fine for database...
[oracle@gg1 ~]$ sqlplus c##ggadmin/ggadmin@test
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 18 23:01:35 2022
Version 19.15.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Last Successful login time: Mon Jul 18 2022 22:52:51 +05:30
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
SQL>
Best Regards,
Sourav Biswas
+91-9650017306
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Sourav Biswas <biswas.sourav@xxxxxxxxxxx>
Sent: Monday, July 18, 2022 11:00 PM
To: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
Subject: Goldengate 21c (21.5) Classic || DBLOGIN failed
Hi All,
I installed and patched 21.5 Classic Goldengate . But it's not letting me
DBLOGIN.
GGSCI (gg1.sblib.com) 10> dblogin userid c##ggadmin@test, password ggadmin
2022-07-18 22:53:01 INFO OGG-03542 Failed to connect to the database.
Verify that the connection string and following environment variables are
correct:
LD_LIBRARY_PATH =
/oradb1/app/gghome:/oradb1/app/oracle/product/19c/lib:/lib:/usr/lib.
Error: OCI Error ORA (status = 12541-ORA-12541: TNS:no listener
)
I followed Doc ID 2847434.1 as described, however, it keeps throwing same error.
My tnsnames.ora file;
[oracle@gg1 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File:
/oradb1/app/oracle/product/19c/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_TEST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gg1.sblib.com)(PORT = 1521))
test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gg1.sblib.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test.sblib.com)
)
)
PDBT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gg1.sblib.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdbt.sblib.com)
)
)
Current Setup:
OS: RHEL 7.9
DB: Oracle 19.15
Goldengate: 21.5 Classic
Please help suggest next steps
Best Regards,
Sourav Biswas
+91-9650017306
