Cannot connect remotely – ORA-01017: invalid username/password; logon denied

Hi everyone,


When trying to connect to my Oracle instance 12.1, I faced an issue where i was able to log in locally with SYS as SYSDBA but not remotely.

ORA-01017: invalid username/password; logon denied

In fact, for remote connection, Oracle is using a password file named “orapwSID” located in your “$ORACLE_HOME/dbs“.

Anyway, to solve this, you simply need to set your SYS password again. This will update the password file used over the network.

SQL> alter user sys identified by password;

You should now be able to connect remotely.


Some useful queries used during troubleshooting :

SQL> show parameter remote_login_passwordfile;
SQL> select * from v$pwfile_users;

Another way to solve this would be to delete the password file or set the parameter below to “none“.

remote_login_passwordfile Oracle doc link :



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s