View Single Post
  #1 (permalink)  
Old August 27th, 2007, 18:18
sknmail@rediffmail.com sknmail@rediffmail.com is offline
Member
 
Join Date: May 2007
Location: India
Posts: 69
Thanks: 1
Thanked 2 Times in 2 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
sknmail@rediffmail.com is on a distinguished road
Send a message via Yahoo to sknmail@rediffmail.com
ORA-00600: internal error code, arguments: [12811], [0]

Hi,

We are in a process of migration of OTM from v5.0 to v5.5. After the Oracle software upgrade from Oracle 9i to 10G, the dbms_scheduler package has become invalid in sys schema. This is after we applied the Daylight patch on Oracle DB Software version 10.2.0.3

On creating package function dbms_scheduler.create_job gives error as "ORA-00600: internal error code, arguments: [12811], [0], [], [], [], [],".

What do you think could have wrong gone?

And finally do you think the OTM OLTP migration from 5.0 to 5.5 i.e dbupdate_55.sql and dbmigrate_55.sql or dbpatch_55.sql script can fail because of this invalid object.

I see this function being referenced in CREATE_ROD_PACKAGE once to create job and next time to ENABLE for ROD database.

Please let us know your opinion.

Thanks very much in advance

Regards,
Skn
Reply With Quote