RE: ora 12154

  • From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
  • To: Brian.Zelli@xxxxxxxxxxxxxxx
  • Date: Fri, 4 Nov 2011 08:45:43 +0800

That's a known issue.  Oracle doesn't prevent the use of the "@" 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@xxxxxxxxxxxxxxx> wrote:

> Yes, the password.....I was trying to be security minded.....
>
> -----Original Message-----
> From: Radoulov, Dimitre [mailto:cichomitiko@xxxxxxxxx]
> Sent: Thursday, November 03, 2011 12:37 PM
> To: Zelli, Brian
> Cc: 'oracle-l@xxxxxxxxxxxxx'
> 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 @ 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.--
> //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