Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-39700 database must be opened with UPGRADE option

650908Jan 24 2009 — edited Jan 24 2009

I create a duplicate db on another server, and init files/oracle_home/and directories are mirrored.

ORA-39700 database must be opened with UPGRADE option

My Database shows in mount/startup upgrade:
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for HPUX: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 – Production

I am not sure what has been added, is it possible to run the scripts below without messing up my existing schema. I am going through the sql and do not see much as yet...

Objective to use alter database open without the forced shutdown, and open in upgrade mode etc....

Catproc.sql/catalog.sql – new db
Catupgrd.sql - 9-10g

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 21 2009

Added on Jan 24 2009

#database-upgrade, #upgrade

6 comments

5,907 views