RE: ora 12154

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Fri, 4 Nov 2011 08:45:43 +0800
Message-ID: <CAMNBsZuRzehhJexF7of6xoL0nqxCKnqAsuQOzZmmFZ6dATO53g_at_mail.gmail.com>

That's a known issue. Oracle doesn't prevent the use of the "_at_" symbol when you set the users's password but interprets it as a connection-string qualifier when you actually attempt to use it. It then attempt a TNS lookup with the subsequent characters.
Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com

sent from my smartphone
On 4 Nov 2011 00:39, "Zelli, Brian" <Brian.Zelli_at_roswellpark.org> wrote:

> Yes, the password.....I was trying to be security minded.....
>
> -----Original Message-----
> From: Radoulov, Dimitre [mailto:cichomitiko_at_gmail.com]
> Sent: Thursday, November 03, 2011 12:37 PM
> To: Zelli, Brian
> Cc: 'oracle-l_at_freelists.org'
> Subject: Re: ora 12154
>
> On 03/11/2011 17:35, Zelli, Brian wrote:
> >
> > Must have been the actual name I gave that userid. I re-created it with
> a different name and it works.
>
> Perhaps the previous username contained the _at_ or the / characters :)
>
>
> Regards
> 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.--
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Thu Nov 03 2011 - 19:45:43 CDT