ORA-39700: database must be opened with UPGRADE option

when i startup my database after applied 10.2.0.3 patch,there are some error:

check alert.log

alert_mdzj2.log:ORA-39700: database must be opened with UPGRADE option

alert_mdzj2.log:ORA-1092 signalled during: ALTER DATABASE OPEN...

[@more@]

when i startup my database after applied 10.2.0.3 patch,there are some error:

check alert.log

alert_mdzj2.log:ORA-39700: database must be opened with UPGRADE option

alert_mdzj2.log:ORA-1092 signalled during: ALTER DATABASE OPEN...

on node1:

SQL>startup upgrade

There have some error like:

ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE

Error 39701 happened during db open, shutting down database

Change the parameter cluster_database=false;

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

……

Oracle Database 10.2 Upgrade Status Utility 04-15-2008 14:10:11

.

Component Status Version HH:MM:SS

Oracle Database Server VALID 10.2.0.3.0 00:11:32

JServer JAVA Virtual Machine VALID 10.2.0.3.0 00:03:27

Oracle XDK VALID 10.2.0.3.0 00:00:51

Oracle Database Java Packages VALID 10.2.0.3.0 00:00:39

Oracle Text VALID 10.2.0.3.0 00:00:26

Oracle XML Database VALID 10.2.0.3.0 00:01:13

Oracle Real Application Clusters VALID 10.2.0.3.0 00:00:01

Oracle Data Mining VALID 10.2.0.3.0 00:00:25

OLAP Analytic Workspace VALID 10.2.0.3.0 00:00:32

OLAP Catalog VALID 10.2.0.3.0 00:00:55

Oracle OLAP API VALID 10.2.0.3.0 00:00:45

Oracle interMedia VALID 10.2.0.3.0 00:05:27

Spatial VALID 10.2.0.3.0 00:01:07

Oracle Expression Filter VALID 10.2.0.3.0 00:00:12

Oracle Enterprise Manager VALID 10.2.0.3.0 00:01:47

Oracle Rule Manager VALID 10.2.0.3.0 00:00:11

.

Total Upgrade Time: 00:29:38

Restart instance:

zj1@oracle>srvctl start instance -d mdzj -i mdzj1,mdzj2

zj1@oracle>

zj1@oracle>crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.mdzj.db application ONLINE ONLINE zj1

ora....j1.inst application ONLINE ONLINE zj1

ora....j2.inst application ONLINE ONLINE zj2

ora.....zj1.cs application OFFLINE OFFLINE

ora....zj1.srv application OFFLINE OFFLINE

ora....zj2.srv application OFFLINE OFFLINE

ora.....zj2.cs application OFFLINE OFFLINE

ora....zj1.srv application OFFLINE OFFLINE

ora....zj2.srv application OFFLINE OFFLINE

ora.....zj3.cs application OFFLINE OFFLINE

ora....zj1.srv application OFFLINE OFFLINE

ora....zj2.srv application OFFLINE OFFLINE

ora....J1.lsnr application ONLINE ONLINE zj1

ora.zj1.gsd application ONLINE ONLINE zj1

ora.zj1.ons application ONLINE ONLINE zj1

ora.zj1.vip application ONLINE ONLINE zj1

ora....J2.lsnr application ONLINE ONLINE zj2

ora.zj2.gsd application ONLINE ONLINE zj2

ora.zj2.ons application ONLINE ONLINE zj2

ora.zj2.vip application ONLINE ONLINE zj2

zj1@oracle>srvctl start service -d mdzj

zj1@oracle>crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.mdzj.db application ONLINE ONLINE zj1

ora....j1.inst application ONLINE ONLINE zj1

ora....j2.inst application ONLINE ONLINE zj2

ora.....zj1.cs application ONLINE ONLINE zj2

ora....zj1.srv application ONLINE ONLINE zj1

ora....zj2.srv application ONLINE ONLINE zj2

ora.....zj2.cs application ONLINE ONLINE zj2

ora....zj1.srv application ONLINE ONLINE zj1

ora....zj2.srv application ONLINE ONLINE zj2

ora.....zj3.cs application ONLINE ONLINE zj2

ora....zj1.srv application ONLINE ONLINE zj1

ora....zj2.srv application ONLINE ONLINE zj2

ora....J1.lsnr application ONLINE ONLINE zj1

ora.zj1.gsd application ONLINE ONLINE zj1

ora.zj1.ons application ONLINE ONLINE zj1

ora.zj1.vip application ONLINE ONLINE zj1

ora....J2.lsnr application ONLINE ONLINE zj2

ora.zj2.gsd application ONLINE ONLINE zj2

ora.zj2.ons application ONLINE ONLINE zj2

ora.zj2.vip application ONLINE ONLINE zj2

zj1@oracle>

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

转载于:http://blog.itpub.net/15385/viewspace-1002576/