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

  1. 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.

    Like

    1. 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>

      Like

      1. 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!

        Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.