ORA-600(kglobpn-bad-pga)错误

1、.ORA-600(kglobpn-bad-pga)错误这个错误比较罕见，无论是GOOGLE还是METALINK都找不到任何的相关信息。数据库版本是11.2.0.2 RAC环境，这个错误之所以这么罕见，也和11.2的版本太新，以致于很多问题都还没有暴露出来有关。错误信息为：2012-03-29 04:06:02.353000 +08:00Errors in file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18355.trc (incident=144401):ORA-00600: internal error code, arguments:

2、 kglobpn-bad-pga, , , , , , , , , , , Incident details in: /oracle/diag/rdbms/orcl/orcl1/incident/incdir_144401/orcl1_ora_18355_i144401.trc2012-03-29 04:10:12.017000 +08:00Dumping diagnostic data in directory=cdmp_20120329041012, requested by (instance=1, osid=18355), summary=incident=144401.Use ADR

3、CI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.2012-03-29 04:10:13.750000 +08:00Sweep inc144401: completedSweep inc2144401: completed详细的TRACE信息为：* 2012-03-29 04:06:02.385* SESSION ID:(106.45) 2012-03-29 04:06:02.385* CLIENT ID:() 2

4、012-03-29 04:06:02.385* SERVICE NAME:(orcl) 2012-03-29 04:06:02.385* MODULE NAME:(PL/SQL Developer) 2012-03-29 04:06:02.385* ACTION NAME:(Main session) 2012-03-29 04:06:02.385Dump continued from file: /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18355.trcORA-00600: internal error code, arguments: k

5、globpn-bad-pga, , , , , , , , , , , = Dump for incident 144401 (ORA 600 kglobpn-bad-pga) =* 2012-03-29 04:06:02.426dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)- Current SQL Statement for this session (sql_id=8m7jgqrwrtyj1) -CREATE OR REPLACE TRIGGER N_TRIGGERAFTER I

6、NSERT OR UPDATE ON TFOR EACH ROWDECLARE.END;- Call Stack Trace -calling call entry argument values in hex location type point (? means dubious value) - - - -ksedst1()+96 CALL skdstdst() FFFFFFFF7FFEED60 ?1006B0C80 ? 000000000 ?00000000A ? 000000001 ?10BD95B00 ?ksedst()+60 CALL ksedst1() 000000000 ?

7、000000001 ?00010C212 ? 00010C000 ?10C20A000 ? 00010C20A ?dbkedDefDump()+2032 CALL ksedst() 000000000 ? 10B25B000 ?10B25B2B0 ? 10C212000 ?00010B000 ? 00010C212 ?dbgexPhaseII()+1800 PTR_CALL dbkedDefDump() 000000003 ? 000000002 ?10A6EC2C8 ? 0000014B0 ?10C20A000 ? 000000003 ?dbgexProcessError() CALL db

8、gexPhaseII() 10C3B4650 ?+1248 FFFFFFFF7BE3A578 ?FFFFFFFF7FFF3AB8 ?0018E0000 ? 10A6E35B8 ?000001C00 ?dbgePostErrorKGE()+ CALL dbgeExecuteForError 10AE0C3FD ?1320 () FFFFFFFFFEC0B62D ?001050000 ?FFFFFFFF7FFF6268 ?001060000 ? 000000028 ?dbkePostKGE_kgsf()+ CALL dbgePostErrorKGE() 10C20AC90 ? 000000000

9、?44 FFFFFFFF7BE3A578 ?000000000 ? 000000258 ?00010C000 ?kgerinv_internal()+ CALL kgeadse() 10C20AC90 ?72 FFFFFFFF7D1042C0 ?000000258 ? 000002868 ?10A6E4000 ? 00010A6E4 ?kgerinv()+40 CALL kgerinv_internal() 10C20AC90 ? 004EA2360 ?10BDED4D0 ? 000000258 ?000000000 ? 000000000 ?kgeasnmierr()+28 CALL kge

10、rinv() 10C20AC90 ?FFFFFFFF7D1042C0 ?10BDED4D0 ? 000000000 ?FFFFFFFF7FFF7630 ?000001400 ?kglobpn()+2972 CALL kgeasnmierr() 10C20AC90 ?FFFFFFFF7D1042C0 ?10BDED4D0 ? 000000000 ?0000060A6 ? 00000005B ?kglpim()+444 CALL kglobpn() FFFFFFFFFFBEC700 ?10C20AC90 ? 0000020BE ?000000000 ? CF6AF45C8 ?D163B01D0 ?

11、kktcrt()+1204 CALL kglpim() 000001154 ?FFFFFFFF7FFF7EC8 ?D163B01D0 ? 000000002 ?000000006 ? 00000004E ?opiexe()+24660 CALL kktcrt() 000006000 ?FFFFFFFF7BC19328 ?D1772AAE0 ? 10C20A950 ?FFFFFFFF7BC190C0 ?000000002 ?opiosq0()+6416 CALL opiexe() 000000004 ? 000000000 ?FFFFFFFF7FFFA43C ?00010A6E3 ? 10A6E

12、3000 ?FFFFFFFF7FFF9E10 ?kpooprx()+232 CALL opiosq0() 00000004A ? 00000000E ?FFFFFFFF7FFFA600 ?0000000A4 ? 00010A6E3 ?10C20AC90 ?kpoal8()+3884 CALL kpooprx() FFFFFFFF7FFFDF3C ?FFFFFFFF7DFD0660 ?0000015EC ? 0000000A4 ?00010C000 ? 0000000A4 ?opiodr()+1428 PTR_CALL kpoal8() 00000005E ? 00000001C ?FFFFFF

13、FF7FFFDF38 ?00010C000 ? 10C20A000 ?000001648 ?ttcpip()+1056 PTR_CALL opiodr() 00010A795 ? 00000001C ?103EAD460 ? 00010A400 ?000001400 ? 10C20A000 ?opitsk()+1528 CALL ttcpip() 000000000 ? 10A6C7694 ?10C20AC90 ?FFFFFFFF7FFFDF38 ?FFFFFFFF7FFFC980 ?10C221848 ?opiino()+1000 CALL opitsk() 10A6C7694 ? 10C2

14、26C98 ?10C221654 ? 10C21F958 ?000000000 ? 10C20A950 ?opiodr()+1428 PTR_CALL opiino() 00010C000 ? 10C2216D0 ?10C2216D0 ? 000380000 ?0000000E9 ?FFFFFFFF7FFFF890 ?opidrv()+1100 CALL opiodr() 10C221000 ? 000000004 ?1035DD740 ? 00010C000 ?000001400 ? 10C20A000 ?sou2o()+92 CALL opidrv() 00000003C ? 000000

15、004 ?FFFFFFFF7FFFF890 ?0001EB250 ?FFFFFFFF7C945110 ?FFFFFFFF7FFFFC98 ?opimai_real()+304 CALL sou2o() FFFFFFFF7FFFF868 ?00000003C ? 000000004 ?FFFFFFFF7FFFF890 ?00010C000 ? 00010B800 ?ssthrdmain()+320 PTR_CALL opimai_real() 000000000 ?FFFFFFFF7FFFFB38 ?FFFFFFFF7F900768 ?00010B800 ? 000000001 ?000000002 ?main()+308 CALL ssthrdmain() 00010C000 ? 000000002 ?00044D000 ? 100644B40 ?10C230000 ? 00010C230 ?_start()+380 CALL main() 000000002 ?FFFFFFFF7FFFFC48 ?000000000 ?FFFFFFFF7FFFFB48 ?FFFFFFFF7FFFFC58 ?FFFFFFFF7DB00200 ?- Binary Stack Dump -显然这是