Encountered Oracle Error Messages While Running Catbundle.Sql (Doc ID 1312279.1)

Last updated on FEBRUARY 25, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5.0 [Release 10.2]
Information in this document applies to any platform.
After applying the PSU patch , Catbundle.sql of a PSU may fail with timeouts


Symptoms

You have applied the PSU patch and running the post patch installation steps.  When the catbundle.sql script is run , it fails with errors similar to :

12:08:00 SQL> ALTER TRIGGER sys.cdc_create_ctable_after DISABLE;
ALTER TRIGGER sys.cdc_create_ctable_after DISABLE
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object SYS.DATABASE

12:23:01 SQL> ALTER TRIGGER sys.cdc_create_ctable_before DISABLE;
ALTER TRIGGER sys.cdc_create_ctable_before DISABLE
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object SYS.DATABASE



Changes

PSU applied and running the catbundle.sql as a part of post PSU installation task

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms