Re: Help: Oracle does not take _at_ sign in password
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Tue, 26 May 2009 09:02:26 -0700 (PDT)
Message-ID: <e0560e16-b581-4ad7-9647-7a141b1a5cb9_at_r3g2000vbp.googlegroups.com>
On May 26, 11:28 am, dshprope..._at_gmail.com wrote:
> 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
Date: Tue, 26 May 2009 09:02:26 -0700 (PDT)
Message-ID: <e0560e16-b581-4ad7-9647-7a141b1a5cb9_at_r3g2000vbp.googlegroups.com>
On May 26, 11:28 am, dshprope..._at_gmail.com wrote:
> 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
I can create and connect to a user with an "_at_" in the password but I cannot connect via sqlplus from the command line passing the password:
$ sqlplus bob/"b_at_b"@xx1
SQL*Plus: Release 9.2.0.6.0 - Production on Tue May 26 11:57:15 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve service name
Enter user-name: bob
Enter password: <== works when accepted via prompt
providing double quotes used
and with connect
bob/"b_at_b" in sqlplus
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data
Mining options
JServer Release 9.2.0.6.0 - Production
Have you tried the username/passwords from any tools other than SQLPlus?
HTH -- Mark D Powell -- Received on Tue May 26 2009 - 11:02:26 CDT