ORA-39700: database must be opened with upgrade option

Here is link of this post
ORA-39700: database must be opened with upgrade option

This site moved to dbacatalog.blogspot.com please visit dbacatalog.blogspot.com

Advertisements

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