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.