I'm trying to make a SQLplus connection to a remote Oracle DB following this documentation and it's failing at this step sqlplus username/password@//dbhost:1521/SID with the error:

ORA-01017: invalid username/password; logon denied.

I'm using the following syntax:

sqlplus username/password@//x.x.x.x:1521/SID

I know the DB is reachable and my passwords are correct (verified with Oracle SQL dev). What am I doing wrong?

  • "invalid username/password" -- this error almost always means exactly what it says. It indicates that the incorrect username and password combination was used.
    – Nmath
    Nov 7 '20 at 1:16

that's probably because your password contains special characters and you will need to escape them with back-slash or just use quotes around

sqlplus 'username/password@//x.x.x.x:1521/SID'

please also note that, AFAIK, if your password was contains one or both of / or @ characters, you will still need to use back-slash escape only for them and back-slash itself \ too.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.