APPLIES TO:
Oracle Database - Enterprise Edition - Version 9.2.0.8 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later

SYMPTOMS:
Catproc.sql fails with the following error:

ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_STANDARD
ORA-04021: timeout occurred while waiting to lock object SYS.CDC_ALTER_CTABLE_BEFORE

CAUSE:
Trying to create a database from a database that already exists

SOLUTION:
1. Modify init.ora to contain:

_system_trig_enabled=FALSE
job_queue_processes=0
aq_tm_processes=0

Save init.ora

The following instructions are to be completed from sqlplus as the SYS user:
2. Issue a shutdown immediate: 
   SQL> shutdown immediate
   SQL> startup pfile='<insert full path of init.ora here>'
   SQL> @catalog.sql
   SQL> @catproc.sql

3. Check for invalids from dba_objects:
   SQL> select owner, object_name from dba_objects where status='INVALID';

4. Run utlrp.sql: 
   SQL> @utlrp.sql

5. Check for invalids again.
   SQL> select owner, object_name from dba_objects where status='INVALID';
Recent Posts

Start typing and press Enter to search