Google it ....

Tuesday, October 15, 2013

ORA-39700: database must be opened with upgrade option

Hello,
After restore database another server and was trying to open database appear error
ORA-39700: database must be opened with upgrade option
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
Posted by at
Labels: , , , ,

4 comments:

  1. PeterJuly 13, 2014 at 3:23 AM

    Are there any other packages that may need to be run in this case?

    ReplyDelete
  2. qobesaJuly 13, 2014 at 4:49 PM

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

    ReplyDelete
  3. PrashantOctober 25, 2016 at 2:38 PM

    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...

    ReplyDelete
  4. qobesaOctober 25, 2016 at 5:43 PM

    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.

    ReplyDelete

Subscribe to: Post Comments (Atom)