Site icon IT Tutorial

ORA-01017: invalid username/password; logon denied

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

 

ORA-01017: invalid username/password; logon denied

 

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;

 

 

ORA-01017: invalid username/password; logon denied after upgrade to 19C

 

In Oracle 12c or upper version, you should use case sensitivity for that parameter value is true. Make SEC_CASE_SENSITIVE_LOGON = TRUE for setting case sensitivity.

Then , Edit the SQLNET.ora file and lower the default value of parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER to a lower version (19)

edit sqlnet.ora as follows then restart the listener, then try again.

 

cat sqlnet.ora
# sqlnet.ora.vfxjdbadm01 Network Configuration File: /u01/app/19.0.0.0/grid/network/admin/sqlnet.ora.vfxjdbadm01
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SQLNET.EXPIRE_TIME=10

# sqlnet.ora.vfxidb01 Network Configuration File: /u01/app/12.2.0.1/grid/network/admin/sqlnet.ora.vfxidb01
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

Exit mobile version