Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to report errors in DBCA ORA-13516 / ORA-06512. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

DBCA fails in the middle of database creation with ORA-13516 / ORA-06512 (document 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

If the password contains spaces or special characters mentioned above, the above error may occur in dbca. Avoid using spaces or special characters when building a library. Of course, errors related to special characters in the password may also occur in rman.

The above is the editor for you to share the DBCA database report error ORA-13516 / ORA-06512 how to do, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.