Database upgrade issues-ora-39700:database must be opened with UPGRADE option

1. Error description

A data has not been used for a long time, and the following error occurred during the recent startup:

Sql> Startup

Oracle instance started.

Total System Global area 4932501504 bytes

Fixed Size 2103096 bytes

Variable Size 889194696 bytes

Database buffers 4026531840 bytes

Redo buffers 14671872 bytes

Database mounted.

Ora-01092:oracle instance terminated. Disconnection forced

2. View ORADIM.LOG (D:\oracle\product\10.2.0\db_1\database\oradim.log)

Ora-00704:bootstrap Process Failure

Ora-39700:database must be opened with UPGRADE option

3. View the database version as: 10.2.0.5.0, it should be that they did a database upgrade without executing this script.

$ORACLE _home\rdbms\admin\catupgrd.sql;

4.linux process is simple

startup upgrade;

@ $ORACLE _home\rdbms\admin\catupgrd.sql;

@ $ORACLE _home/rdbms/admin/utlrp.sql; --recompiling the failed object is not very related to the problem itself.

Restart database

Shutdwon immediate;

Startup

5. Summary

The reason for analysis is: The database should be upgraded, but the corresponding instance is not upgraded, causing the instance to fail to start;

After the database upgrade (install the corresponding version of the patch pack), you also need to upgrade the instance (multiple instances, need one upgrade), the upgrade step of the instance is as above the resolution step.

This article is from the "Qytag (upspringing)" blog, so be sure to keep this source http://qytag.blog.51cto.com/6125308/1413021