oracle 11g设置密码策略需要调用
$ORACLE_HOME/rdbms/admin/utlpwdmg.sql.
缺省的,设置最短8个字符.
如下修改为12个字符
cd $ORACLE_HOME/rdbms/admin
cp utlpwdmg.sql utlpwd12mg.sql
sed -i -e "s#< 8#< 12#" -e "s#than 8#than 12#" utlpwd12mg.sql
grep " 12" utlpwd12mg.sql
sqlplus / as sysdba
@?/rdbms/admin/utlpwd12mg
取消密码策略(即,不强制要求密码长度等)
@?/rdbms/admin/undopwd
alter profile default limit password_verify_function null;