ORA-28003: password verification for the specified password failed

Hi,

Sometimes You can get “ORA-28003: password verification for the specified password failed, ORA-20002: Password same as or similar to user ” error.

 

ORA-28003: password verification for the specified password failed

Details of error are as follows.

ORA-28003: password verification for the specified password failed

Cause: The new password did not meet the necessary complexity specifications and the password_verify_function failed

Action: Enter a different password. Contact the DBA to know the rules for choosing the new password




SQL> create user mehmet identified by deveci;
create user mehmet identified by deveci profile system
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20002: Password same as or similar to user


 

ORA-20002: Password same as or similar to user

To solve this error, you should prefer the strong password which have one number and one alphanumeric character and one special character

SQL> create user mehmet identified by Deveci.63;

User created.

 

PASSWORD_VERIFY_FUNCTION

Or You can disable PASSWORD_VERIFY_FUNCTION and create the user with its weak password as follows.

SQL>select profile, resource_name, limit from dba_profiles where RESOURCE_NAME = 'PASSWORD_VERIFY_FUNCTION';
PROFILE                        RESOURCE_NAME                    LIMIT
------------------------------ -------------------------------- ----------------------------------------
DEFAULT                        PASSWORD_VERIFY_FUNCTION         VERIFY_FUNCTION_11G
SYSTEM                         PASSWORD_VERIFY_FUNCTION         VERIFY_FUNCTION_11G

 

 

Disable the PASSWORD_VERIFY_FUNCTION , then create the user.

SQL> alter profile default limit PASSWORD_VERIFY_FUNCTION null;

Profile altered.



SQL> create user mehmet identified by deveci;

User created.


 

 

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

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

 968 views last month,  1 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

Do NOT follow this link or you will be banned from the site!