Re: ORA-04045 : catalog.sql and catproc.sql damaged my db

From: merry_prince <member13405_at_dbforums.com>
Date: Tue, 25 Mar 2003 11:02:05 +0000
Message-ID: <2680623.1048590125_at_dbforums.com>


actually this is related to several bugs on several releases... from 8.0.4 to 8.1.6
here is a partial list. 1314167, 1102966, 875427, 759735, 753384, 647800 and Bug 1314167

there is a work around posted on metalink.

identify invalid system objects:
select 'alter type sys.'|| object_name || ' compile;' from all_objects
where status = 'INVALID'
and owner = 'SYS'
and object_type = 'TYPE';

you have to perform a drop operation on the queue_table even though you did not create any queue tables explicitly. Two queue tables are created by catdefrt.sql when a database is initialized.

select * from dba_queue_tables;

SYSTEM.DEF$_AQCALL execute dbms_aqadm.drop_queue_table ('SYSTEM.DEF$_AQCALL');

ORA-24012 "cannot drop QUEUE_TABLE, some queues in %s have not been dropped", you must use the force option in the procedure:

execute dbms_aqadm.drop_queue_table ('SYSTEM.DEF$_AQCALL', TRUE);
-AND-

execute dbms_aqadm.drop_queue_table ('SYSTEM.DEF$_AQERROR', TRUE);

This is a Bug in which two queue tables are created by catdefrt.sql when the
database is initialized regardless of whether the Replication option is installed.

--

Posted via http://dbforums.com Received on Tue Mar 25 2003 - 12:02:05 CET

Original text of this message