« 《循序渐进Oracle》第二版一书相关代码 | Blog首页 | XDB sys_nc_oid$递归调用的案例一则 »

Invalid Login Using Trusted Authentication 错误原因

有朋友遇到了如下一系列错误，信息提示登陆非法，有人认为是恶意攻击，其实不是，从进程来看是Shared Server进程（S000）：

Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /oracle/app/product/9.2.0
System name:    AIX
Node name:    aix1
Release:    3
Version:    5
Machine:    0007D9CF4C00
Instance name: aix1
Redo thread mounted by this instance: 1
Oracle process number: 9
Unix process pid: 901474, image: oracle@aix1 (S000)

*** 2010-12-21 20:53:33.231
*** SESSION ID:(30.22410) 2010-12-21 20:53:33.226
Invalid Login Using Trusted Authentication
*** 2010-12-22 06:45:49.611
*** SESSION ID:(29.28987) 2010-12-22 06:45:49.611
Invalid Login Using Trusted Authentication
*** 2010-12-22 07:17:58.794
*** SESSION ID:(35.38904) 2010-12-22 07:17:58.794
Invalid Login Using Trusted Authentication

在这些信息之后，有如下一个600错误：

*** 2010-12-22 17:39:44.552
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qmhsesskeybuf], [], [], [], [], [], [], []
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling              call     entry                argument values in hex     
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
ksedmp+0148          bl       ksedst               1023BF3CC ?
ksfdmp+0018          bl       01FDD088            
kgerinv+00e8         bl       _ptrgl              
kgeasnmierr+004c     bl       kgerinv              70000002705DD23 ?
                                                   70000002705DD25 ? 000000004 ?
                                                   700000000027DA0 ?
                                                   FFFFFFFFFFFB180 ?
qmhGetSessKey+0044   bl       kgeasnmierr          110005D48 ? 11223FE80 ?
                                                   102610B4C ? 000000000 ?
                                                   FFFFFFFFFFFB5F0 ? 000000044 ?
                                                   000000044 ? 70000002703D770 ?
qmhInitConn+0138     bl       qmhGetSessKey        FFFFFFFFFFFB2E0 ? 1023BC8E0 ?
                                                   000000018 ? 000000127 ?
                                                   000000BB8 ?
qmps_run+0328        bl       _ptrgl              
opitsk+154c          bl       qmps_run             110005D48 ?
opiino+06ec          bl       opitsk               FFFFFFFFFFFD320 ?
                                                   42482444FFFFD410 ?
opiodr+0868          bl       _ptrgl              
opirip+02fc          bl       opiodr               3C6373635F ? 4685F7075 ?
                                                   FFFFFFFFFFFE730 ? 065747369 ?
opidrv+0300          bl       opirip               000000000 ? 000018851 ?
                                                   000000000 ?
sou2o+0028           bl       opidrv               32E0DDF00D ? 0A082ABF0 ?
                                                   000000000 ?
main+01a4            bl       01FDCC98            
__start+0090         bl       main                 000000000 ? 000000000 ?

这个600错误在MOS上有一个相关BUG：
Bug# 3238383   See Note:3238383.8
      OERI[qmhsesskeybuf] can occur during an HTTP connection to XDB
      Fixed: 9.2.0.6, 10.1.0.3, 10.2.0.1

在这个BUG中，Invalid Login Using Trusted Authentication信息会伴随出现。
该错误并无大碍，也可以通过升级或停用XDB选件来屏蔽。

这个错误给我们的提示是：如无必要，不要安装XDB选件，也不要安装你永远用不到的组件。

By eygle on 2011-08-18 21:09 | Comments (0) | Case | 2857 |

oerrorora-600