ITPub博客

首页 > 数据库 > Oracle > 一次修改系统参数导至ORACLE无法启动实例的故障

一次修改系统参数导至ORACLE无法启动实例的故障

原创 Oracle 作者:itpremier 时间:2007-08-22 14:49:13 0 删除 编辑

事因:由于修改了CONTROL_FILES 参数,导至ORACLE 重启后无法启动,连实例也起不了.
如果INSTANCE能够START, 那么解决起来就很容易了,可是现在INSTANCE都启不了.
可是我又不甘心用PFILE 起动,因此花费了半天时间研究琢磨,有点小收获,在此分享.

[@more@]


1, SET CONTROL_FILES PARAMETER.
SQL> alter system set control_files='+NORM_DG1/ggctl01.ora,

+NORM_DG1/ggctl02.ora, d:hqgg.ora' scope=spfile;

2, START INSTANCE.
SQL> startup
ORA-15124: ASM file name '+NORM_DG1/ggctl01.ora, +NORM_DG1/ggctl02.ora,

d:hqgg.ora' contains an invalid alias name

3, USE UltraEdit to modify spfile located at
G:oracleproduct10.2.0db_1dbsspfilegg2.ora .
in binary mode, find and modify paramter to the correct value.

4, Retry :
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file

'G:oracleproduct10.2.0db_1/dbs/spfilegg.ora'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 2561)

5, UnderStand and resolve the puzzle above.
It resulted by the modification of the spfile which change the file size.
so we just go back to this file , open it and delete the redundant NULL char
at the end of the file.

6, Start instance
SQL> startup
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 247466884 bytes
Database Buffers 356515840 bytes
Redo Buffers 7135232 bytes
ORA-00214: control file 'D:HQGG.ORA' version 661 inconsistent with file
'+NORM_DG1/ggctl01.ora' version 755

--- This is because control file of 'D:HQGG.ORA' have a different SCN with
'+NORM_DG1/ggctl01.ora' .
SQL> select status from v$instance ;

STATUS
------------------------
STARTED

7, delete 'D:HQGG.ORA' and Recreate it .
SQL> alter database backup controlfile to 'd:hqgg.ora' ;

Database altered.

8, Restart database .

Problem has been cleared up Now.

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

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

注册时间:2008-11-27

  • 博文量
    253
  • 访问量
    724835