Shulou(Shulou.com)06/01 Report--

Oracle 11.2.0.4 uses DBCA to build the library, and the sys/system password uses special symbols, resulting in an error during installation.

The following is the 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 errorsORA-13516: AWR Operation failed: CATPROC not validORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 206ORA-06512: at "SYS.DBMS_SWRF_INTERNAL" Line 239ORA-06512: at line 1CAUSE ORA-13516 DURING DB CREATION WHEN DB PWD CONTAINS "(SPACE) CHARACTER Bug ID 8633879This 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) SOLUTIONDo 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 sysdbaalter user USERNAME identified by PWD

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.