ORA-00600: internalerrorcode, arguments: [2, 2032]

ORA-00600: internalerrorcode, arguments: [2, 2032]

ORA-00600: internal error code, arguments: [2032]

Record a problem, huh, huh

Shutdown immediate appears

SQL> shutdown immediate

ORA-00600: internal error code, arguments: [2032], [12587038], [12587038],

[8192], [2], [255], [0], [767], [], [], [], []

And when the data is inserted

ORA-01110: data file 3: '/data/Oracle/ORCL/undotbs01.dbf' statement: insert into xxx (

Xxx) values (xxx)

[16:09:58] Connection: ExecSQL error: ORA-01578: ORACLE data block corruption (file number 3, block number 4126)

In this case, the undo tablespace is damaged.

Change the system undo tablespace.

Query undo tablespace

SQL> show parameter undo _

NAME TYPE VALUE

-----------------------------------------------------------------------------

Undo_management string AUTO

Undo_retention integer 900

Undo_tablespace string UNDOTBS1

SQL> select tablespace_name, contents from dba_tablespaces where contents = 'undo ';

TABLESPACE_NAME CONTENTS

---------------------------------------

UNDOTBS1 UNDO

Query location

SQL> select name from v $ datafile;

NAME

--------------------------------------------------------------------------------

/Data/oracle/ORCL/system01.dbf

/Data/oracle/ORCL/sysaux01.dbf

/Data/oracle/ORCL/undotbs01.dbf

/Data/oracle/ORCL/users01.dbf

/Data/oracle/ORCL/example01.dbf

/Data/oracle/ORCL/center/center01.dbf

/Data/oracle/ORCL/test. dbf

/Data/oracle/ORCL/test1.dbf

/Data/oracle/ORCL/test2.dbf

/Data/oracle/ORCL/system_02.dbf

Add File

Size before Query

SQL> select sum (bytes)/1024/1024 "current undo size (M)" from dba_data_files where tablespace_name = 'undotbs1 ';

Current undo size (M)

--------------------

2735

Add File

SQL> create undo tablespace undo02 datafile '/data/oracle/ORCL/undotbs02.dbf' size 2800 M;

The system has been changed.

Change undo Space

SQL> alter system set undo_tablespace = undo02;

System altered.

SQL> show parameter undo _

NAME TYPE VALUE

-----------------------------------------------------------------------------

Undo_management string AUTO

Undo_retention integer 900

Undo_tablespace string UNDO02

Verify

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 447778816 bytes

Fixed Size 1337128 bytes

Variable Size 310380760 bytes

Database Buffers 130023424 bytes

Redo Buffers 6037504 bytes

Database mounted.

Database opened.

Of course, you can manually simulate undo tablespace corruption, which is not demonstrated here