How to configure complex password verification settings for Oracle 11g

How to configure complex password verification settings for Oracle 11g

---- View the password-related parameter configuration information in the default profile
SQL> SELECT profile, resource_type, resource_name, limit FROM dba_profiles WHERE resource_type = 'Password' AND profile = 'default ';
 
Profile resource RESOURCE_NAME LIMIT
--------------------------------------------------------------------------------------------------------------
Default password FAILED_LOGIN_ATTEMPTS 10
Default password PASSWORD_LIFE_TIME UNLIMITED
Default password PASSWORD_REUSE_TIME UNLIMITED
Default password PASSWORD_REUSE_MAX UNLIMITED
Default password PASSWORD_VERIFY_FUNCTION NULL
Default password PASSWORD_LOCK_TIME 1
Default password PASSWORD_GRACE_TIME 7
 
7 rows selected.
 
 
----- Call the Oracle script to generate the password verification function
 
SQL> @? /Rdbms/admin/utlpwdmg. SQL
 
Function created.
Profile altered.
Function created.
 

 

View the configuration result again:
SQL> SELECT profile, resource_type, resource_name, limit FROM dba_profiles WHERE resource_type = 'Password' AND profile = 'default ';
 
Profile resource RESOURCE_NAME LIMIT
--------------------------------------------------------------------------------------------------------------
Default password FAILED_LOGIN_ATTEMPTS 10
Default password PASSWORD_LIFE_TIME 180
Default password PASSWORD_REUSE_TIME UNLIMITED
Default password PASSWORD_REUSE_MAX UNLIMITED
Default password PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION_11G ------ New Function
Default password PASSWORD_LOCK_TIME 1
Default password PASSWORD_GRACE_TIME 7
 
7 rows selected.
 

 

----- How to modify the configuration parameters in the profile:
Alter profile DEFAULT limit PASSWORD_REUSE_MAX 5;

SQL> SELECT profile, resource_type, resource_name, limit FROM dba_profiles WHERE resource_type = 'Password' AND profile = 'default ';
 
PROFILE RESOURCE_TYPE RESOURCE_NAME LIMIT
--------- ---------------- ---------------------------------------------------------------- Accept -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Default password FAILED_LOGIN_ATTEMPTS 10
Default password PASSWORD_LIFE_TIME 180
Default password PASSWORD_REUSE_TIME UNLIMITED
Default password PASSWORD_REUSE_MAX 5
Default password PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION_11G
Default password PASSWORD_LOCK_TIME 1
Default password PASSWORD_GRACE_TIME 7
 
7 rows selected.
 

 

----- Change password_ruse_max to unlimited.
 
SQL> alter profile DEFAULT limit PASSWORD_REUSE_MAX UNLIMITED;

Profile altered.
 
SQL> SELECT profile, resource_type, resource_name, limit FROM dba_profiles WHERE resource_type = 'Password' AND profile = 'default ';
 
PROFILE RESOURCE_TYPE RESOURCE_NAME LIMIT
--------- ---------------- ---------------------------------------------------------------- Accept -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Default password FAILED_LOGIN_ATTEMPTS 10
Default password PASSWORD_LIFE_TIME 180
Default password PASSWORD_REUSE_TIME UNLIMITED
Default password PASSWORD_REUSE_MAX UNLIMITED
Default password PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION_11G
Default password PASSWORD_LOCK_TIME 1
Default password PASSWORD_GRACE_TIME 7
 
7 rows selected.

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian