一直用着Oracle10.2.0.1,看到10.2.0.4都出了这么久了也没升级过,今天正好有时间升级一下,首先在Windows Server 2003 SP2平台进行测试,升级完成后,连接数据库时竟然出现了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:oracleproduct10.2.0adminOracle_SIDbdumpalert.log
发现如下提示:
Wed Mar 25 16:59:37 2009
Errors in file d:oracleproduct10.2.0adminkatrinaudumpkatrina_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:oracleproduct10.2.0adminkatrinabdumpkatrina_pmon_3176.trc:
ORA-00704: bootstrap process failure
.
说明在升级过程中,只安装了补丁软件,没升级数据字典,因而造成数据库打不开,报ORA-00704:bootstrap process failure错误,按照正常升级数据字典的步骤进行即可。
SQL>startup upgrade
SQL>@D:oracleproduct10.2.0db_1rdbmsadmincatupgrd.sql
SQL>@D:oracleproduct10.2.0db_1rdbmsadmincatalog.sql
SQL>shutdown immediate
SQL>startup数据库启动成功。
.
谨记谨记。