"Translated from MoS article" ORA-28003, ORA-20001, ORA-20002, ORA-20003, ORA-20004 error after executing utlpwdmg.sql

After the execution of Utlpwdmg.sql ORA-28003, ORA-20001, ORA-20002, ORA-20003, ORA-20004 error.

Suitable for:
Oracle server-enterprise edition-version 8.1.7.0 and later
Information in this document applies to any platform.
Checked for relevance on 15-sep-2012

Reason:
Execution of the Utlpwdmg.sql script can limit the user's password security.

The new password enforces such rules as the following:
1. Include one character, one number. A punctuation
2. Different from username
3. Words (word) different from the password validation function
4. Compare with old password. A minimum of 3 characters is different.

The above rules vary in the new version of the DB software, so it is recommended that you review the script in your DB version number. To confirm what the specific rules are.

How to resolve:
Not all customers need or want this level of security.

You can remove the feature by using the following method, for example.

1. Connect internal to the database.
2. Drop function verify_function;
3. ALTER profile DEFAULT LIMIT password_verify_function null;

At this time In the absence of any error whatsoever. Password can be modified using the ' ALTER user XYZ identified by XYZ ' command

The Utlpwdmg.sql script also changes the default profile.
The default profile settings is the resource reference value (resource parameters) of the default profile when the database is created.
Before executing the script. Let's say you've changed these resource references and are using a different number of parameters. You should restore (revert) these values.

If you modified those resource parameters and your were using other parameter values before running the script, you should Restore those values.

Before running the script
-------------------------
Sql> SELECT * from Dba_profiles
2 WHERE profile = ' DEFAULT '
3 and Resource_type = ' PASSWORD ';

Profile Resource_name RESOURCE LIMIT
------------------- -------------------------------- -------- ------------
DEFAULT failed_login_attempts PASSWORD UNLIMITED
DEFAULT password_life_time PASSWORD UNLIMITED
DEFAULT password_reuse_time PASSWORD UNLIMITED
DEFAULT Password_reuse_max PASSWORD UNLIMITED
DEFAULT password_verify_function PASSWORD UNLIMITED
DEFAULT password_lock_time PASSWORD UNLIMITED
DEFAULT password_grace_time PASSWORD UNLIMITED

After running the script:
------------------------
Sql> SELECT * from Dba_profiles
2 WHERE profile = ' DEFAULT '
3 and Resource_type = ' PASSWORD ';

Profile Resource_name RESOURCE LIMIT
-------------------- -------------------------------- -------- ----------------
DEFAULT failed_login_attempts PASSWORD 3
DEFAULT Password_life_time PASSWORD 60
DEFAULT password_reuse_time PASSWORD 1800
DEFAULT Password_reuse_max PASSWORD UNLIMITED
DEFAULT password_verify_function PASSWORD verify_function
DEFAULT password_lock_time PASSWORD. 0006
DEFAULT Password_grace_time PASSWORD 10
7 rows selected.

You can restore the default setting by running this script as internal or as SYSDBA.

Sql> ALTER profile DEFAULT LIMIT
2 Password_life_time UNLIMITED
3 Password_grace_time UNLIMITED
4 Password_reuse_time UNLIMITED
5 Password_reuse_max UNLIMITED
6 failed_login_attempts UNLIMITED
7 Password_lock_time UNLIMITED;

"Translated from MoS article" ORA-28003, ORA-20001, ORA-20002, ORA-20003, ORA-20004 error after executing utlpwdmg.sql