Re: tnsnames

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.

--
http://www.freelists.org/webpage/oracle-l