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博客 ” ，链接：https://blog.itpub.net/15385/viewspace-1002576/ ，如需转载，请注明出处，否则将追究法律责任。
