I'm Trying to connect to a remote DB using Sqlplus, but the password contains a special character (!). The SID is working fine, but Sqlplus is complaining about it when I use the ! in the password
/usr/lib/oracle/18.3/client64/bin/sqlplus -s bloth/hods!@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=remoteServer)(Port=1521))(CONNECT_DATA=(SID=SUDFR)))
ORA-12505: TNS:listener does not currently know of SID given in connect
on the other hand, when I remove the special character I get
ORA-01017: invalid username/password; logon denied
any idea how to fix that?