ORA-39700: database must be opened with upgrade option

Hello,
After restore database another server appear this error, because on older server database version was 11.2.0.1.0 and on new server database version is 11.2.0.3.0, therefore we need:
1) open with upgrade option
2) upgrade database – it means run script $ORACLE_HOME/rdbms/admin/catupgrd.sql
3) shutdown clearly and startup
4) run script $ORACLE_HOME/rdbms/admin/utlrp.sql – for recompile all invalid PL/SQL packages

sqlplus / as sysdba
SQL> startup upgrade;
SQL> @/u01/app/oracle/product/11.2.0/db_home1/rdbms/admin/catupgrd.sql;
SQL> shutdown immediate;
SQL> startup;
SQL> @/u01/app/oracle/product/11.2.0/db_home1/rdbms/admin/utlrp.sql

that’s all

5 thoughts on “ORA-39700: database must be opened with upgrade option

    1. qobesa Post author

      no you need only this two, catupgrd.sql for upgrade database and utlrp.sql for recompile invalid objects.

      Reply
      1. Peter

        Other authors suggest that the following is required, but are not correct, as this is done by catupgrd.sql:
        > Run utlu112s.sql, the Post-Upgrade Status Tool
        Other authors go on to say that the following is required:
        > Run catuppst.sql, located in the ORACLE_HOME/rdbms/admin directory, to perform upgrade actions that do not require the database to be in UPGRADE mode.
        Oracle’s 11.2 installation documents also suggest this same step following catupgrd.sql:
        http://docs.oracle.com/cd/E11882_01/install.112/e27508/creating_database.htm
        Since Oracle’s docs called for this post upgrade step, I did perform it.
        Regardless, my database has been upgraded and is in doof working order. Thanks for your clear and consice writing.

        Reply
  1. Prashant

    I refreshed my database of version 11.2.0.1.0 from a higher version 11.2.0.3.0
    Now I am not able to open the database of version 11.2.0.1.0.
    However I am able to startup using upgrade option but not able to perform backup using rman.

    I am getting below error when trying to startup the database:

    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced
    ORA-00704: bootstrap process failure
    ORA-39700: database must be opened with UPGRADE option
    Process ID: 24389
    Session ID: 191 Serial number: 1

    Please suggest what needs to be done???
    Do I need to upgrade my database of version 11.2.0.1 to 11.2.0.3…

    Reply
    1. qobesa Post author

      please clarify step by step what you have done? if you startup database with upgrade mode you have to run upgrade script. as your errors shown the database started normal mode and it needs to start with upgrade mode, above is written these steps.

      Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s