Re: Help: Oracle does not take _at_ sign in password

> 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 --

Yes, i tried several other applications. Almost any application which depends on sqlnet will fail if user has _at_ sign in their password. But asking user to change their password will be our last options unless there is no other ways around Received on Tue May 26 2009 - 11:08:35 CDT