ORA-39700: database must be opened with UPGRADE option solution 1. The error operating system and database are installed by the service provider, after a few months to remember to use this database, the following error occurs at startup. Www.2cto.com SQL> startupORACLE instance started. total System Global Area 4932501504 bytesFixed Size 2103096 bytesVariable Size 889194696 bytesDatabase Buffers 4026531840 bytesRedo Buffers 14671872 bytesDatabase mounted. ORA-01092: ORACLE instance terminated. disconnection forced 2. view alert. log ORA-00704: bootstrap process failureORA-39700: database must be opened with UPGRADE option 3. check that the database version is 10.2.0.5.0. It is because they have performed database upgrades without executing this script. $ ORACLE_HOME \ rdbms \ admin \ catupgrd. SQL; 4. the process is simple: startup upgrade; @ $ ORACLE_HOME \ rdbms \ admin \ catupgrd. SQL; @ $ ORACLE_HOME/rdbms/admin/utlrp. SQL; -- Re-compile the invalid object. It has little to do with this issue and restart the database shutdwon immediate; startupok