{"id":853,"date":"2012-05-18T23:59:32","date_gmt":"2012-05-18T15:59:32","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=853"},"modified":"2012-05-19T01:36:29","modified_gmt":"2012-05-18T17:36:29","slug":"ora-600kglobpn-bad-pga%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=853","title":{"rendered":"ORA-600(kglobpn-bad-pga)\u9519\u8bef"},"content":{"rendered":"<p>\u8fd9\u4e2a\u9519\u8bef\u6bd4\u8f83\u7f55\u89c1\uff0c\u65e0\u8bba\u662fGOOGLE\u8fd8\u662fMETALINK\u90fd\u627e\u4e0d\u5230\u4efb\u4f55\u7684\u76f8\u5173\u4fe1\u606f\u3002<br \/>\n\u6570\u636e\u5e93\u7248\u672c\u662f11.2.0.2 RAC\u73af\u5883\uff0c\u8fd9\u4e2a\u9519\u8bef\u4e4b\u6240\u4ee5\u8fd9\u4e48\u7f55\u89c1\uff0c\u4e5f\u548c11.2\u7684\u7248\u672c\u592a\u65b0\uff0c\u4ee5\u81f4\u4e8e\u5f88\u591a\u95ee\u9898\u90fd\u8fd8\u6ca1\u6709\u66b4\u9732\u51fa\u6765\u6709\u5173\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>2012-03-29 04:06:02.353000 +08:00\r\nErrors in file \/oracle\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_ora_18355.trc (incident=144401):\r\nORA-00600: internal error code, arguments: [kglobpn-bad-pga], [], [], [], [], [], [], [], [], [], [], []\r\nIncident details in: \/oracle\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_144401\/orcl1_ora_18355_i144401.trc\r\n2012-03-29 04:10:12.017000 +08:00\r\nDumping diagnostic data in directory=[cdmp_20120329041012], requested by (instance=1, osid=18355), summary=[incident=144401].\r\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\n2012-03-29 04:10:13.750000 +08:00\r\nSweep [inc][144401]: completed\r\nSweep [inc2][144401]: completed<\/pre>\n<p>\u8be6\u7ec6\u7684TRACE\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>*** 2012-03-29 04:06:02.385\r\n*** SESSION ID:(106.45) 2012-03-29 04:06:02.385\r\n*** CLIENT ID:() 2012-03-29 04:06:02.385\r\n*** SERVICE NAME:(orcl) 2012-03-29 04:06:02.385\r\n*** MODULE NAME:(PL\/SQL Developer) 2012-03-29 04:06:02.385\r\n*** ACTION NAME:(Main session) 2012-03-29 04:06:02.385\r\nDump continued from file: \/oracle\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_ora_18355.trc\r\nORA-00600: internal error code, arguments: [kglobpn-bad-pga], [], [], [], [], [], [], [], [], [], [], []\r\n========= Dump for incident 144401 (ORA 600 [kglobpn-bad-pga]) ========\r\n*** 2012-03-29 04:06:02.426\r\ndbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)\r\n----- Current SQL Statement for this session (sql_id=8m7jgqrwrtyj1) -----\r\nCREATE OR REPLACE TRIGGER N_TRIGGER\r\n  AFTER INSERT OR UPDATE ON T\r\n  FOR EACH ROW\r\nDECLARE\r\n.\r\n.\r\n.\r\nEND;\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst1()+96         CALL     skdstdst()           FFFFFFFF7FFEED60 ?\r\n                                                   1006B0C80 ? 000000000 ?\r\n                                                   00000000A ? 000000001 ?\r\n                                                   10BD95B00 ?\r\nksedst()+60          CALL     ksedst1()            000000000 ? 000000001 ?\r\n                                                   00010C212 ? 00010C000 ?\r\n                                                   10C20A000 ? 00010C20A ?\r\ndbkedDefDump()+2032  CALL     ksedst()             000000000 ? 10B25B000 ?\r\n                                                   10B25B2B0 ? 10C212000 ?\r\n                                                   00010B000 ? 00010C212 ?\r\ndbgexPhaseII()+1800  PTR_CALL dbkedDefDump()       000000003 ? 000000002 ?\r\n                                                   10A6EC2C8 ? 0000014B0 ?\r\n                                                   10C20A000 ? 000000003 ?\r\ndbgexProcessError()  CALL     dbgexPhaseII()       10C3B4650 ?\r\n+1248                                              FFFFFFFF7BE3A578 ?\r\n                                                   FFFFFFFF7FFF3AB8 ?\r\n                                                   0018E0000 ? 10A6E35B8 ?\r\n                                                   000001C00 ?\r\ndbgePostErrorKGE()+  CALL     dbgeExecuteForError  10AE0C3FD ?\r\n1320                          ()                   FFFFFFFFFEC0B62D ?\r\n                                                   001050000 ?\r\n                                                   FFFFFFFF7FFF6268 ?\r\n                                                   001060000 ? 000000028 ?\r\ndbkePostKGE_kgsf()+  CALL     dbgePostErrorKGE()   10C20AC90 ? 000000000 ?\r\n44                                                 FFFFFFFF7BE3A578 ?\r\n                                                   000000000 ? 000000258 ?\r\n                                                   00010C000 ?\r\nkgerinv_internal()+  CALL     kgeadse()            10C20AC90 ?\r\n72                                                 FFFFFFFF7D1042C0 ?\r\n                                                   000000258 ? 000002868 ?\r\n                                                   10A6E4000 ? 00010A6E4 ?\r\nkgerinv()+40         CALL     kgerinv_internal()   10C20AC90 ? 004EA2360 ?\r\n                                                   10BDED4D0 ? 000000258 ?\r\n                                                   000000000 ? 000000000 ?\r\nkgeasnmierr()+28     CALL     kgerinv()            10C20AC90 ?\r\n                                                   FFFFFFFF7D1042C0 ?\r\n                                                   10BDED4D0 ? 000000000 ?\r\n                                                   FFFFFFFF7FFF7630 ?\r\n                                                   000001400 ?\r\nkglobpn()+2972       CALL     kgeasnmierr()        10C20AC90 ?\r\n                                                   FFFFFFFF7D1042C0 ?\r\n                                                   10BDED4D0 ? 000000000 ?\r\n                                                   0000060A6 ? 00000005B ?\r\nkglpim()+444         CALL     kglobpn()            FFFFFFFFFFBEC700 ?\r\n                                                   10C20AC90 ? 0000020BE ?\r\n                                                   000000000 ? CF6AF45C8 ?\r\n                                                   D163B01D0 ?\r\nkktcrt()+1204        CALL     kglpim()             000001154 ?\r\n                                                   FFFFFFFF7FFF7EC8 ?\r\n                                                   D163B01D0 ? 000000002 ?\r\n                                                   000000006 ? 00000004E ?\r\nopiexe()+24660       CALL     kktcrt()             000006000 ?\r\n                                                   FFFFFFFF7BC19328 ?\r\n                                                   D1772AAE0 ? 10C20A950 ?\r\n                                                   FFFFFFFF7BC190C0 ?\r\n                                                   000000002 ?\r\nopiosq0()+6416       CALL     opiexe()             000000004 ? 000000000 ?\r\n                                                   FFFFFFFF7FFFA43C ?\r\n                                                   00010A6E3 ? 10A6E3000 ?\r\n                                                   FFFFFFFF7FFF9E10 ?\r\nkpooprx()+232        CALL     opiosq0()            00000004A ? 00000000E ?\r\n                                                   FFFFFFFF7FFFA600 ?\r\n                                                   0000000A4 ? 00010A6E3 ?\r\n                                                   10C20AC90 ?\r\nkpoal8()+3884        CALL     kpooprx()            FFFFFFFF7FFFDF3C ?\r\n                                                   FFFFFFFF7DFD0660 ?\r\n                                                   0000015EC ? 0000000A4 ?\r\n                                                   00010C000 ? 0000000A4 ?\r\nopiodr()+1428        PTR_CALL kpoal8()             00000005E ? 00000001C ?\r\n                                                   FFFFFFFF7FFFDF38 ?\r\n                                                   00010C000 ? 10C20A000 ?\r\n                                                   000001648 ?\r\nttcpip()+1056        PTR_CALL opiodr()             00010A795 ? 00000001C ?\r\n                                                   103EAD460 ? 00010A400 ?\r\n                                                   000001400 ? 10C20A000 ?\r\nopitsk()+1528        CALL     ttcpip()             000000000 ? 10A6C7694 ?\r\n                                                   10C20AC90 ?\r\n                                                   FFFFFFFF7FFFDF38 ?\r\n                                                   FFFFFFFF7FFFC980 ?\r\n                                                   10C221848 ?\r\nopiino()+1000        CALL     opitsk()             10A6C7694 ? 10C226C98 ?\r\n                                                   10C221654 ? 10C21F958 ?\r\n                                                   000000000 ? 10C20A950 ?\r\nopiodr()+1428        PTR_CALL opiino()             00010C000 ? 10C2216D0 ?\r\n                                                   10C2216D0 ? 000380000 ?\r\n                                                   0000000E9 ?\r\n                                                   FFFFFFFF7FFFF890 ?\r\nopidrv()+1100        CALL     opiodr()             10C221000 ? 000000004 ?\r\n                                                   1035DD740 ? 00010C000 ?\r\n                                                   000001400 ? 10C20A000 ?\r\nsou2o()+92           CALL     opidrv()             00000003C ? 000000004 ?\r\n                                                   FFFFFFFF7FFFF890 ?\r\n                                                   0001EB250 ?\r\n                                                   FFFFFFFF7C945110 ?\r\n                                                   FFFFFFFF7FFFFC98 ?\r\nopimai_real()+304    CALL     sou2o()              FFFFFFFF7FFFF868 ?\r\n                                                   00000003C ? 000000004 ?\r\n                                                   FFFFFFFF7FFFF890 ?\r\n                                                   00010C000 ? 00010B800 ?\r\nssthrdmain()+320     PTR_CALL opimai_real()        000000000 ?\r\n                                                   FFFFFFFF7FFFFB38 ?\r\n                                                   FFFFFFFF7F900768 ?\r\n                                                   00010B800 ? 000000001 ?\r\n                                                   000000002 ?\r\nmain()+308           CALL     ssthrdmain()         00010C000 ? 000000002 ?\r\n                                                   00044D000 ? 100644B40 ?\r\n                                                   10C230000 ? 00010C230 ?\r\n_start()+380         CALL     main()               000000002 ?\r\n                                                   FFFFFFFF7FFFFC48 ?\r\n                                                   000000000 ?\r\n                                                   FFFFFFFF7FFFFB48 ?\r\n                                                   FFFFFFFF7FFFFC58 ?\r\n                                                   FFFFFFFF7DB00200 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u663e\u7136\u8fd9\u662f\u5229\u7528PL\/SQL Developer\u5728\u521b\u5efa\u4e00\u4e2a\u89e6\u53d1\u5668\uff0c\u7531\u4e8e\u89e6\u53d1\u5668\u7684\u5185\u5bb9\u5f88\u957f\uff0c\u8fd9\u91cc\u5c06\u5176\u7701\u7565\u4e86\u3002<br \/>\n\u867d\u7136\u6ca1\u6709MOS\u7684\u4f50\u8bc1\uff0c\u4f46\u662f\u4e0d\u96be\u5224\u65ad\uff0c\u95ee\u9898\u5904\u5728PL\/SQL Developer\u5728\u7f16\u8bd1\u89e6\u53d1\u5668\u65f6\u4e0eOracle\u7684\u914d\u5408\u4e0a\u3002\u867d\u7136\u4e0d\u80fd\u786e\u5b9a\u95ee\u9898\u5bfc\u81f4\u7684\u539f\u56e0\u5c31\u662fDeveloper\uff0c\u4f46\u662f\u8fd9\u4e2a\u9519\u8bef\u7684\u4ea7\u751f\u80af\u5b9a\u4e0e\u5de5\u5177\u6709\u5173\uff0c\u56e0\u4e3a\u5f88\u591a\u7f55\u89c1\u7684\u9519\u8bef\u90fd\u662f\u5de5\u5177\u5f15\u5165\u7684\uff0c\u800cDevelper\u5f15\u5165\u7684ORA-7445\u548cORA-600\u9519\u8bef\u6211\u8fd9\u4e2a\u51e0\u4e4e\u4e0d\u7528\u5de5\u5177\u7684\u4eba\u90fd\u5df2\u7ecf\u78b0\u5230\u5f88\u591a\u4e2a\u4e86\uff0c\u96be\u514d\u8fd9\u4e2a\u95ee\u9898\u4e0d\u662fDeveloper\u4e0e\u6700\u65b0\u7248\u7684ORACLE\u4e0d\u517c\u5bb9\u6240\u81f4\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8fd9\u4e2a\u9519\u8bef\u6bd4\u8f83\u7f55\u89c1\uff0c\u65e0\u8bba\u662fGOOGLE\u8fd8\u662fMETALINK\u90fd\u627e\u4e0d\u5230\u4efb\u4f55\u7684\u76f8\u5173\u4fe1\u606f\u3002 \u6570\u636e\u5e93\u7248\u672c\u662f11.2.0.2 RAC\u73af\u5883\uff0c\u8fd9\u4e2a\u9519\u8bef\u4e4b\u6240\u4ee5\u8fd9\u4e48\u7f55\u89c1\uff0c\u4e5f\u548c11.2\u7684\u7248\u672c\u592a\u65b0\uff0c\u4ee5\u81f4\u4e8e\u5f88\u591a\u95ee\u9898\u90fd\u8fd8\u6ca1\u6709\u66b4\u9732\u51fa\u6765\u6709\u5173\u3002 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a 2012-03-29 04:06:02.353000 +08:00 Errors in file \/oracle\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_ora_18355.trc (incident=144401): ORA-00600: internal error code, arguments: [kglobpn-bad-pga], [], [], [], [], [], [], [], [], [], [], [] Incident details in: \/oracle\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_144401\/orcl1_ora_18355_i144401.trc 2012-03-29 04:10:12.017000 +08:00 Dumping diagnostic data in &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=853\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[721,8,720,483],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-dL","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/853"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=853"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/853\/revisions"}],"predecessor-version":[{"id":854,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/853\/revisions\/854"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}