ORA-00600: Internal error code, parameter: [4194], [24], [22], [], [], [], [], []

Source: Internet
Author: User
The error 4194 on the Internet usually indicates that the UNDO segment is faulty, but my oracle database version is 10.1.0.2. Since this version does not have the undo segment, use the undo tablespace

The error 4194 on the Internet usually indicates that the UNDO segment is faulty, but my oracle database version is 10.1.0.2. Since this version does not have the undo segment, use the undo tablespace

The following error occurs when the data is shut down because the computer is often shut down illegally.

Errors in file c: \ Oracle \ product \ 10.1.0 \ admin \ orcl \ bdump \ orcl_smon_5140.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [24], [22], [], [], [], [], [], []

The error 4194 on the Internet usually indicates that the UNDO segment is faulty, but my oracle database version is 10.1.0.2. Since this version does not have undo segments and uses undo tablespace for management, the undo segments are all for oracle 9i. Here we only use the new undo tablespace to replace it. This method is also used when the undo tablespace is not recycled.
SQL> shutdown immediate; -- normal shutdown

ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [24], [22], [], [], [], [], [], []
SQL> shutdown abort -- forced shutdown
SQL> startup
SQL> create undo tablespace undotbs2 datafile 'C: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ ORCL \ undotbs02.dbf' size 200 m;
SQL> alter system set undo_tablespace = undotbs2; -- modify the undo tablespace of the database
SQL> shutdown immediate -- shut down the database normally

-- Manually modify the initialization file,

######################################## ###
Undo_management = AUTO
Undo_tablespace = UNDOTBS2

######################################## ###


SQL> shutdown immediate;
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.
SQL> startup pfile = 'C: \ oracle \ product \ 10.1.0 \ admin \ orcl \ pfile \ init. ora.10152011101227 ';
The ORACLE routine has been started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 144964076 bytes
Database Buffers 25165824 bytes
Redo Buffers 1048576 bytes
The database has been loaded.
The database has been opened.

-- Restore the original tablespace

SQL> drop tablespace undotbs1 including contents;

The tablespace has been deleted.

SQL> create undo tablespace undotbs1 datafile 'C: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ ORCL \ undotbs01.dbf' size 200 m;

The tablespace has been created ..

SQL> alter system set undo_tablespace = undotbs1;
The system has been changed.

SQL> shutdown immediate; -- close the database
-- Modify the parameter file and change the undo tablespace back to the original value. undo_tablespace = undotbs1

SQL> startup pfile = 'C: \ oracle \ product \ 10.1.0 \ admin \ orcl \ pfile \ init. ora.10152011101227 ';


The ORACLE routine has been started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 144964076 bytes
Database Buffers 25165824 bytes
Redo Buffers 1048576 bytes
The database has been loaded.
The database has been opened.

SQL> drop tablespace uundotbs2 including contents;

The tablespace has been deleted.

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.