RE: Migration errors

These errors have to do with advanced queueing. Do you have AQ_TM_PROCESSES set to any value other than 0? If you do, set it to 0 during the upgrade. N.B., this is a mere guess based on the information provided.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
Sent: Tuesday, January 29, 2002 7:25 PM
To: Multiple recipients of list ORACLE-L

hi all,
Is any body encountered following errors... this happening while I try to migrate 8.1.7.2 database to 9.0.1
using manual upgradation or ODMA tool.

ALTER TABLE system.aq$_queues
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.AQ$_SUBSCRIBERS ORA-00600: internal error code, arguments: [15456], [AQ$_SUBSCRIBERS], [13],

[7], [tdo generation], [], [], []

ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [],
[]

ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7],
[tdo generation], [], [], []

ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [],
[]

ALTER TABLE system.aq$_queues
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.AQ$_SUBSCRIBERS ORA-00600: internal error code, arguments: [15456], [AQ$_SUBSCRIBERS], [13],

[7], [tdo generation], [], [], []

ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [],
[]

ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7],
[tdo generation], [], [], []

ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [],
[]

and
alert log has following errors....

Errors in file /usr2/app/oracle/admin/TIMSTEST/udump/timstest_ora_7587.trc: ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7],
[tdo generation], [], [], []

ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [],
[]

Wed Jan 30 10:36:04 2002
Errors in file /usr2/app/oracle/admin/TIMSTEST/udump/timstest_ora_7587.trc: ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [],
[]

ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7],
[tdo generation], [], [], []

ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [],
[]

Wed Jan 30 10:36:06 2002
Errors in file /usr2/app/oracle/admin/TIMSTEST/udump/timstest_ora_7587.trc: ORA-00600: internal error code, arguments: [15456], [AQ$_SUBSCRIBERS], [13],
[7], [tdo generation], [], [], []

ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [],
[]

ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7],
[tdo generation], [], [], []

ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [],
[]

Wed Jan 30 10:36:08 2002

TIA narender akula
Oracle DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Narender Akula
  INET: narender.akula_at_terralink.co.nz

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).