ORA-600(17067)错误

客户9.2.0.6 RAC出现ORA-600[17067]错误。

[@more@]

错误信息如下：

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中解决了这个错误。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-1060718/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-1060718/