ORA-00607: Internal error occurred while making a change to a data block
新安装的数据第一次starup后，通过客户端连接，实例尽然自动关闭了，
经过查看trace，判断可能是undo被损坏。
C:\Users\Administrator.WHLiu-SOFT>sqlplus system/sys@testSQL*Plus: Release 10.2.0.1.0 - Production on 星期二 6月 26 15:54:52 2012Copyright (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 optionsSQL> select instance_name from v$instance;INSTANCE_NAME--------------------------------ORA10GR2SQL> 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> startupORACLE 例程已经启动。Total System Global Area 289406976 bytesFixed Size 2095736 bytesVariable Size 117441928 bytesDatabase Buffers 163577856 bytesRedo Buffers 6291456 bytes数据库装载完毕。ORA-00607: Internal error occurred while making a change to a data blockORA-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 charactersORA10GR2.__db_cache_size=163577856ORA10GR2.__java_pool_size=4194304ORA10GR2.__large_pool_size=4194304ORA10GR2.__shared_pool_size=109051904ORA10GR2.__streams_pool_size=0ORA10GR2.__db_cache_size=163577856ORA10GR2.__java_pool_size=4194304ORA10GR2.__large_pool_size=4194304ORA10GR2.__shared_pool_size=109051904ORA10GR2.__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/oracle/oradata/ORA10GR2/control02.ctl','/oradata/oracle/oradata/ORA10GR2/control03.ctl'*.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 sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Tue Jun 26 16:40:58 2012Copyright (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.
posted on
2012-06-26 17:51
蓝红石 阅读(
...) 评论(
)
编辑
收藏
转载于:https://www.cnblogs.com/liuweihua/archive/2012/06/26/2564112.html
