Goldengate 21c (21.5) Classic || DBLOGIN failed

From: Sourav Biswas <biswas.sourav_at_hotmail.com>
Date: Mon, 18 Jul 2022 17:30:33 +0000
Message-ID: <OS3P286MB0993EA951BD51DEFF8E6541DF08C9_at_OS3P286MB0993.JPNP286.PROD.OUTLOOK.COM>



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_at_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_at_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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 18 2022 - 19:30:33 CEST

Original text of this message