Help: Oracle does not take _at_ sign in password

From: <dshproperty_at_gmail.com>
Date: Tue, 26 May 2009 08:28:56 -0700 (PDT)
Message-ID: <0b652e5a-cd55-4a42-b5c7-8b2d737206b9_at_j12g2000vbl.googlegroups.com>



All,

I have an issue and i hope somebody here will be able to help me.

We have a password manage system which will push all the password into oracle database by using the command
alter user test1 identified by "xx_at_xx"

And most user can connect by doing
$ sqlplus test1_at_testdb

SQL*Plus: Release 10.2.0.3.0 - Production on Tue May 26 11:21:12 2009 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Enter password:"xx_at_xx"
SQL> However, if i do
$ sqlplus test1/"xx_at_xx"@testdb

SQL*Plus: Release 10.2.0.3.0 - Production on Tue May 26 11:24:42 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified, as you can see, a lot of our script/application will fail because of this

Before I send out an email asking everybody who has an "_at_" in their password to change it (it will involve tons of people), i would like to see whether this group can help me to find a way to escape _at_ sign.

Thanks Received on Tue May 26 2009 - 10:28:56 CDT

Original text of this message