客户9.2.0.6 RAC出现ORA-600[17067]错误。
错误信息如下：
Wed DEC 3 00:51:02 2008 Errors IN file /ora9i/app/oracle/admin/orcl9i/udump/orcl9i2_ora_25250.trc: ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], [] Wed DEC 3 00:51:07 2008 Errors IN file /ora9i/app/oracle/admin/orcl9i/udump/orcl9i2_ora_25250.trc: ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], [] ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], [] ORA-06512: at "SYS.COPYFILE", line 0 ORA-06512: at "ORCL.AUTOUTIL", line 426 ORA-06512: at "ORCL.AUTOUTIL", line 292 ORA-06512: at line 1 Wed DEC 3 00:51:07 2008 Trace dumping IS performing id=[cdmp_20081203005107] Wed DEC 3 00:51:07 2008 Errors IN file /ora9i/app/oracle/admin/orcl9i/udump/orcl9i2_ora_25250.trc: ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], [] ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], [] ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], [] ORA-06512: at "SYS.COPYFILE", line 0 ORA-06512: at "ORCL.AUTOUTIL", line 426 ORA-06512: at "ORCL.AUTOUTIL", line 292 ORA-06512: at line 1 Wed DEC 3 00:51:08 2008 Errors IN file /ora9i/app/oracle/admin/orcl9i/udump/orcl9i2_ora_25250.trc: ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], [] ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], [] ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], [] ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], [] ORA-06512: at "SYS.COPYFILE", line 0 ORA-06512: at "ORCL.AUTOUTIL", line 426 ORA-06512: at "ORCL.AUTOUTIL", line 292 ORA-06512: at line 1 |
对应的详细TRACE如下：
*** 2008-12-03 00:51:02.208 ksedmp: internal OR fatal error ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], [] CURRENT SQL statement FOR this SESSION: BEGIN AUTOUTIL.AutoSynSingle(:1) ; END; ----- PL/SQL Call Stack ----- object line object handle NUMBER name 4b20c5828 0 PROCEDURE SYS.COPYFILE 4b20c75e8 426 package body ORCL.AUTOUTIL 4b20c75e8 292 package body ORCL.AUTOUTIL 4a9af7878 1 anonymous block ----- Call Stack Trace ----- calling CALL entry argument VALUES IN hex location TYPE point (? means dubious VALUE) -------------------- -------- -------------------- ---------------------------- ksedmp()+328 CALL ksedst() 00000000B ? 000000000 ? 000000000 ? 00000004A ? FFFFFFFF7FFEA3F8 ? 1032E18E8 ? kgeriv()+208 PTR_CALL 0000000000000000 000103705 ? 103705000 ? 103705468 ? 10370A000 ? 000102C00 ? 000000000 ? kgeasi()+180 CALL kgeriv() 1037056C8 ? 103821CF8 ? 000000258 ? 0000013C8 ? FFFFFFFF7FFEDD18 ? 103706A98 ? kglrel()+128 CALL kgeasi() 1037056C8 ? 103821CF8 ? 0000042AB ? 000000002 ? 000000001 ? 000000004 ? jox24_update_lock() CALL kglrel() 1037056C8 ? +340 FFFFFFFF7C99C3F8 ? 000000000 ? FFFFFFFF7FFF7810 ? FFFFFFFF7FFEDB28 ? FFFFFFFF7FFEDA58 ? ioc_lookup_name()+8 CALL jox24_update_lock() 1037056C8 ? 0000053F0 ? 560 000005000 ? 4B6C1E380 ? 102EBA200 ? FFFFFFFF7FFF7810 ? iocbf_lookup_name() CALL FFFFFFFF7EA3E580 000000000 ? 4B6C1E380 ? +8 FFFFFFFF7C980150 ? 1037056C8 ? FFFFFFFF7EA38700 ? FFFFFFFF7E858558 ? ioc_do_call()+276 PTR_CALL 0000000000000000 FFFFFFFF7FFF7810 ? FFFFFFFF7FFEF4B8 ? 000000000 ? 000005000 ? 103705808 ? 000000000 ? joet_switched_env_c CALL FFFFFFFF7EA4E780 0000012E0 ? allback()+356 FFFFFFFF7E81DA20 ? 000000000 ? FFFFFFFF7FFF7398 ? 00000000C ? FFFFFFFF7FFEF3E8 ? ioct_lookup_name()+ CALL joet_switched_env_c FFFFFFFF7C7BE17C ? 56 allback() 0FFFFFFFF ? FFFFFFFF7E81DA20 ? FFFFFFFF7FFEF4B8 ? FFFFFFFF7FFEFFA0 ? FFFFFFFFFFFFFFFF ? jom_lookup_active_c CALL ioct_lookup_name() FFFFFFFF7FFF7810 ? lint_internal()+219 FFFFFFFF7C7BE17C ? 6 FFFFFFFF7FFEF598 ? 000000001 ? 000000000 ? FFFFFFFF7FFEF5E9 ? jom_lookup_active_c CALL jom_lookup_active_c 000000001 ? 000004000 ? lint()+32 lint_internal() 000004300 ? 000000000 ? 000000000 ? 000000000 ? jon_find_class()+68 CALL jom_lookup_active_c FFFFFFFF7C7BE17C ? 8 lint() FFFFFFFF7C8761B8 ? 00000001D ? 000000000 ? 000000000 ? 000000001 ? joncla_for_name0()+ CALL jon_find_class() FFFFFFFF7C7BE17C ? 224 FFFFFFFF7C8761B8 ? 00000001D ? 000000000 ? 000000000 ? 000000000 ? jtcfs_ffa206dc14_ja CALL FFFFFFFF7C16A880 FFFFFFFF7C7BE17C ? va_lang_Class__forN 1038C26A3 ? 481E01BBC ? ame0()+92 000000001 ? 000000000 ? 000000000 ? jtcfs_ffa206dc14_ja CALL jtcfs_ffa206dc14_ja FFFFFFFF7C7BE17C ? va_lang_Class__forN va_lang_Class__forN FFFFFFFF7FFEFC10 ? ame__1()+168 ame0() 1038C26A3 ? 481E01BBC ? 000000001 ? 000000000 ? jtcmcalld_ffa206dc1 PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? 4_OracleDriver_7__j FFFFFFFF7FFF0548 ? ava_lang_Class__for 1038C26A3 ? 481E01BBC ? Name__1()+48 FFFFFFFF7FFEFD6B ? FFFFFFFF7FFEFD6A ? jtcfv_ffa206dc14_or CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? acle_jdbc_driver_Or 4_OracleDriver_7__j FFFFFFFF7FFF0548 ? acleDriver__getConn ava_lang_Class__for 1038C732B ? 481E01BBC ? ectionInstance()+92 Name__1() 000000049 ? 000000000 ? 08 jtcfv_ffa206dc14_or CALL jtcfv_ffa206dc14_or FFFFFFFF7C7BE17C ? acle_jdbc_driver_Or acle_jdbc_driver_Or FFFFFFFF7C7BE17C ? acleDriver__connect acleDriver__getConn 000000000 ? ()+8508 ectionInstance() FFFFFFFF7FFF0548 ? FFFFFFFF7C869D40 ? 1038C732B ? jtcfs_ffa206dc14_ja CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? va_sql_DriverManage 4_DriverManager_7__ FFFFFFFF7C86E4B8 ? r__getConnection()+ java_sql_Driver__co 1038C732B ? 4768 nnect() FFFFFFFF7FFF06E8 ? 1038C7328 ? FFFFFFFF7C875660 ? jtcfs_ffa206dc14_ja CALL jtcfs_ffa206dc14_ja FFFFFFFF7C875660 ? va_sql_DriverManage va_sql_DriverManage 000000000 ? r__getConnection__1 r__getConnection() FFFFFFFF7C870068 ? ()+728 FFFFFFFF7C8758D0 ? FFFFFFFF7C870068 ? FFFFFFFF7C870068 ? jtcmcalld_ffa206dc1 PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? 4_OracleDriver_7__j FFFFFFFF7C2C3039 ? ava_sql_DriverManag 1038DB593 ? 481E01674 ? er__getConnectio()+ 000000001 ? 000000003 ? 336 jtcfv_ffa206dc14_or CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? acle_jdbc_driver_Or 4_OracleDriver_7__j FFFFFFFF7FFF10C0 ? acleDriver__default ava_sql_DriverManag 000000000 ? 481E01674 ? Connection()+452 er__getConnection__ FFFFFFFF7C347420 ? 1() 00001F000 ? jtcmcalldm_ffa206dc PTR_CALL 0000000000000000 FFFFFFFF78C0C290 ? 14_VersionedObject_ FFFFFFFF7FFF1460 ? 7__oracle_jdbc_driv 1038C732B ? 000006C00 ? er_OracleDriver_()+ FFFFFFFF7C2C3039 ? 388 481E0929D ? jtcfclinit_ffa206dc CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? 14_oracle_aurora_rd 4_VersionedObject_7 FFFFFFFF7FFF1460 ? bms_security_Versio __oracle_jdbc_drive 000000000 ? nedObject()+1100 r_OracleDriver__def FFFFFFFF7C875650 ? a() FFFFFFFF7C2C3039 ? FFFFFFFF7FFF11D8 ? jtcisfclinit_ffa206 CALL jtcfclinit_ffa206dc 000000003 ? 1038D8F20 ? dc14_oracle_aurora_ 14_oracle_aurora_rd FFFFFFFF7C875650 ? rdbms_security_Vers bms_security_Versio FFFFFFFF7FFF1460 ? ionedObject()+72 nedObject() FFFFFFFF7FFF1460 ? 481C4E29C ? joe_init_class()+18 PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? 68 1038D8E53 ? FFFFFFFF7C2BBF90 ? FFFFFFFF7C2BBF90 ? 0000054F8 ? FFFFFFFF7EA5BE30 ? jtc_make_instance_w CALL joe_init_class() FFFFFFFFFFFFFFEB ? ith_cpool()+168 1038D8E50 ? FFFFFFFF78087200 ? 000000849 ? FFFFFFFF7C2C3039 ? FFFFFFFF7C7BE17C ? jtcfc_ffa206dc14_or CALL FFFFFFFF781C0FC0 FFFFFFFF7C7BE17C ? acle_aurora_rdbms_s FFFFFFFF7FFF1C08 ? ecurity_PolicyTable 1038D8D7B ? 000000002 ? _8_MyVersionedOb()+ 000000012 ? 000000000 ? 560 jtcfc_ffa206dc14_or CALL jtcfc_ffa206dc14_or FFFFFFFF7C7BE17C ? acle_aurora_rdbms_s acle_aurora_rdbms_s FFFFFFFF7FFF1CF8 ? ecurity_PolicyTable ecurity_PolicyTable 1038D8D7B ? ()+2244 _8_MyVersionedObjec FFFFFFFF7C875548 ? t() FFFFFFFF7C869368 ? 481E57164 ? jtctord_ffa206dc14_ PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? SecurityManagerImpl FFFFFFFF7C875548 ? _7__oracle_aurora_r 1038D9B13 ? dbms_security_Po()+ FFFFFFFF7C872900 ? 464 FFFFFFFF7C869368 ? FFFFFFFF7C872B60 ? jtcfv_ffa206dc14_or CALL jtctord_ffa206dc14_ FFFFFFFF7C7BE17C ? acle_aurora_rdbms_S SecurityManagerImpl FFFFFFFF7FFF2308 ? ecurityManagerImpl_ _7__oracle_aurora_r 1038C9603 ? _getPolicyTable()+2 dbms_security_Polic FFFFFFFF7C872900 ? 424 y() FFFFFFFF7C872AC8 ? 481E90F7C ? jtcfc_ffa206dc14_or CALL jtcfv_ffa206dc14_or 0000003BA ? acle_aurora_rdbms_S acle_aurora_rdbms_S FFFFFFFF7FFF2308 ? ecurityManagerImpl( ecurityManagerImpl_ 481E66298 ? 0000003B2 ? )+140 _getPolicyTable() 481E5710C ? 07FFF1A41 ? jtcfv_ffa206dc14_or CALL jtcfc_ffa206dc14_or FFFFFFFF7C7BE17C ? acle_aurora_rdbms_E acle_aurora_rdbms_S FFFFFFFF7FFF24D0 ? nvironmentSpecificI ecurityManagerImpl( 1038C9603 ? mpl__securityMan()+ ) FFFFFFFF7C869C60 ? 544 0000000A4 ? FFFFFFFF7C869CF0 ? jtcmcalldm_ffa206dc PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? 14_EnvironmentSpeci FFFFFFFF7FFF26B8 ? fic_7__oracle_auror 1038CDE63 ? a_vm_Environment()+ FFFFFFFF7AF5E5E8 ? 388 FFFFFFFF7AF74EB8 ? 000000011 ? jtcfs_ffa206dc14_or CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? acle_aurora_vm_Envi 4_EnvironmentSpecif FFFFFFFF7FFF26B8 ? ronmentSpecific__se ic_7__oracle_aurora 000000000 ? curityManager()+724 _vm_EnvironmentSpec FFFFFFFF7C862AA8 ? i() FFFFFFFF7C2C3039 ? FFFFFFFF7FFF25E8 ? jtcmcalld_ffa206dc1 PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? 4_System_7__oracle_ 000000001 ? 1038C323B ? aurora_vm_Environme 481FC9A50 ? 000000000 ? ntSpecific__secu()+ 1038C3300 ? 320 jtcfs_ffa206dc14_ja CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? va_lang_System__set 4_System_7__oracle_ FFFFFFFF7FFF2910 ? SecurityManager()+1 aurora_vm_Environme 1038C5A43 ? 36 ntSpecific__securit FFFFFFFF7BFCC828 ? y() 0001A0B1C ? FFFFFFFF7C1657E8 ? jtcfs_ffa206dc14_ja CALL jtcfs_ffa206dc14_ja FFFFFFFF7C7BE17C ? va_lang_System__ini va_lang_System__set FFFFFFFF7FFF2E10 ? tializeSystemClass( SecurityManager() 1038C5A43 ? 481FCF29C ? )+5064 FFFFFFFF7C2C3039 ? 1038C5A40 ? jtcisfs_ffa206dc14_ CALL jtcfs_ffa206dc14_ja FFFFFFFF7C7BE17C ? java_lang_System__i va_lang_System__ini 000000308 ? 1038C5A43 ? nitializeSystemClas tializeSystemClass( FFFFFFFF7C85DD80 ? s()+80 ) FFFFFFFF7C868FA0 ? FFFFFFFF7C867A68 ? joet_initialize_sys PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? tem_class()+1068 1038C5A43 ? FFFFFFFF7C2BBF48 ? FFFFFFFF7C2BBF48 ? 000000848 ? 000000000 ? joet_aux_thread_mai CALL joet_initialize_sys 000000021 ? 000000000 ? n()+1248 tem_class() 1038BFCF3 ? 1038BFCF0 ? 000000000 ? FFFFFFFF7E857208 ? joet_thread_main()+ CALL joet_aux_thread_mai 000000001 ? 16 n() FFFFFFFF7C2C4139 ? 49DC5D9FC ? 000000000 ? 1038BFCF0 ? FFFFFFFF7C7BE17C ? sjontlo_initialize( PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? )+84 FFFFFFFF7C2C4139 ? FFFFFFFFFFFFFFFF ? FFFFFFFFFFFFFFF8 ? 000000000 ? FFFFFFFF7FFF4309 ? joe_enter_vm()+1728 CALL sjontlo_initialize( FFFFFFFF7C7BE17C ? ) FFFFFFFF7E76A020 ? FFFFFFFF7C2C4139 ? 000005220 ? FFFFFFFF7C2C4139 ? 000000001 ? ioei_call_java()+27 CALL joe_enter_vm() FFFFFFFF7FFF7810 ? 20 FFFFFFFF7FFF4B88 ? 000000000 ? 000000000 ? 000000000 ? 000000000 ? ioe_call_java()+320 CALL ioei_call_java() 000000000 ? 000000000 ? FFFFFFFF7FFF4DC8 ? 000000002 ? FFFFFFFF7FFF4B88 ? FFFFFFFFFFFFFFB9 ? jox_invoke_java_()+ CALL FFFFFFFF7EA3F0C0 FFFFFFFF7FFF7810 ? 3816 49DC596A8 ? 49DC5D9FC ? 000000008 ? 4B6CF3635 ? 000000027 ? jox_invoke_java()+9 CALL 00000001037017E0 102EBA200 ? 1037056C8 ? 6 103705808 ? 000000008 ? 4B6CF362C ? 000000000 ? kkxmjexe()+528 CALL jox_invoke_java() 1037056C8 ? 00000000E ? 10383C388 ? 000000002 ? 000000000 ? 4B6CF365D ? kgmexcb()+40 PTR_CALL 0000000000000000 000000000 ? 4B6CF35A8 ? 000000000 ? 4B6CF362C ? 00000000E ? 000000008 ? rpiswu2()+384 PTR_CALL 0000000000000000 FFFFFFFF7FFF83F0 ? 100229D50 ? 000000000 ? FFFFFFFF7FFF8448 ? 00000000A ? FFFFFFFEFC7D2480 ? kkxmswu()+196 CALL rpiswu2() 48F93E2A0 ? 000103705 ? 103705690 ? 1037056C8 ? 000000000 ? 10329F000 ? kgmexwi()+1452 PTR_CALL 0000000000000000 000000001 ? 000000000 ? FFFFFFFF7FFF898C ? FFFFFFFFFFFFFFFF ? 000000001 ? 000000003 ? kgmexec()+896 CALL kgmexwi() 00003B418 ? FFFFFFFF7C980EC0 ? FFFFFFFF7FFF83F0 ? FFFFFFFF7C980E48 ? 4B20C5828 ? 102EBAEA0 ? pefjavacal()+408 CALL kgmexec() 4B20C5828 ? 4B6CF35A8 ? FFFFFFFF7FFF8930 ? 1037056C8 ? 1036C47E8 ? 000000001 ? pefcal()+84 CALL pefjavacal() FFFFFFFF7FFF8CA8 ? 0001023C3 ? 10383C230 ? 1023C3000 ? FFFFFFFF7FFFB000 ? FFFFFFFF7C981348 ? pevm_FCAL()+124 CALL pefcal() FFFFFFFF7FFF8CA8 ? FFFFFFFF7C981DB8 ? 000000000 ? 000000000 ? 4B6CF31D0 ? 4B6CF3200 ? pfrrun()+14580 CALL pevm_FCAL() FFFFFFFF7CA67BC8 ? 4B6CF32E8 ? 000000000 ? 0000000E8 ? 4B6CF32E8 ? 000000004 ? peicnt()+268 CALL pfrrun() 000102ECF ? FFFFFFFF7FFFB000 ? FFFFFFFF7CA67BC8 ? FFFFFFFF7CA67C30 ? 48F93ED00 ? 103705808 ? kkxexe()+524 CALL peicnt() FFFFFFFF7FFFB000 ? FFFFFFFF7CA67BC8 ? 000000009 ? 10382FCB8 ? 000102C00 ? FFFFFFFF7FFFAE78 ? opiexe()+9256 CALL kkxexe() 000103400 ? 000000000 ? 00000FFFB ? FFFFFFFF7CA67BC8 ? 000000000 ? 103705468 ? opiall0()+1776 CALL opiexe() 00000002E ? 10370D808 ? FFFFFFFF7CA60490 ? 10370D800 ? FFFFFFFF7CA69068 ? 103705808 ? kpoal8()+1040 CALL opiall0() 000000000 ? 00000005E ? FFFFFFFF7FFFC118 ? 103705808 ? FFFFFFFF7CA69068 ? FFFFFFFF7FFFC4A8 ? opiodr()+1688 PTR_CALL 0000000000000000 000000000 ? 000000000 ? FFFFFFFF7FFFE960 ? 000000024 ? 000000000 ? 0000022B0 ? ttcpip()+1556 PTR_CALL 0000000000000000 000103400 ? 100FBBFC0 ? 10370D808 ? 103705808 ? 103707D40 ? FFFFFFFF7FFFCB00 ? opitsk()+984 CALL ttcpip() 10370D800 ? 000000014 ? FFFFFFFF7FFFE960 ? 000000000 ? 000000000 ? FFFFFFFF7FFFDC4C ? opiino()+1572 CALL opitsk() 000000000 ? 000000000 ? 000000000 ? 000000000 ? 103707D28 ? FFFFFFFF7FFFEAB4 ? opiodr()+1688 PTR_CALL 0000000000000000 000380007 ? 10370C658 ? 1037F9458 ? FFFFFFFF7FFFF7F0 ? 000000000 ? 492889EF8 ? opidrv()+736 CALL opiodr() 000103400 ? 10100C380 ? 10370D808 ? 103705808 ? 103707D40 ? FFFFFFFF7FFFF310 ? sou2o()+16 CALL opidrv() 000000000 ? 000000004 ? 1037051EC ? 00000003C ? 1037056C8 ? 000103400 ? main()+184 CALL sou2o() FFFFFFFF7FFFF810 ? 00000003C ? 000000004 ? FFFFFFFF7FFFF7F0 ? 000039E70 ? 000000000 ? _start()+380 CALL main() 000000002 ? FFFFFFFF7FFFF958 ? FFFFFFFF7FFFF970 ? 000000000 ? 000000000 ? 100000000 ? --------------------- Binary Stack Dump --------------------- |
根据MOS文档Bug 3691672 – OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON [ID 3691672.8]，这是9206上访问JAVA程序的bug。当高并发访问数据库中的JAVA程序，可能会引发这个错误。
SQL> SELECT TEXT FROM DBA_SOURCE WHERE NAME = 'COPYFILE' ORDER BY LINE; TEXT ---------------------------------------------------------------------------------------- PROCEDURE CopyFile(sOldFileName IN varchar2,sNewFileName IN varchar2) AS LANGUAGE JAVA NAME 'XhphotoFileUtil.copyFile(java.lang.String, java.lang.String)'; |
当前的会话堆栈中存在大量JAVA过程的调用，检查报错调用的COPYFILE过程，果然是存储在数据库中的JAVA存储过程。
Oracle在9.2.0.7、10.1.0.4和10.2.0.1中解决了这个错误。