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.