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