Re: ora 12154

  • From: John Piwowar <jpiwowar@xxxxxxxxx>
  • To: "cichomitiko@xxxxxxxxx" <cichomitiko@xxxxxxxxx>
  • Date: Thu, 3 Nov 2011 09:32:52 -0700

Obviously credentials shouldn't be posted to the list, but check to make sure 
the password and username don't have characters that could be interpolated by 
the shell... @&$! Etc

Regards,

John P.

Sent from a mobile device to deliver a more rapid response.  Please excuse 
brevity and typos.
 

On 2011-11-03, at 9:28 AM, "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx> wrote:

> Could you post the exact commands and output (just copy/paste from your 
> terminal)?
> Remove the real usernames and passwords, of course :)
> 
> Details such OS and Oracle database version will be useful.
> 
> 
> Dimitre
> 
> 
> 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.
> 
> --
> //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