标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (102)
- 数据库 (1,678)
- DB2 (22)
- MySQL (73)
- Oracle (1,540)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (67)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (563)
- Oracle安装升级 (92)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (79)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- .wstop扩展名勒索数据库恢复
- Oracle Recovery Tools工具一键解决ORA-00376 ORA-01110故障(文件offline)
- OGG-02771 Input trail file format RELEASE 19.1 is different from previous trail file form at RELEASE 11.2.
- OGG-02246 Source redo compatibility level 19.0.0 requires trail FORMAT 12.2 or higher
- GoldenGate 19安装和打patch
- dd破坏asm磁盘头恢复
- 删除asmlib磁盘导致磁盘组故障恢复
- Kylin Linux 安装19c
- ORA-600 krse_arc_complete.4
- Oracle 19c 202410补丁(RUs+OJVM)
- ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复
- .mkp扩展名oracle数据文件加密恢复
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
- ORA-01092 ORA-00604 ORA-01558故障处理
- ORA-65088: database open should be retried
- Oracle 19c异常恢复—ORA-01209/ORA-65088
- ORA-600 16703故障再现
标签归档:ORA-600[12235]
ORA-600 [12235]
今天早上例行对各个区域数据库服务器进行检查,发现内蒙古电信的数据库服务器出现ORA-600 [12235]错误
一、错误现象
alert_txzldb.log日志: Sun Nov 6 09:34:57 2011 Errors in file /opt/oracle/admin/txzldb/bdump/txzldb_ora_8253.trc: ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], [] txzldb_ora_8253.trc内容: Oracle program name: oracle@database.localdomain *** 2011-11-06 09:34:57.530 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], [] Current SQL information unavailable - no session. ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp()+269 call ksedst()+0 0 ? 0 ? 0 ? 0 ? 0 ? 0 ? ksfdmp()+14 call ksedmp()+0 3 ? BFFFECA0 ? 98584A4 ? AD58F60 ? 3 ? A4B929C ? kgeriv()+188 call ksfdmp()+0 AD58F60 ? 3 ? kgesiv()+113 call kgeriv()+0 AD58F60 ? 0 ? 2FCB ? 0 ? BFFFED0C ? ksesic0()+39 call kgesiv()+0 AD58F60 ? 0 ? 2FCB ? 0 ? BFFFED0C ? 2FCB ? 0 ? BFFFED0C ? opirip()+519 call ksesic0()+0 2FCB ? AD5903C ? BFFFF6AC ? FFFFFFFF ? BFFFF814 ? 1 ? opidrv()+462 call opirip()+0 32 ? 0 ? 0 ? sou2o()+25 call opidrv()+0 32 ? 0 ? 0 ? main()+355 call sou2o()+0 BFFFF814 ? 32 ? 0 ? 0 ? BFFFF840 ? 0 ? __libc_start_main() call main()+0 1 ? BFFFF894 ? BFFFF89C ? +161 96DFD4 ? 1 ? 8208E40 ? --------------------- Binary Stack Dump --------------------- ========== FRAME [1] (ksedmp()+269 -> ksedst()+0) ========== Dump of memory from 0xBFFFEB64 to 0xBFFFEC64 BFFFEB60 BFFFEC64 0820B6F8 00000000 [d..... .....] BFFFEB70 00000000 00000000 00000000 00000000 [................] Repeat 2 times ………………
二、数据库版本
SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production PL/SQL Release 9.2.0.4.0 - Production CORE 9.2.0.3.0 Production TNS for Linux: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production
三、mos信息
根据mos的建议,这个错误可以忽略,不用过多关注
ORA-600 [12235] "Oracle process has no purpose in life !" [ID 33174.1] ERROR: ORA-600 [12235] [a] [b] 1[/c] [d] [e] VERSIONS: versions 7.0 to 9.2 DESCRIPTION: This error shows up when Oracle detects an Oracle defunct process. When an Oracle process starts up, it reads data from the SGA that defines what type of process it should become. If the process does not locate any valid customization data, it reports ORA-600 [12235] and exits. On a heavily loaded system, ORA-600 [12235] may be a symptom that the server process was too slow in starting. That is, the process that initiated the new server may timeout waiting for the new process to start and abandon the new server request. In the new server process it is possible that the new server reaches the code to customize its operation before the os request to kill the process is actioned. The messages "ksbsrv: No startup acknowledgement from forked process ..." and "Timed out trying to start shared server ..." may be reported to trace and alert files. SUGGESTIONS: Ignore the error. One of the most common reasons for this error to be reported is that someone typed 'oracle' manually at the OS prompt. If this error is reported regularly and appears not to be explained by comments made in this note, contact Oracle Support Services.
四、错误重现
根据mos中的讲述,在系统级别执行oracle,也会出现该错误提示,使用oracle重现结果
[oracle@database ~]$ oracle [oracle@database ~]$ oracle [oracle@database ~]$ tail $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log Mon Nov 7 11:10:25 2011 Errors in file /opt/oracle/admin/txzldb/bdump/txzldb_ora_27108.trc: ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], [] Mon Nov 7 11:10:27 2011 Errors in file /opt/oracle/admin/txzldb/bdump/txzldb_ora_1281.trc: ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], []