Re: Goldengate 21c (21.5) Classic || DBLOGIN failed
Date: Mon, 25 Jul 2022 15:51:29 +0000
Message-ID: <OS3P286MB09934508F16D78828312AD45F0959_at_OS3P286MB0993.JPNP286.PROD.OUTLOOK.COM>
Thanks Binh! for pointing me towards this Environment Variable. TNS_ADMIN was not set in my environment. Once set, it fixed my issue.
By the way, this variable isn't much used in our DB servers. We normally maneuver from $ORACLE_HOME/network/admin... Today, realized, how significant this parameter can be.
Thank you once again Binh Le !!!
Best Regards,
Sourav Biswas
+91-9650017306
From: Le, Binh T. <Binh.Le_at_lfg.com>
Sent: Tuesday, July 19, 2022 2:07 AM
To: Sourav Biswas <biswas.sourav_at_hotmail.com>; Oracle Mailinglist <oracle-l_at_freelists.org> Subject: RE: Goldengate 21c (21.5) Classic || DBLOGIN failed
echo $TNS_ADMIN
Binh Le
Oracle DBA
IT
336-691-4721 Office
336-675-7387 Mobile
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
From: Sourav Biswas <biswas.sourav_at_hotmail.com>
Sent: Monday, July 18, 2022 2:32 PM
To: Le, Binh T. <Binh.Le_at_lfg.com>; Oracle Mailinglist <oracle-l_at_freelists.org>
Subject: Re: Goldengate 21c (21.5) Classic || DBLOGIN failed
Tried it, same error message
From: Le, Binh T. <Binh.Le_at_lfg.com<mailto:Binh.Le_at_lfg.com>>
Sent: Monday, July 18, 2022 11:51:33 PM
To: Sourav Biswas <biswas.sourav_at_hotmail.com<mailto:biswas.sourav_at_hotmail.com>>; Oracle Mailinglist <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>
Subject: RE: Goldengate 21c (21.5) Classic || DBLOGIN failed
I would try … avoid Linux ## … create a regular user … not root user …
And try the command in Doc ID 2847434.1 without the “,”
GGSCI 1> dblogin userid <user_at_ABCD> password <secret password>
Something like:
GGSCI (gg1.sblib.com) 10> dblogin userid ggadmin_at_test password ggadmin
From: Sourav Biswas <biswas.sourav_at_hotmail.com<mailto:biswas.sourav_at_hotmail.com>>
Sent: Monday, July 18, 2022 2:13 PM
To: Le, Binh T. <Binh.Le_at_lfg.com<mailto:Binh.Le_at_lfg.com>>; Oracle Mailinglist <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>
Subject: Re: Goldengate 21c (21.5) Classic || DBLOGIN failed
Yes Binh, tried it but it still fails with same error message.
Best Regards,
Sourav Biswas
+91-9650017306
From: Le, Binh T. <Binh.Le_at_lfg.com<mailto:Binh.Le_at_lfg.com>>
Sent: Monday, July 18, 2022 11:34 PM
To: biswas.sourav_at_hotmail.com<mailto:biswas.sourav_at_hotmail.com> <biswas.sourav_at_hotmail.com<mailto:biswas.sourav_at_hotmail.com>>; Oracle Mailinglist <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>
Subject: RE: Goldengate 21c (21.5) Classic || DBLOGIN failed
Have you tried to add this parameter in your prm file:
SETENV (ORACLE_HOME ="/oradb1/app/oracle/product/19c/dbhome_1") <---------- whichever oracle home that your database listener run from ...
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> On Behalf Of Sourav Biswas
Sent: Monday, July 18, 2022 1:32 PM
To: Oracle Mailinglist <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>
Subject: Re: Goldengate 21c (21.5) Classic || DBLOGIN failed
***This email is from an external source. Only open links and attachments from a Trusted Sender.***
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<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Sourav Biswas <biswas.sourav_at_hotmail.com<mailto:biswas.sourav_at_hotmail.com>>
Sent: Monday, July 18, 2022 11:00 PM
To: Oracle Mailinglist <oracle-l_at_freelists.org<mailto: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
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 25 2022 - 17:51:29 CEST