Oracle password with special characters
So recently I had to connect to a database via sqlplus where I did not have tnsnames.ora and password has a special character.
Without tnsnames.ora your cli looks like
Sqlplus emre/p@ssword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=myoracle.host)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=myoraservicename))) |
Do you notice @ in my password that causes the issue on our case here.
This will give you
ERROR:ORA-01017: invalid username/password; logon denied |
Only way I found to get this work is escape it like
Sqlplus emre/\"p@ssword\"@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=myoracle.host)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=myoraservicename))) |