Blog

ORA-01017: invalid username/password; logon denied

I got ” ORA-01017: invalid username/password; logon denied ” error in Oracle database.

Details of error are as follows.

ORA-01017: invalid username/password; logon denied

Cause: An invalid username or password was entered in an attempt to log on to Oracle.
 The username and password must be the same as was specified in a GRANT CONNECT statement.
 If the username and password are entered together, the format is: username/password.

Action: Enter a valid username and password combination in the correct format.

invalid username/password; logon denied

This ORA-01017 errors are related with the invalid username or password was entered in an attempt to log on to Oracle.

The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password.

Enter a valid username and password combination in the correct format.

Sometimes this error is get because of Oracle 11g credentials are case sensitive.

Try to set SEC_CASE_SENSITIVE_LOGON false again, then and alter password again as follows..

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE; 
ALTER USER USERNAME IDENTIFIED BY "PASSWORD";

If you got this error for DBA or SYSDBA users, you can recreate the password file with ignorecase=Y option as follows.

orapwd file=orapwtestdb password=sys entries=100 ignorecase=Y

Sometimes this error is get bacause of Incorrect $ORACLE_SID, so check your $ORACLE_SID parameter. If your $ORACLE_SID is set to the wrong system ID then you may get a ORA-01017 error because you are connecting to the wrong instance.

The credentials provided when connecting remotely as sysdba are compared to the contents of the passwordfile.

Password file authentication is enabled by setting the database parameter remote_login_password file to “shared” or “exclusive”.

SQL> alter system set remote_login_passwordfile=exclusive scope=spfile;

Follow me

Contact us for Training/ Job Support

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.