一个GOOGLE不到的错误，请帮忙看一下

显示全部楼层 · 2007-10-20 08:38:44

最近生产数据库不定期崩溃，查看日志，内容如下：
----------------------------------------------
*** 2007-11-26 10:33:47.407
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ktsiseginfo1], [371], [354], [129], [], [], [], []
Current SQL statement for this session:
UPDATE FND_CONC_RELEASE_STATES SET STATUS = 1, LAST_UPDATE_DATE = sysdate, Last_Updated_By= :mgrusrid WHERE APPLICATION_ID = 0 AND CONCURRENT_STATE_NAME = 'AFPSCHED_STATUS'
----- Call Stack Trace -----
使用GOOGLE查找ktsiseginfo1关键字，只找到一条消息，而无答案。急盼您的援手。

千问 · 2007-10-20 08:38:44

metalink

千问 · 2007-10-20 08:38:44

Bug No. 4127242
Filed 18-JAN-2005 Updated 07-FEB-2007
Product Oracle Server - Enterprise Edition Product Version9.2.0.2.0
Platform HP-UX PA-RISC (64-bit) Platform Version No Data
Database Version 9.2.0.2.0 Affects PlatformsGeneric
SeveritySevere Loss of Service Status Closed, Duplicate Bug
Base Bug 2747978 Fixed in Product Version No Data
Problem statement:
ORA-00600:[KTSISEGINFO1] - BUG 2747978
--------------------------------------------------------------------------------

*** 01/18/05 01:32 am *** TAR: ---- . PROBLEM: -------- 1. Ct encountered ORA-00600:[ktsiseginfo1] . 2. Usingnote 270386.1 followed the unsupported solutionand cleared the ora-600 error. . . DIAGNOSTIC ANALYSIS: -------------------- + Support identified this to be Bug 2747978. . + Bug 2747978 describes ORA-600:[kcbnew_3] can occur after resize of a locally-managed tablespace (eith manual resizeor automatic resize). . + Ct also uploaded the files related to ORA-600:[kcbnew_3] but confirms thatthere was resizing of files or undo tablespace was not autoextesible . + As they have used unsupported solution ct wants a confirmation if they arehitting Bug 2747978 so that they can apply the one off patch to avoid anyfuture error . WORKAROUND: ----------- Usingnote 270386.1 followed the unsupported solutionand cleared the ora-600 error . RELATED BUGS: ------------- Bug 2747978 . REPRODUCIBILITY: ---------------- - . TEST CASE: ---------- - . STACK TRACE: ------------ ksedmp ksfdmp kgerinv kgeasnmierr ktsiseg_info ktugrs_get_rbs_sizektuswr ktusmous_online_und oseg ktusmaus_add_us ktubnd ktuchg ktbchg2kdtchg kdtwrp kdtInsRow insrow insdrv insexe opiexe opipls opiodr rpidrus skgmstackrpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXECC pfrrun peicnt kkxexe opiexe opiall0 kpoal8opiodr ttcpip opitsk opiino opiodr opidrv sou2o main $START$ . SUPPORTING INFORMATION: ----------------------- Will upload the alert.log and trace files . 24 HOUR CONTACT INFORMATION FOR P1 BUGS: ---------------------------------------- . DIAL-IN INFORMATION: -------------------- . IMPACT DATE: ------------ Immediately. POSCO is critical ct and 20,000 users in POSCO have to use this mail systemfor their daily business.
复制代码
[ 本帖最后由 zergduan 于 2007-11-26 17:01 编辑 ]

千问 · 2007-10-20 08:38:44

数据库的版本和OS?

千问 · 2007-10-20 08:38:44

靠note 270386.1打不开...

千问 · 2007-10-20 08:38:44

非常感谢

千问 · 2007-10-20 08:38:44

版本如下：
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
System name:
AIX
Node name:
erp1
Release:
2
Version:
5
果然打不开note 270386.1啊。

千问 · 2007-10-20 08:38:44

那就去下不补丁升级一下吧

千问 · 2007-10-20 08:38:44

开个tar问问吧，既然有metalink帐号，就要多用，要不钱不是白花了...