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