ORA-00600 event resolution

ORA-00600 event resolution

When the Oracle database is started, close it directly to view the alarm log:

Errors in file/opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_mmon_3749.trc (incident = 65276 ):
ORA-00600: internal error code, arguments: [4194], [0x000000011], [0x7F9676793990], [], [], [], [], [], [], [], [], [], []
Incident details in:/opt/oracle/diag/rdbms/orcl11g/orcl11g/incident/incdir_65276/orcl11g_mmon_3749_i65276.trc
ORACLE Instance orcl11g (pid = 13)-Error 1578 encountered while recovering transaction (20, 27 ).
Errors in file/opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_smon_3745.trc:
ORA-01578: ORACLE data block upted (file #10, block #2088)
ORA-01110: data file 10: '/opt/oracle/oradata/orcl11g/undotb02.dbf'
Completed: ALTER DATABASE OPEN
Mon Nov 10 22:40:18 2014
Trace dumping is refreshing Ming id = [cdmp_20141110224018]
Mon Nov 10 22:40:20 2014
Starting background process SMCO
Mon Nov 10 22:40:20 2014
SMCO started with pid = 26, OS id = 3805
Trace dumping is refreshing Ming id = [cdmp_20141110224020]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR: 0x79C8DBF3] [PC: 0x2297740, kgegpa () + 40] [flags: 0x0, count: 1]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR: 0x79C8DBF3] [PC: 0x229596B, kgebse () + 279] [flags: 0x2, count: 2]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR: 0x79C8DBF3] [PC: 0x229596B, kgebse () + 279] [flags: 0x2, count: 2]
Mon Nov 10 22:40:21 2014
Doing block recovery for file 10 block 3395
Trace dumping is refreshing Ming id = [cdmp_20141110224022]
Mon Nov 10 22:40:23 2014
Simulated error on redo application.
Mon Nov 10 22:40:24 2014
PMON (ospid: 3721): terminating the instance due to error 474
Instance terminated by PMON, pid = 3721

SYS @ orcl11g> select file #, name from v $ datafile;
FILE # NAME
----------------------------------------------------------------------
1/opt/oracle/oradata/orcl11g/system01.dbf
2/opt/oracle/oradata/orcl11g/sysaux01.dbf
3/opt/oracle/oradata/orcl11g/undotbs01.dbf
4/opt/oracle/oradata/orcl11g/users01.dbf
5/opt/oracle/oradata/zbdba. dbf
7/opt/oracle/oradata/orcl11g/test. dbf
8/opt/oracle/oradata/orcl11g/test_size.dbf
9/opt/oracle/oradata/orcl11g/test_size2.dbf
10/opt/oracle/oradata/orcl11g/undotb02.dbf

Add the following to the initialization parameters:
Event = '10061 trace name context forever, level 10'
_ Smon_internal_errlimit = 1000000

Start the database again:

SYS @ orcl11g> alter database open;
Alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [4194], [0x000000011], [0x000000000], [], [], [], [], [], [], [], [], [], []

SYS @ orcl11g>
SYS @ orcl11g>
SYS @ orcl11g>
SYS @ orcl11g> select open_mode from v $ database;
OPEN_MODE
----------------------------------------
READ WRITE

At this time, we need to reconstruct the undo tablespace and solve the problem.

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Sharing pool for Oracle Performance Optimization