tnsnames
Date: Mon, 9 Jan 2017 14:26:36 +0000
Message-ID: <BN6PR12MB14757279C20EED961075A9D7F4640_at_BN6PR12MB1475.namprd12.prod.outlook.com>
Ok, I have a monitoring product that I am trying to connect to an oracle instance. In test it works great. The monitoring product needs the server-name, the instance-name and port with a userid/password.
In production, we use HP Serviceguard for HA/failover capabilities. So there is a hierarchy of service name for both servers and service name for each server.
So:
proddb.company.org is the hierarchy name,
proddb01.company.org
proddb02.company.org (currently the primary server)
When I put in server-name(either proddb or proddb02) , instance-name, port and userid/password, it doesn't fail the monitor verification but I get an error saying that it is an invalid userid/password.
I tested the userid and password right on the server and it works fine.
I tried it in several different combinations and sometimes it fails verification right away saying ORA-12154:TNS: could not resolve the connect identifier specified So I get that part knowing some combinations are definitely wrong. But what is confusing is when it passes verification but can't connect. And again, I have tested the userid and password, so it's not that.
Any ideas?
Brian
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 09 2017 - 15:26:36 CET