Logging into sqlplus with special characters in password
I am stuck with a situation where one of our servers was setup with special characters in the password, namely the characters '@' and '!'. This is preventing sqlplus from accepting my connection string, specifcically:
sqlplus ben/p@ssword\!@ORCL
(Bash needs the '!' escaped out with '\')
I get the error:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Is there a way to escape out these characters for SQLPLUS?
Ben