ORA-28003: password verification for the specified password failed

Hi,

Sometimes You can get “ORA-28003: password verification for the specified password failed ” error.

 

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

 

 

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.

 

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.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 581 views last month,  13 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 mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Check Also

ORA-01438: value larger than specified precision allowed for this column

Hi, I got ” ORA-01438: value larger than specified precision allowed for this column” error …

Leave a Reply