ORA-13516: AWR Operation failed: CATPROC not valid

selectshen發表於2015-07-27
AI
一臺測試機上安裝11.2.0.4資料庫進度到80%多的時候報ORA-13516: AWR Operation failed: CATPROC not valid.
當時在設定密碼的時含有@符號,和以下文件相符:
DBCA fails in the middle of database creation with ORA-13516 / ORA-06512 (文件 ID 1929718.1)        

In this Document
    Symptoms
    Cause
    Solution

Applies to:
Oracle Database - Standard Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
Symptoms

 DBCA fails while in the middle of creating the database with the following errors
ORA-13516: AWR Operation failed: CATPROC not valid
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 206
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 239
ORA-06512: at line 1
 
Cause

 ORA-13516 DURING DB CREATION WHEN DB PWD CONTAINS " " (SPACE) CHARACTER Bug ID 8633879

This Bug is suspended due to lack of required information, but the issue is solved by using workaround (removing the space and the special characters used in the passwd)
Solution

Do not include any spaces or special characters in the password,

If you are particular with the passwords, then you can reset the passwords once the database is created. Eg:

conn / as sysdba

alter user USERNAME identified by PWD;

上面講到密碼中包含空格或是特殊字元就可能會在dbca時出現以上錯誤.在建庫的時候要避免使用空格或是特殊字元.當然和密碼中特殊字元相關的錯誤,也可能出現在rman中等.
根據這篇文章.個人覺得,oracle的密碼,最好是隻包含數字,字母,和($,#,_)這三個特殊字元,並且以字母開頭會比較好.


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28539951/viewspace-1752962/，如需轉載，請註明出處，否則將追究法律責任。

相關文章