ORA-00607: Internal error occurred while making a change to a data block

新安装的数据第一次starup后，通过客户端连接，实例尽然自动关闭了，

经过查看trace，判断可能是undo被损坏。

C:\Users\Administrator.WHLiu-SOFT>sqlplus system/sys@test
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 6月 26 15:54:52 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select instance_name from v$instance;
INSTANCE_NAME
--------------------------------
ORA10GR2
SQL> select username,account_status from dba_users;
select username,account_status from dba_users
*
第 1 行出现错误:
ORA-03113: 通信通道的文件结束
SQL> conn sys/sys@test as sysdba
已连接到空闲例程。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area  289406976 bytes
Fixed Size                  2095736 bytes
Variable Size             117441928 bytes
Database Buffers          163577856 bytes
Redo Buffers                6291456 bytes
数据库装载完毕。
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [186], [270], [], [], [],
[], []

 解决方案：

-bash-3.00$ vi /oradata/oracle/102/dbs/initORA10GR2.ora
"/oradata/oracle/102/dbs/initORA10GR2.ora" 26 lines, 1036 characters
ORA10GR2.__db_cache_size=163577856
ORA10GR2.__java_pool_size=4194304
ORA10GR2.__large_pool_size=4194304
ORA10GR2.__shared_pool_size=109051904
ORA10GR2.__streams_pool_size=0
ORA10GR2.__db_cache_size=163577856
ORA10GR2.__java_pool_size=4194304
ORA10GR2.__large_pool_size=4194304
ORA10GR2.__shared_pool_size=109051904
ORA10GR2.__streams_pool_size=0
*.audit_file_dest='/oradata/oracle/admin/ORA10GR2/adump'
*.background_dump_dest='/oradata/oracle/admin/ORA10GR2/bdump'
*.compatible='10.2.0.5.0'
*.control_files='/oradata/oracle/oradata/ORA10GR2/control01.ctl','/oradata/oracl
e/oradata/ORA10GR2/control02.ctl','/oradata/oracle/oradata/ORA10GR2/control03.ct
l'
*.core_dump_dest='/oradata/oracle/admin/ORA10GR2/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='ORA10GR2'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORA10GR2XDB)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/oradata/oracle/arch/'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=96468992
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=289406976 *.undo_management='MANUAL'
*.undo_tablespace='SYSTEM'
*.user_dump_dest='/oradata/oracle/admin/ORA10GR2/udump'
:q
-bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jun 26 16:40:58 2012
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
Connected to an idle instance.

SQL> create pfile from spfile;

SQL> startup pfile=/oradata/oracle/102/dbs/initORA10GR2.ora
ORACLE instance started.
Total System Global Area  289406976 bytes
Fixed Size                  2095736 bytes
Variable Size             117441928 bytes
Database Buffers          163577856 bytes
Redo Buffers                6291456 bytes
Database mounted.
Database opened.
SQL> drop tablespace undotbs1 including contents and datafiles;
Tablespace dropped.
SQL> select segment_name,status,tablespace_name from
  2  dba_rollback_segs where status not in('ONLINE','OFFLINE');
no rows selected
SQL> create undo tablespace undo datafile '/oradata/oracle/oradata/ORA10GR2/undo1.dbf' size 1024M autoextend on;
Tablespace created.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

 

# vi oradata/oracle/102/dbs/initORA10GR2.ora
"oradata/oracle/102/dbs/initORA10GR2.ora" 26 lines, 1036 characters
ORA10GR2.__db_cache_size=163577856
ORA10GR2.__java_pool_size=4194304
ORA10GR2.__large_pool_size=4194304
ORA10GR2.__shared_pool_size=109051904
ORA10GR2.__streams_pool_size=0
*.audit_file_dest='/oradata/oracle/admin/ORA10GR2/adump'
*.background_dump_dest='/oradata/oracle/admin/ORA10GR2/bdump'
*.compatible='10.2.0.5.0'
*.control_files='/oradata/oracle/oradata/ORA10GR2/control01.ctl','/oradata/oracl
e/oradata/ORA10GR2/control02.ctl','/oradata/oracle/oradata/ORA10GR2/control03.ct
l'
*.core_dump_dest='/oradata/oracle/admin/ORA10GR2/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='ORA10GR2'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORA10GR2XDB)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/oradata/oracle/arch/'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=96468992
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=289406976 *.undo_management='AUTO'
*.undo_tablespace='UNDO'
*.user_dump_dest='/oradata/oracle/admin/ORA10GR2/udump'
"oradata/oracle/102/dbs/initORA10GR2.ora" 26 lines, 1032 characters
#

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jun 26 16:51:07 2012
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
Connected to an idle instance.
SQL> create spfile from pfile;
File created.
SQL> startup
ORACLE instance started.
Total System Global Area  289406976 bytes
Fixed Size                  2095736 bytes
Variable Size             117441928 bytes
Database Buffers          163577856 bytes
Redo Buffers                6291456 bytes
Database mounted.
Database opened.