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.
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;