0

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?

1
  • "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, 2020 at 1:16

1 Answer 1

1

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .