Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Wednesday, July 23, 2008

ORA-600 and ORA-7445 errors after upgrade to Apps 11.5.10.2 and DB 10.2.0.3

After our recent upgrade from 11.5.9/9.2.0.8/Solaris 8 to 11.5.10.2/10.2.0.3/Solaris 10, we have regular occurances of ORA-600 and ORA-7445 errors:

ORA-600 errors:

ORA-00600: internal error code, arguments: [12209], [111], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [139], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [153], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [154], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [156], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [157], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [158], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [162], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [172], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [190], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [193], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [197], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [198], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [217], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [219], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [230], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [292], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [497], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [498], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [71], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [95], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [15264], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17271], [instantiation space leak], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17281], [1001], [0x3F6A0D310], [], [], [], [], []
ORA-00600: internal error code, arguments: [20445], [6892510], [6901726], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], []
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [64], [64], [65], [], [], [], []
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [7], [0], [8], [], [], [], []
ORA-00600: internal error code, arguments: [kcbzwb_4], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kglhdunp2_2], [0x437813380], [37], [0x47B749B28], [0x437813470], [0x437A1C828], [1000], [2]
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []


ORA-7445 errors:

ORA-07445: exception encountered: core dump [peplmufc_Unregister_From_Cleanup()+152] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF713EB1D8] [] []
ORA-07445: exception encountered: core dump [peplmufc_Unregister_From_Cleanup()+152] [SIGSEGV] [Invalid permissions for mapped object] [0xFFFFFFFF56D9ABB8] [] []
ORA-07445: exception encountered: core dump [rnmobj1()+3320] [SIGSEGV] [Address not mapped to object] [0x000000134] [] []
ORA-07445: exception encountered: core dump [sdfind_rtn_hdr()+908] [SIGBUS] [Object specific hardware error] [0xFFFFFFFF6240A03C] [] []

Some of these errors are causing business critical problems. We have severity 1 SRs open with Oracle to solve these issues. Will update once I learn more.

We disabled automatic SGA on Oracle's suggestion and the errors have disappeared. It is described in more detail in this post.


2 comments:

Anonymous said...

Did u get an update on this?

Vikram Das said...

We have disabled Automatic SGA on all our Production instances after which the ORA-600 and ORA-7445 errors disappeared. This is described here:

http://oracleappstechnology.blogspot.com/2009/05/how-to-disable-automatic-sga-tuning-in.html

- Vikram