成功安装oracle后会有一个默认密码略,比如用户的密码有效期和锁定策略...,在默认情况下oracle用户密码有效期是180天,失败登录尝试次数最大10次然后就被锁定。
如果想密码有效期设置用于都有效、用户可以无限次去尝试登录,这时候需要修改下默认策略
查看oracle默认的密码有效期策略(180天)
SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD
180
设置oracle默认策略为永久有效
SQL> Alter PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.
再次查看
SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD
UNLIMITED
查看oracle默认密码锁定策略
SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD
设置为无数次
SQL> Alter PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
Profile altered.
SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD
UNLIMITED
SQL> commit
2 ;
Commit complete.