dbca建立資料庫時報錯ORA-13516: AWR Operation failed: CATPROC not valid

安裝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的密碼,最好是隻包含數字,字母,和($,#,_)這三個特殊字元,並且以字母開頭會比較好