Oracle login failure problem when user password contains special characters

When the password of Oracle database user contains special characters such as @, the normal password input is directly used. Because oracle parses the character after @ into the network service name, the login fails

Here is a demonstration of the user name: wang password: oracle @ 1 network service name: sun:

Linux platform: 'wang/"oracle @ 1"' @ sun--1 double quotation mark expanded password, 1 single quotation mark expanded username + password, that is: 'username/"password"' @ service name

[11:41:14oracle@dvd adump]$sqlplus wang/oracle@1@sun

SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 30 11:41:24 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:

ORA-12532: TNS:invalid argument

[11:42:24oracle @ dvd adump] $sqlplus 'wang/"oracle @ 1"' @ sun--1 double quotation mark expanded password, 1 single quotation mark expanded username + password, that is: 'username/"password"' @ service name

SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 30 11:42:25 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the OLAP and Data Mining options

wang@SUN >

Windows platform: wang/"" "oracle @ 1" "" @ sun--3 double quotation mark expanded passwords, namely: username/"" "password" "@ service name

C:\Users\wanglei.ITADMIN > sqlplus wang/oracle@1@sun

SQL*Plus: Release 11.2.0. 1.0 Production on Week 2 October 30 13:20:00 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:

ORA-12154: TNS: Unable to resolve the specified connection identifier

Please enter a user name:

C:\Users\wanglei.ITADMIN > sqlplus wang/"" "oracle @ 1" "" @ sun--3 double quote expanded passwords, namely: username/"" "password" "@ service name

SQL*Plus: Release 11.2. 1.0 Production on Week 2 October 30 13:20:30 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the OLAP and Data Mining options

SQL >