Re: tnsnames

From: Thomas Roach <troach_at_gmail.com>
Date: Mon, 9 Jan 2017 09:56:04 -0500
Message-ID: <CAM6TEvJ=mFmqDv1r564+8+nn3zddmyEyAL5AzxGWFexo1UEm_Q_at_mail.gmail.com>



Could your database be checking for case sensitive passwords? What you are typing in is different from the way the app sends the credentials?

On Mon, Jan 9, 2017 at 9:51 AM, Hans Forbrich <fuzzy.graybeard_at_gmail.com> wrote:

> 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.
>
>
>

-- 
Thomas Roach
813-404-6066
troach_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 09 2017 - 15:56:04 CET

Original text of this message