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';