With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /oracle/product/10.2.0

System name: SunOS

Node name: solaris10ora10gr2x64

Release: 5.10

Version: Generic_141445-09

Machine: i86pc

Instance name: ORCL

Redo thread mounted by this instance: 1

Oracle process number: 15

Unix process pid: 18718, image: oracle@solaris10ora10gr2x64 (TNS V1-V3)

*** ACTION NAME:() 2012-06-09 14:48:19.068

*** MODULE NAME:(sqlplus@solaris10ora10gr2x64 (TNS V1-V3)) 2012-06-09 14:48:19.068

*** SERVICE NAME:(SYS$USERS) 2012-06-09 14:48:19.068

*** SESSION ID:(159.3) 2012-06-09 14:48:19.068

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

解决方案：

原因是由于在完成升级版本后，数据字典的内容被修改了，需要使用catalog.sql和catproc.sql这两个脚本再运行一下把数据字典再更新一下。于是使用命令"startup upgrade"启动数据库，再运行catupgrd.sql这个脚本，即运行"@ORACLE_HOME\rdbms\admin\catupgrd.sql"，这条语句会执行比较久的时间，我是在PC机上操作的，执行了12分钟左右。执行完成以后，关闭数据库，再使用正常模式启动数据库，再运行一下utlrp.sql这个脚本来重新编译一下一些无效的对象。OK了。

-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Sat Jun 9 15:47:30 2012

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to an idle instance.

www.2cto.com

SQL> startup UPGRADE

ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size 2094800 bytes

Variable Size 100665648 bytes

Database Buffers 58720256 bytes

Redo Buffers 6291456 bytes

Database mounted.

Database opened.

SQL>

作者 蓝红石