You indicate this is a 3rd party product. Their documentation or user
asssitance should spell out the details.
Some things that come to mind:
- you are providing a normal user authentication and they use SYSxyz (or
vice versa)
- they use TNSNAMES.ora and their local copy has not been updated or is
wrong
- there is a mismatch between what they send and what you get from
'lsnrctl status'
The list can go on endlessly,but these are some of the more common
points I've run across
/Hans
On 2017-01-09 7:26 AM, Zelli, Brian wrote:
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.
