Oracle strongly recommends that you disable the password verification function in your database before proceeding any further – disable password verify function in oracle

Cause:

During OEM installation, there is halt in install due to password verify function

disable password verify function in oracle

Action:

1)Disable password verify function

2)Open the PDB

SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            MOUNTED
         5 OEMPDB                         MOUNTED
SQL> alter pluggable database OEMPDB open;

Pluggable database altered.

SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            MOUNTED
         5 OEMPDB                         READ WRITE NO

SQL> alter profile default limit password_verify_function null;

Profile altered.

Leave a Reply