Re: Oracle does not take _at_ sign in password

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 26 May 2009 18:03:00 +0200
Message-ID: <4a1c12b5$0$696$426a74cc_at_news.free.fr>


<dshproperty_at_gmail.com> a écrit dans le message de news: 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

It does not matter as you should not put your password on command line: it is visible to all that can do a "ps".

Regards
Michel Received on Tue May 26 2009 - 11:03:00 CDT

Original text of this message