Re: Goldengate 21c (21.5) Classic || DBLOGIN failed

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

By the way.... the same connection string works fine for database...

[oracle_at_gg1 ~]$ sqlplus c##ggadmin/ggadmin_at_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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sourav Biswas <biswas.sourav_at_hotmail.com> Sent: Monday, July 18, 2022 11:00 PM
To: Oracle Mailinglist <oracle-l_at_freelists.org> 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_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:32:21 CEST