ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle ORA-00607,ORA-006000错误

oracle ORA-00607,ORA-006000错误

原创 Linux操作系统 作者:longqidong 时间:2012-04-13 13:09:28 0 删除 编辑
几天在shutdown oracle时报错:
SQL> shutdown immediate
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [55], [29], [], [], [], [],
这是由于undo表空间引起的,undo表空间设置为auto,改变为manual后,可以顺利shutdown数据库,但是这也不是最中解决办法。
可以选择重建undo,

SQL> create undo tablespace undo2 datafile '/app/oracle/oradata/lqd/undo2.dbf' size 200M;

Tablespace created.

SQL> alter system set undo_tablespace =undo2 scope=spfile;

System altered.

SQL> drop tablespace undotbs1 including contents and datafiles;

Tablespace dropped.

SQL> 
SQL> 
SQL> create undo tablespace undotbs1 datafile '/app/oracle/oradata/lqd/undotbs01.dbf' size 200M;

Tablespace created.

SQL> alter system set undo_tablespace=undotbs1;
alter system set undo_tablespace=undotbs1
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-30014: operation only supported in Automatic Undo Management mode


SQL> alter system set undo_tablespace=undotbs1 scope=spfile;

System altered.

SQL> drop tablespace undo2 including contents and datafiles;

Tablespace dropped.

SQL> alter system set undo_management=auto scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  608174080 bytes
Fixed Size                  1220820 bytes
Variable Size             171970348 bytes
Database Buffers          427819008 bytes
Redo Buffers                7163904 bytes
Database mounted.
Database opened.
SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startu[
SP2-0042: unknown command "startu[" - rest of line ignored.
SQL> startup
ORACLE instance started.

Total System Global Area  608174080 bytes
Fixed Size                  1220820 bytes
Variable Size             171970348 bytes
Database Buffers          427819008 bytes
Redo Buffers                7163904 bytes
Database mounted.
Database opened.
SQL> 

问题解决

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22418990/viewspace-721079/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-08-26

  • 博文量
    94
  • 访问量
    412984