Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a fresh installation of Oracle 11g enterprise edition on CentOS 6, both 64 bits. I have installed Oracle and so far everything looks fine. I have already added an started a listener. The problem I have now is when I try to create a test db using dbca. Everything goes well until the post creation DB part which popups an error. The error shows the same text as the /opt/app/oracle/cfgtoollogs/dbca/testingDB/postDBCreation.log:

   utl_recomp_begin: 09:34:38 
   utl_recomp_end: 09:34:42
   BEGIN dbms_swrf_internal.cleanup_database(cleanup_local => FALSE); END;

  *
  ERROR at line 1:
  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

The creation of the DB cannot continue and it stops here...

I have searched everywhere in internet but not luck so far. I have no clues what it can be. Any suggestions?

Thanks in advance,

share|improve this question

1 Answer 1

Try to rerun CATPROC on the database while connected as sys:

@?/rdbms/admin/catproc.sql

The recompile all invalid objects:

@?/rdbms/admin/utlrp.sql 
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.