ORA-13516: AWR Operation failed: CATPROC not valid

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 留言