Oracle
CSSCAN 用於字元集更改，數據庫版本 11.2.0.3.0
根據文件 745809.1，安裝 Csscan。
在執行“Csminst.sql”時，我們遇到以下錯誤
SQL> @$ORACLE_HOME/rdbms/admin/csminst.sql create user csmig identified by csmig password expire account lock * ERROR at line 1: ORA-28003: password verification for the specified password failed
您可以只編輯文件
$ORACLE_HOME/rdbms/admin/csminst.sql並更改identified by csmig為csmig更複雜的密碼；_如果您的密碼不是字母數字、下劃線 ( )、美元符號 ($) 或井號/井號 ( )，您可能需要用雙引號將密碼括起來#。例子：
create user csmig identified by "W#$!?X8Y" password expire account lock;
1 只需編輯至少 8 個字元的腳本，包括至少 1 個數字
或 2 禁用密碼驗證功能。
這是禁用密碼驗證功能的第二種方法
SQL> select * from dba_profiles 2 where profile='DEFAULT' and resource_name='PASSWORD_VERIFY_FUNCTION'; PROFILE RESOURCE_NAME RESOURCE LIMIT -------------------------------------------------- -------------------------------- -------- ---------------------------------------- DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11G " SQL> @csminst create user csmig identified by csmig password expire account lock * ERROR at line 1: ORA-28003: password verification for the specified password failed ORA-20001: Password length less than 8 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining and Real Application Testing options /*-- Disable password verify function temporarily-- */ SQL> alter profile default LIMIT PASSWORD_VERIFY_FUNCTION NULL; Profile altered. SQL> @csminst User created. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. User altered. 0 rows created. 1 row updated. Table created. Synonym dropped. Synonym created. Table created. Synonym dropped. Synonym created. Table created. Synonym dropped. Synonym created. Table created. Synonym dropped. Synonym created. Table created. Synonym dropped. Synonym created. Table created. Synonym dropped. Synonym created. Table created. Synonym dropped. Synonym created. Table created. Synonym dropped. Synonym created. Table created. Synonym dropped. Synonym created. Table created. Synonym dropped. Synonym created. Table created. Synonym dropped. Synonym created. Table created. Synonym dropped. Synonym created. 18 rows created. View created. Synonym dropped. Synonym created. View created. Synonym dropped. Synonym created. View created. Synonym dropped. Synonym created. View created. Synonym dropped. Synonym created. View created. Synonym dropped. Synonym created. View created. Synonym dropped. Synonym created. View created. View created. View created. View created. Grant succeeded. Grant succeeded. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining SQL> select username from dba_users 2 where created > sysdate-1; USERNAME ------------------------------ CSMIG SQL> select * from dba_profiles 2 where profile='DEFAULT' and resource_name='PASSWORD_VERIFY_FUNCTION'; PROFILE RESOURCE_NAME RESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL /* Enabling Password Verify function --*/ SQL> alter profile default LIMIT PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION_11G; Profile altered. SQL> select * from dba_profiles 2 where profile='DEFAULT' and resource_name='PASSWORD_VERIFY_FUNCTION'; PROFILE RESOURCE_NAME RESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11G /*-- Run a simple test to check password verify function enabled-- */ SQL> create user test identified by test; create user test identified by test * ERROR at line 1: ORA-28003: password verification for the specified password failed ORA-20001: Password length less than 8