Help: Oracle does not take _at_ sign in password
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