How to login to sqlplus with username which has special characters in password??

Hi friends,

Today I will show you small demostration of how to connect to the database with username which has special character in their password.

When your password has special character like "@" which we use for connect discriptor then see the following solution.

C:\Users\oradb>sqlplus hr/"hr@"@orcl
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 12 18:02:38 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\Users\oradb>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 12 18:02:53 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> conn hr/"hr@"@orcl
Connected.
SQL>