如何配置 oracle 11g 複雜密碼校正設定，oracle11g

如何配置 oracle 11g 複雜密碼校正設定，oracle11g


----查看預設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.

 
-----調用oracle 的指令碼產生密碼校正函數

SQL> @?/rdbms/admin/utlpwdmg.sql

Function created.
Profile altered.
Function created.

再次查看配置結果：
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------新產生的函數
DEFAULT                        PASSWORD PASSWORD_LOCK_TIME               1
DEFAULT                        PASSWORD PASSWORD_GRACE_TIME              7

7 rows selected.

-----如何修改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
--------- ---------------- ---------------------------------------------------------------- --------------------------------------------------------------------------------
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.

-----將password_ruse_max 改成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
--------- ---------------- ---------------------------------------------------------------- --------------------------------------------------------------------------------
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.

安裝oracle 11g的時不小心跳過了口令管理介面，沒有設定密碼，導致登入不上

你可以使用作業系統認證的方式 登入資料庫 ,然後使用命令更改密碼即可,方法如下： 開啟一個命令提示字元 （開始菜單--運行--“cmd”）
sqlplus "/as sysdba"
SQL> alter user sys identified by xxxx;
 
怎開啟oracle 11g的口令管理

就是 登入到 Oracle 資料庫， 然後修改 test 使用者的密碼