作者：大眼-猫_945 | 来源：互联网 | 2014-07-13 17:52
在做压力测试的时候，客户数据库的alertlog文件查询ORA-00600([ksires_1])错误进一步查询跟踪文件：[oracle@sxffdb1~]$more/u01/oracle/admin/ffdb/udump/ffdb1_ora_202570.trc/u01/oracle/admin/ffdb/u...
在做压力测试的时候，客户
数据库的alertlog 文件查询ORA-00600([ksires_1])错误
进一步查询跟踪文件：
[oracle@sxffdb1 ~]$ more /u01/oracle/admin/ffdb/udump/ffdb1_ora_202570.trc
/u01/oracle/admin/ffdb/udump/ffdb1_ora_202570.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/oracle/product/db10gr2
System name: AIX
Node name: sxffdb1
Release: 3
Version: 5
Machine: 00C24AC04C00
Instance name: ffdb1
Redo thread mounted by this instance: 1
Oracle process number: 215
Unix process pid: 202570, image: oracle@sxffdb1
*** ACTION NAME:(/rac/racSitemap) 2012-03-31 21:24:43.842
*** MODULE NAME:(OEM.DefaultPool) 2012-03-31 21:24:43.842
*** SERVICE NAME:(ffdb) 2012-03-31 21:24:43.842
*** CLIENT ID:(DBADM@10.223.26.177@Mozilla/4.0 (compatible; MSIE 6.0; Windows N) 2012-03-31 21:24:43.842 www.2cto.com
*** SESSION ID:(1426.565) 2012-03-31 21:24:43.842
clscugblmini: NS user global alloc failed
2012-03-31 21:24:43.848: [ default]prom_init:9:could not initialize clscugblm 3
2012-03-31 21:24:43.848: [ OCRAPI]a_init:11!: Messaging init unsuccessful : [24]
clscugblmini: NS user global alloc failed
2012-03-31 21:24:43.851: [
CSSCLNT]clsssInitNative: clscugblmini failed, rc 3
kgxgncin: CLSS init failed with status 3
kjfmsgr: unable to connect to NM for reg in shared group
*** 2012-03-31 21:24:43.851
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ksires_1], [], [], [], [], [], [], []
Current SQL statement for this session:
SELECT oldest_flashback_time www.2cto.com
FROM v$flashback_database_log
----- PL/SQL Call Stack -----
object line object
handle number name
70000063b382b48 1581 package body SYSMAN.EMD_DATABASE
70000063b382b48 1903 package body SYSMAN.EMD_DATABASE
TRACE文件中可以看到导致这个问题的SQL是：
SELECT oldest_flashback_time FROM v$flashback_database_log
这个SQL用于查询可以闪回到的最早时间点。
查询了一下MOS, 文档[ID 1311870.1] 和 这个错误最接近。
文档上说导致问题的原因是：CRS所有者用户周期性的删除目录/var/tmp下的所有CRS所有者的套接字文件。
The problem is caused by a cronjob which remove files owned by user oprdi (crs owner) under /var/tmp, which removed all CRS sockets files owned by user oprdi, this in turn causes problem at database and CRS layer. www.2cto.com
ORACLE给出的解决方法是：
Remove the cronjob which periodically clean up /var/tmp for user oprdi.
不过客户的环境并没有发现有定期删除文件的脚本。
好歹这个错误并未发现对数据库又很大影响。
作者 TOMSYAN
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有 
