Disable Oracle Password Verification and Complexity Function

While installing OEM 13c, the following warning might occur from checking OEM repository database:

“Oracle strongly recommends that you disable the password verification function in your database before proceeding any further”

Let’s check and disable password verification function if any.

SQL>select username, profile from dba_users where username like 'SYSMAN%';

USERNAME                       PROFILE
------------------------------ ------------------------------
SYSMAN_TYPES                   DEFAULT
SYSMAN_RO                      MGMT_INTERNAL_USER_PROFILE
SYSMAN_OPSS                    MGMT_INTERNAL_USER_PROFILE
SYSMAN_STB                     MGMT_INTERNAL_USER_PROFILE
SYSMAN_BIPLATFORM              MGMT_INTERNAL_USER_PROFILE
SYSMAN                         MGMT_INTERNAL_USER_PROFILE
SYSMAN_MDS                     MGMT_INTERNAL_USER_PROFILE

7 rows selected.

SQL>  select PROFILE,RESOURCE_NAME,LIMIT from dba_profiles  
      where PROFILE in ('DEFAULT','MGMT_INTERNAL_USER_PROFILE') 
        and RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION'; 

PROFILE                    RESOURCE_NAME            LIMIT
-------------------------- ------------------------ --------------------- 
DEFAULT                    PASSWORD_VERIFY_FUNCTION NULL
MGMT_INTERNAL_USER_PROFILE PASSWORD_VERIFY_FUNCTION GMT_INTERNAL_PASS_VERIFY
SQL>

SQL> alter profile MGMT_INTERNAL_USER_PROFILE limit  
                      PASSWORD_VERIFY_FUNCTION null;
Profile altered. 

SQL>  select PROFILE,RESOURCE_NAME,LIMIT 
        from dba_profiles  
       where PROFILE in ('DEFAULT','MGMT_INTERNAL_USER_PROFILE') 
         and RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION';

PROFILE                     RESOURCE_NAME             LIMIT
--------------------------  ------------------------  ------------------
DEFAULT                     PASSWORD_VERIFY_FUNCTION  NULL
MGMT_INTERNAL_USER_PROFILE  PASSWORD_VERIFY_FUNCTION  NULL
SQL>

6 thoughts on “Disable Oracle Password Verification and Complexity Function”

Pingback: Step by Step Installing Oracle Enterprise Manager 13cR3( 13.3.0.0 ) Cloud Control on Linux 7 | dbalifeeasy
George says:

May 8, 2020 at 10:47 pm

Thanks for sharing. I have followed the steps but i am keep getting the same error. Not sure what is wrong. The DB version is 18.9c.

LikeLike

Reply
1. dbalifeeasy says:
  
  May 9, 2020 at 11:06 am
  
  it is strange. is your DB is CDB/PDB ?
  
  SQL> alter session set container=”EMPDBREPOS”;
  
  SQL> select username, profile from dba_users where username like ‘SYS%’;
  
  USERNAME PROFILE
  ——————– —————————————-
  SYS DEFAULT
  SYSTEM DEFAULT
  SYSBACKUP DEFAULT
  SYSRAC DEFAULT
  SYSKM DEFAULT
  SYS$UMF DEFAULT
  SYSDG DEFAULT
  SYSMAN_TYPES DEFAULT
  SYSMAN_RO MGMT_INTERNAL_USER_PROFILE
  SYSMAN_OPSS MGMT_INTERNAL_USER_PROFILE
  SYSMAN_STB MGMT_INTERNAL_USER_PROFILE
  SYSMAN_BIPLATFORM MGMT_INTERNAL_USER_PROFILE
  SYSMAN MGMT_INTERNAL_USER_PROFILE
  SYSMAN_MDS MGMT_INTERNAL_USER_PROFILE
  
  14 rows selected.
  
  SQL> select PROFILE,RESOURCE_NAME,LIMIT
  from dba_profiles
  where PROFILE in (‘DEFAULT’,’MGMT_INTERNAL_USER_PROFILE’)
  and RESOURCE_NAME=’PASSWORD_VERIFY_FUNCTION’;
  
  PROFILE RESOURCE_NAME LIMIT
  —————————————- ——————————– ——————————————————————————————————————————–
  DEFAULT PASSWORD_VERIFY_FUNCTION NULL
  MGMT_INTERNAL_USER_PROFILE PASSWORD_VERIFY_FUNCTION NULL
  
  SQL>
  
  LikeLike
  
  Reply
  1. George says:
    
    May 10, 2020 at 9:53 pm
    
    Thanks for following up so soon! Yeap, it is. The only difference is that i am using the sys account and i am doing a silent installtion but it should not make any difference. I am literally stuck on this for about a week now. 😉
    
    select PROFILE,RESOURCE_NAME,LIMIT
    from dba_profiles
    where PROFILE in (‘DEFAULT’,)
    and RESOURCE_NAME=’PASSWORD_VERIFY_FUNCTION’;
    
    PROFILE RESOURCE_NAME LIMIT
    DEFAULT PASSWORD_VERIFY_FUNCTION NULL
    
    Well, i will keep you posted if i manage to get this up and running eventually!
    
    LikeLike
Solaire of Astora says:

June 30, 2020 at 5:55 am

From 18/19c I just realized that my pdb wasn’t open (mounted)

LikeLike

Reply
1. dbalifeeasy says:
  
  June 30, 2020 at 11:04 am
  
  Thanks for letting me know, and being happy to hear you find the issue, so you can move on…..
  
  LikeLiked by 1 person
  
  Reply