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的密码,最好是只包含数字,字母,和($,#,_)这三个特殊字符,并且以字母开头会比较好