ORA-01092 数据库打不开的问题原因(数据库升级不成功的问题)

Oracle10.2.0.1到10.2.0.4升级，升级完成后，连接数据库时竟然出现了ORA-01092故障，导致无法打开数据库，现象如下：

SQL> startup
ORACLE 例程已经启动。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 171969412 bytes
Database Buffers 432013312 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。

ORA-01092: ORACLE 实例终止。强制断开连接



.

赶紧检查alert.log日志：D:\oracle\product\10.2.0\admin\Oracle_SID\bdump\alert.log

发现如下提示：

Wed Mar 25 16:59:37 2009

Errors in file d:\oracle\product\10.2.0\admin\katrina\udump\katrina_ora_3284.trc:

ORA-00704: 引导程序进程失败

ORA-39700: 必须用 UPGRADE 选项打开数据库

Wed Mar 25 16:59:37 2009

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Wed Mar 25 16:59:38 2009

Errors in file d:\oracle\product\10.2.0\admin\katrina\bdump\katrina_pmon_3176.trc:

ORA-00704: bootstrap process failure



.

说明在升级过程中，只安装了补丁软件，没升级数据字典，因而造成数据库打不开，报ORA-00704:bootstrap process failure错误，按照正常升级数据字典的步骤进行即可。

SQL>startup upgrade

SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catupgrd.sql

SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catalog.sql

SQL>shutdown immediate

SQL>startup
数据库启动成功。


SQL> startup upgrade


如果是RAC,先创建pfile,修改增加

SQL> create pfile='/u01/app/oracle/pp.ora' from spfile;

File created.

Vi pp.ora

Update *.cluster_database=false

SQL>startup upgrade pfile=’/u01/app/oracle/pp.ora’;

SQL>@/u01/app/oracle/product/10.2.0/db/rdbms/admin/catupgrd.sql

……

SQL>@/u01/app/oracle/product/10.2.0/db/rdbms/admin/utlu102s.sql


重建数据字典表
SQL> @?/rdbms/admin/catupgrd.sql

编译失效对象
SQL>@?/rdbms/admin/utlrp.sql



----===========================================================================

处理过程：oracle@linux-l4nt:~> sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Sat Jan 23 11:06:22 2010Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to an idle instance.SQL> startup upgrade
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.
SQL>@ORACLE_HOME/rdbms/admin/catupgrd.sql
....
没有报错
SQL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.SQL>startup
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.成功启动数据库。


备份数据。如果执行过程中有错误，完成后仍然无法正常启动，则这个脚本不可用，换其他两个脚本执行SQL> startup upgrade
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.
SQL>@$ORACLE_HOME/rdbms/admin/catalog.sql
.....
SQL>@$ORACLE_HOME/rdbms/admin/catproc.sql
.....
SQL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.SQL>startup
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.处理完毕！！！！！！