ora-00600: internal error code, arguments: [kpotcgah-7], [12534], [ora-12534: TNS:operation not supp

author：skate
time：2012/02/25

 

ora-00600: internal error code, arguments: [kpotcgah-7], [12534], [ora-12534: TNS:operation not supported
], [], [], [], [], []

 

在alterlog里报错如下：

Thread 1 advanced to log sequence 365845
  Current log# 10 seq# 365845 mem# 0: /oracle/oracle/oracle/oradata/skate/redo10.log
Fri Feb 24 14:25:22 2012
Errors in file /oracle/oracle/oracle/admin/skate/bdump/skate_j000_16453.trc:
ora-00600: internal error code, arguments: [kpotcgah-7], [12534], [ora-12534: TNS:operation not supported
], [], [], [], [], []
Fri Feb 24 14:25:24 2012
Errors in file /oracle/oracle/oracle/admin/skate/bdump/skate_j000_16453.trc:
ora-00600: internal error code, arguments: [kpotcgah-7], [12534], [ora-12534: TNS:operation not supported
], [], [], [], [], []
Fri Feb 24 14:46:36 2012
Thread 1 advanced to log sequence 365846
  Current log# 11 seq# 365846 mem# 0: /oracle/oracle/oracle/oradata/skate/redo11.log
Fri Feb 24 15:49:55 2012

trace文件内容如下

[root@DBtmp ~]# more /oracle/oracle/oracle/admin/skate/bdump/skate_j000_16453.trc
/oracle/oracle/oracle/admin/skate/bdump/skate_j000_16453.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/oracle/oracle/product/10.2.0/db_1
System name:    Linux
Node name:      DBtmp
Release:        2.6.9-42.ELsmp
Version:        #1 SMP Wed Jul 12 23:32:02 EDT 2006
Machine:        x86_64
Instance name: skate
Redo thread mounted by this instance: 1
Oracle process number: 48
Unix process pid: 16453, image: oracle@DBtmp (J000)

*** SERVICE NAME:(SYS$USERS) 2012-02-24 14:25:22.219
*** SESSION ID:(240.32612) 2012-02-24 14:25:22.219
*** 2012-02-24 14:25:22.219
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kpotcgah-7], [12534], [ORA-12534: TNS:operation not supported
], [], [], [], [], []
----- Call Stack Trace -----
calling              call     entry                argument values in hex     
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   7FBFFF8B90 ? 7FBFFF8BF0 ?
                                                   7FBFFF8B30 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   7FBFFF8B90 ? 7FBFFF8BF0 ?
                                                   7FBFFF8B30 ? 000000000 ?
ksfdmp()+21          call     ksedmp()             000000003 ? 000000001 ?
                                                   7FBFFF8B90 ? 7FBFFF8BF0 ?
                                                   7FBFFF8B30 ? 000000000 ?
kgerinv()+161        call     ksfdmp()             000000003 ? 000000001 ?
                                                   7FBFFF8B90 ? 7FBFFF8BF0 ?
                                                   7FBFFF8B30 ? 000000000 ?
kgesinv()+33         call     kgerinv()            006618E40 ? 2A971F0040 ?
                                                   7FBFFF8BF0 ? 7FBFFF8B30 ?
                                                   000000000 ? 000000000 ?
ksesin()+211         call     kgesinv()            006618E40 ? 2A971F0040 ?
                                                   7FBFFF8BF0 ? 7FBFFF8B30 ?
                                                   000000000 ? 000000000 ?
OCIKSIN()+310        call     ksesin()             005583744 ? 000000002 ?
                                                   000000000 ? 0000030F6 ?
                                                   000000001 ? 000000027 ?
kpotcgah()+852       call     OCIKSIN()            000000001 ? 000000002 ?
                                                   005583744 ? 0000030F6 ?
                                                   000000001 ? 000000027 ?
OCIKCallHandles()+2  call     kpotcgah()           000000001 ? 7FBFFFA070 ?
8                                                  7FBFFFA300 ? 7FBFFFA310 ?
                                                   000000001 ? 000000027 ?
jsksStartOCICall()+  call     OCIKCallHandles()    000000001 ? 7FBFFFA300 ?
116                                                7FBFFF99E8 ? 7FBFFFA310 ?
                                                   000000001 ? 000000027 ?
jskcExecuteDML()+17  call     jsksStartOCICall()   00667E7E0 ? 7FBFFFA2F8 ?
0                                                  7FBFFFA2F0 ? 7FBFFFA300 ?
                                                   7FBFFFA310 ? 7FBFFFA308 ?
jskcJobUpdate()+168  call     jskcExecuteDML()     7FBFFFA3E0 ? 000000080 ?
1                                                  0054EC780 ? 0054ECB80 ?
                                                   000000020 ? 00000002A ?
jskcJobChange()+68   call     jskcJobUpdate()      3744CEA08 ? 000000080 ?
                                                   0054EC780 ? 0054ECB80 ?
                                                   000000020 ? 00000002A ?
kglspup()+92         call     jskcJobChange()      3744CEA08 ? 000000002 ?
                                                   0054EC780 ? 0054ECB80 ?
                                                   000000020 ? 00000002A ?
kqlobjchg()+3888     call     kglspup()            3744CEA08 ? 000000002 ?
                                                   0054EC780 ? 0054ECB80 ?
                                                   000000002 ? 00000002A ?
kqlchg()+1731        call     kqlobjchg()          36F5831C8 ? 000000002 ?
                                                   000000002 ? 000000000 ?
                                                   000000002 ? 00000002A ?
kglfls()+311         call     kqlchg()             000000000 ? 36F5831C8 ?
                                                   00000A648 ? 000000000 ?
                                                   000000002 ? 00000002A ?
jslvss_session_star  call     kglfls()             060003520 ? 36F5831C8 ?
t()+1091                                           00000A648 ? 000000000 ?
                                                   000000002 ? 00000002A ?
jslve_execute0()+11  call     jslvss_session_star  00667E7E0 ? 006680660 ?
85                            t()                  7FBFFFC898 ? 00000A648 ?
                                                   7FBFFFCBD0 ? 7FBFFFCC7C ?
jslve_execute()+278  call     jslve_execute0()     7FBFFFE0D8 ? 00000A648 ?
                                                   000000002 ? 7FBFFFE0C0 ?
                                                   000000000 ? 000000000 ?
rpiswu2()+420        call     jslve_execute()      7FBFFFDFC8 ? 000000002 ?
                                                   7FBFFFE0D8 ? 00000A648 ?
                                                   7FBFFFE0C0 ? 000000000 ?
kkjex1e()+367        call     rpiswu2()            37F5AF3E8 ? 000000000 ?
                                                   7FBFFFDFA4 ? 000000002 ?
                                                   7FBFFFE018 ? 000000000 ?
kkjsexe()+343        call     kkjex1e()            7FBFFFE0D8 ? 00000A648 ?
                                                   000000002 ? 7FBFFFE0C0 ?
                                                   37E8980A8 ?
                                                   BFFF000000000000 ?
kkjrdp()+892         call     kkjsexe()            7FBFFFE0D8 ? 00000A648 ?
                                                   000000002 ? 000000001 ?
                                                   37E8980A8 ?
                                                   BFFF000000000000 ?
Cannot find symbol
Cannot find symbol
Cannot find symbol
opirip()+1060        call     kkjrdp()             7FBFFFE0D8 ? 00000A648 ?
                                                   000000002 ? 000000001 ?
                                                   37E8980A8 ?
                                                   BFFF000000000000 ?
opidrv()+582         call     opirip()             000000032 ? 000000004 ?
                                                   7FBFFFF7C8 ? 000000001 ?
                                                   37E8980A8 ?
                                                   BFFF000000000000 ?
sou2o()+114          call     opidrv()             000000032 ? 000000004 ?
                                                   7FBFFFF7C8 ? 000000001 ?
                                                   37E8980A8 ?
                                                   BFFF000000000000 ?
opimai_real()+317    call     sou2o()              7FBFFFF7A0 ? 000000032 ?
                                                   000000004 ? 7FBFFFF7C8 ?
                                                   37E8980A8 ?
                                                   BFFF000000000000 ?
main()+116           call     opimai_real()        000000003 ? 7FBFFFF830 ?
                                                   000000004 ? 7FBFFFF7C8 ?
                                                   37E8980A8 ?
                                                   BFFF000000000000 ?
<0x36e8d1c3fb>       call     main()               000000003 ? 7FBFFFF830 ?
                                                   000000004 ? 7FBFFFF7C8 ?
                                                   37E8980A8 ?
                                                   BFFF000000000000 ?
 
--------------------- Binary Stack Dump ---------------------
 
========== FRAME [1] (ksedst()+31 -> ksedst1()) ==========
RAX 0000000000000000 RBX 0000002A971F0040 RBP 0000007FBFFF9660
......

查阅oracle网站，发现这是个bug。

 

报错原因：
1.oracle的”secure external password store“没有配置正确
2.wallet不在指定路径下

 

这个600的错误是因BUG 7387810而引起的，在版本11.2.0.2之后被修正。

 

解决方法
1.正确配置”secure external password store“
2.打补丁

 

参考文档 [ID 885498.1]

 

 

 

------------end---------------