Re: ora 12154

  • From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 03 Nov 2011 15:23:10 -0600

I find that difficult to follow.

ORA-12154:  TNS:could not resolve service name

says the service name is incorrect.  Which implies that you are not getting TO 
the listener.  There is no attempt to log in because the system does not even 
know which in system to log in.

Ignoring the password, any chance you can copy-paste the username.  Is there 
ANY chance that you had an '@', '/' or shell-parseable character in the 
username or password?

Did you try the 'safe' connect method:
     sqlplus user@{connect string}
or just
     sqlplus user/pass@{connect string}

You also don't specify whether you are using the TNS connect method or some 
EZConnect method.  For TNS, the {connect string} looks up the target in the 
tnsnames.ora, whereas EZConnect allows you to specify the 'JDBC' style string 
after the @.

A 12154 usually implies that you are using the TNS method and it could not find 
the entry in the TNSNAMES.ORA, which in turn implies that the username/password 
is parsing incorrectly before it gets going.

/Hans


On 03/11/2011 10:35 AM, Zelli, Brian wrote:
>
> Must have been the actual name I gave that userid.  I re-created it with a 
> different name and it works.
>
> -----Original Message-----
> From: Radoulov, Dimitre [mailto:cichomitiko@xxxxxxxxx]
> Sent: Thursday, November 03, 2011 12:25 PM
> To: Zelli, Brian
> Cc: 'oracle-l@xxxxxxxxxxxxx'
> Subject: Re: ora 12154
>
> On 03/11/2011 17:21, Zelli, Brian wrote:
>> Ok, this is really ticking me off.  I created a user and when I try
>> and connect via sqlplus I get ORA-12154:  TNS:could not resolve service name 
>> Yet I can connect with other users to the same instance from the same 
>> machine.
>>
>> Why just this user?  I checked roles, privs and everything else.  I
>> checked tnsnames file, sqlnet.ora file
>>
> Could you connect with other users from the same unix session (from the same 
> shell)?
>
>
>
> Dimitre
>
>
> 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.-- 
> //www.freelists.org/webpage/oracle-l
>
>
>
>
> 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.--
> //www.freelists.org/webpage/oracle-l
>
>
>

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2011