ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []

DEBUG: Replaying xcb 0xa4d2cf40, pmd 0xa4fd35c8 for failed op 8
Doing block recovery for file 2 block 10142
No block recovery was needed
Thu Mar  8 16:56:55 2012
Errors in file /db/oracle10g/admin/kpdt/bdump/kpdt_smon_13923.trc:
ORA-00600: internal error code, arguments: [4194], [49], [49], [], [], [], [], []
Thu Mar  8 16:56:55 2012
Doing block recovery for file 2 block 5881
Block recovery from logseq 42, block 114 to scn 1768308
Thu Mar  8 16:56:55 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 42 Reading mem 0
  Mem# 0 errs 0: /db/oracle10g/oradata/kpdt/redo02.log
Block recovery stopped at EOT rba 42.116.16
Block recovery completed at rba 42.116.16, scn 0.1768307
Doing block recovery for file 2 block 89
Block recovery from logseq 42, block 114 to scn 1768306
Thu Mar  8 16:56:55 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 42 Reading mem 0
  Mem# 0 errs 0: /db/oracle10g/oradata/kpdt/redo02.log
Block recovery completed at rba 42.116.16, scn 0.1768307
Thu Mar  8 16:56:55 2012
Errors in file /db/oracle10g/admin/kpdt/bdump/kpdt_smon_13923.trc:
ORA-01595: error freeing extent (15) of rollback segment (6))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [49], [49], [], [], [], [], []
Thu Mar  8 16:57:18 2012
Errors in file /db/oracle10g/admin/kpdt/udump/kpdt_ora_13982.trc:
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
Thu Mar  8 16:57:20 2012
Errors in file /db/oracle10g/admin/kpdt/udump/kpdt_ora_13982.trc:
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
Thu Mar  8 16:58:22 2012
DEBUG: Replaying xcb 0xa4d2cf40, pmd 0xa4fd35c8 for failed op 8
Doing block recovery for file 2 block 10142
No block recovery was needed
Thu Mar  8 16:58:48 2012
Errors in file /db/oracle10g/admin/kpdt/bdump/kpdt_pmon_13909.trc:
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
Thu Mar  8 16:58:48 2012
Errors in file /db/oracle10g/admin/kpdt/bdump/kpdt_pmon_13909.trc:
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
Thu Mar  8 16:58:48 2012
PMON: terminating instance due to error 472
Instance terminated by PMON, pid = 13909

 

 解决过程：

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 8 17:01:58 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1207959552 bytes
Fixed Size                  2020352 bytes
Variable Size             352324608 bytes
Database Buffers          838860800 bytes
Redo Buffers               14753792 bytes
Database mounted.
SQL>
SQL>
SQL>
SQL> show parameter undo;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1
SQL>
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/db/oracle10g/oradata/kpdt/system01.dbf
/db/oracle10g/oradata/kpdt/undotbs01.dbf
/db/oracle10g/oradata/kpdt/sysaux01.dbf
/db/oracle10g/oradata/kpdt/users01.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf01.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf02.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf03.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf04.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf05.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf06.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf07.dbf

NAME
--------------------------------------------------------------------------------
/db/oracle10g/oradata/kpdtdbf/kpdtdbf08.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf09.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf10.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf11.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf12.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf13.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf14.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf15.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf16.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf17.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf18.dbf

NAME
--------------------------------------------------------------------------------
/db/oracle10g/oradata/kpdtdbf/kpdtdbf19.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf20.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf21.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf22.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf23.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf24.dbf
/db/oracle10g/oradata/kpdtdbf/kpdtdbf25.dbf

29 rows selected.

SQL>
SQL>
SQL> alter system set undo_management=manual scope=spfile;

System altered.

SQL>
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1207959552 bytes
Fixed Size                  2020352 bytes
Variable Size             352324608 bytes
Database Buffers          838860800 bytes
Redo Buffers               14753792 bytes
Database mounted.
Database opened.
SQL>
SQL> CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/db/oracle10g/oradata/kpdt/undotbs02.dbf' SIZE 3G AUTOEXTEND ON NEXT   10M;

Tablespace created.

SQL> SQL>
SQL>
SQL>
SQL> alter system set undo_tablespace="UNDOTBS2" scope=spfile;

System altered.

SQL>
SQL> alter system set undo_management=auto scope=spfile;

System altered.

SQL> alter system set undo_management=auto scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL>
SQL> startup
ORACLE instance started.

Total System Global Area 1207959552 bytes
Fixed Size                  2020352 bytes
Variable Size             352324608 bytes
Database Buffers          838860800 bytes
Redo Buffers               14753792 bytes
Database mounted.
Database opened.
SQL>
SQL>

ORA-16038的解决

ORA-00600: internal error code, arguments: [keltnf

ORA-00600: ORA-12012 ORA-08102解决

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

ORA-31613 Master process DM00 failed during startup

ORA-24324 ORA-01041 ORA-03113

ORA-27125: unable to create shared memory segment

ORA-00245: control file backup operation failed

ORA-00245: control file backup operation failed

更多参考：

the specified nodes are not clusterable

根据rowid删除表中重复的行

Agent process exited abnormally during initialization

一次字符乱码的解决过程

rman实验（一）

rman实验（二）

ORA-00600: internal error code, arguments: [keltnf

ORA-00600: ORA-12012 ORA-08102解决

linux下完全删除oracle

INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory

centos4.8_64上安装oracle10201建库报ORA-12547

EM乱码解决

ORA-31613 Master process DM00 failed during startup

ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []

ORA-24324 ORA-01041 ORA-03113

centos5.3升级oracle

pdksh-5.2.14-36.el5.i386.rpm

使用rman进行数据库迁移

oracle10.2.0.1升级到10.2.0.4报错

Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)

改oracle的name和dbid

修改oracle实例名

Solaris8上迁移oracle8i---上

Solaris8上迁移oracle8i---下

未备份归档日志导致数据丢失的实验

使用NBU进行数据库迁移

catalog备份数据库

RMAN FORMAT字符串格式化

Error: can not register my instance state - -1

not all alterations performed

The ASM instance configured on the local node is a single-instance ASM

/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared

Initializing the Oracle ASMLib driver: [FAILED]

ORA-00245: control file backup operation failed

WARNING: failed to read mirror side 1 of virtual extent 229 logical extent

模拟恢复参数文件

Interface eth0 checked failed

import server uses ZHS16GBK character set (possible charset conversion)