http://lsx125920.iteye.com/blog/807401
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.处理完毕!!!!!!
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.处理完毕!!!!!!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23141985/viewspace-706678/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23141985/viewspace-706678/