Re: ora 12154

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
  • Date: Thu, 03 Nov 2011 17:28:15 +0100

Could you post the exact commands and output (just copy/paste from your 
Remove the real usernames and passwords, of course :)

Details such OS and Oracle database version will be useful.


On 03/11/2011 17:26, Zelli, Brian wrote:
> Yes, that's what aggravates me....
> Brian
> -----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.


Other related posts: