oracle ORA-39700: database must be opened with UPGRADE option

Explain the function of static keyword and final keyword in Java in detail>>>

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

Process ID: 3650

Session ID: 292 serial number: 5
1

cause of the problem: when reporting an error in the database, I suddenly remembered that I had made an error. The original database version was 11.2.0.1, but the target database version was 11.2.0.3, so 0ra-39700 was prompted when I opened it

Solution: open the database through upgrade, as follows

[ [email protected] ~]$ sqlplus/as sysdba

SQL * Plus: release 11.2.0.3.0 production on Wednesday December 24 15:31:16 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to idle routine

SQL> startup mount;

Oracle routine has been started

Total System Global Area 6797832192 bytes

Fixed Size 2241264 bytes

Variable Size 3523218704 bytes

Database Buffers 3254779904 bytes

Redo Buffers 17592320 bytes

The database is loaded

SQL> alter database open upgrade;

The database has changed

SQL> select status from v$Instance;

STATUS

————————————

OPEN MIGRATE

SQL> @$ ORACLE_ HOME/rdbms/admin/catupgrd.sql;

it takes 30 minutes to run the catupgrd.sql script, and the database will be automatically closed after completion, and then it can be opened normally

Principle: when the database is upgraded, the base table inside the database is changed, and the data dictionary needs to be updated accordingly. Running catupgrd.sql will update the corresponding objects

Similar Posts: