Search code examples
oracleoracle-sqldeveloperdatabase-connectionsqlplus

SQLPLUS 18c unable to connect to database 19c, get invalid password, but CAN connect through SQLDEVELOPER


Using SQLPLUS 18c on windows 10pc, which has Oracle XE 18c get invalid password response when try to connect to 19c EE on ODA

TNSPING reached the 19c database

Using same account and password from SQL developer on same PC,

I can connect to the 19c database on the server.

thanks

tried sqlplus uid/pwd@my19cdb

get invalid uid/pwd message

tried tnsping my19cdb works

tried connecting through SQLDEVELOPER and it works


Solution

  • The password in the .bat file I was using to initiate sqlplus had special characters and these were not quoted properly. When i change the password to have no special characters, it worked fine. So Jeff had the right answer.