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;

 

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

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

 

 2 views last month,  2 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

IT Tutorial