Disable Password Policy in Oracle Database 12c and solution to ORA-28003: password verification for the specified password failed

Disable Password Policy in Oracle Database  12c and solution to ORA-28003: password verification for the specified password failed

-- Problem:



ORA-28003: password verification for the specified password failed

ORA-20001: Password length less than 8



--Solution:





---Check if PASSWORD_VERIFY_FUNCTION is used:



SQL> select limit from dba_profiles where profile = 'DEFAULT' and resource_name = 'PASSWORD_VERIFY_FUNCTION';



LIMIT

--------------------------------------------------------------------------------

ORA12C_VERIFY_FUNCTION





--It is enabled .





--Turn off verification:



alter profile default limit password_verify_function null;

Profile altered.



SQL>  select limit from dba_profiles where profile = 'DEFAULT' and resource_name = 'PASSWORD_VERIFY_FUNCTION';





LIMIT

--------------------------------------------------------------------------------

NULL









--Turn on verification:





SQL> alter profile default limit password_verify_function ORA12C_VERIFY_FUNCTION;



Profile altered.



SQL>  select limit from dba_profiles where profile = 'DEFAULT' and resource_name = 'PASSWORD_VERIFY_FUNCTION';



LIMIT

--------------------------------------------------------------------------------

ORA12C_VERIFY_FUNCTION