DB Version:11.2.0.4
OS : RHEL 6.5
Shell : Bash
From the application server , where oracle client is installed I am trying to login to a DB user. Since the schema password has an @ character in it, bash shell is interpreting it wrongly.
I tried enclosing the password in single and double quotes as shown below. But, it didn't help.
Any workaround ?
--- Enclosing in single Quotes
$ sqlplus SUPPORT_USR/'Jumper@824'@10.18.5.63:1521/SMGPRD
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 18 11:24:55 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name: ^C
---- Enclosing in double quotes
$
$ sqlplus SUPPORT_USR/"Jumper@824"@10.18.5.63:1521/SMGPRD
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 18 11:25:12 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
I tried to escape the @ character using \ character as shown below. No luck.
sqlplus SUPPORT_USR/"Jumper\@824"@10.18.5.63:1521/SMGPRD
sqlplus SUPPORT_USR/'Jumper\@824'@10.18.5.63:1521/SMGPRD