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

Source: Internet
Author: User
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.