Connect user with “@” Password using sqlplus
Posted by Mir Sayeed Hassan on October 4th, 2017
Connect user with “@” Password using sqlplus
Verify the telnet with specific port as shown below
C:\Users>telnet 192.168.1.1 1521
Or
[oracle@localhost ~]$ telnet 192.168.1.1 1521 Trying 192.168.1.1... Connected to 192.168.1.1 Escape character is '^]'
Try to connect with user which has password as “M@R” using sqlplus
[oracle@localhost ~]$ sqlplus mir/"M@R" SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 5 14:53:15 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
[oracle@localhost ~]$
Solution:
Syntax:
sqlplus scott/\”scott@test\”@TEST_DB
or
sqlplus scott/\”t@ger@\”@IP/SID
Example:
C:\Users>sqlplus MIR/\"M@R\"@192.168.1.1/testdb SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 5 14:28:33 2017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data mining and Real Application testing options SQL>