Problem:
安裝 Oracle 11gR2 時,預設密碼輸入了"@"符號,後續安裝出現 ORA-13516: AWR Operation failed: CATPROC not valid.,查了Support文件,安裝完後需調整預設密碼,但也因為字典檔裝不完全,還需要重設字典檔
Solution:
1. Change sys Password
$ sqlplus / as sysdba SQL> alter user sys identifeid by "password";
2. Rebuild catalog
$ sqlplus / as sysdba SQL> @?/rdbms/admin/catproc.sql SQL> @?/rdbms/admin/utlrp.sql
參考來源:
DBCA fails in the middle of database creation with ORA-13516 / ORA-06512 (Doc ID 1929718.1)
0 留言