报需要升级的错误,具体处理步骤如下:
一、错误信息
SQL> alter database open ;
alter database open resetlogs*ERROR at line 1:ORA-01092: ORACLE instance terminated. Disconnection forcedORA-00704: bootstrap process failureORA-39700: database must be opened with UPGRADE optionProcess ID: 16643Session ID: 1705 Serial number: 5二、错误原因
数据库版本不一致导致,无法启动数据库
三、解决方案
通过数据字典升级解决
(1)升级方式启动SQL> startup upgrade; (2)查看预升级信息SQL> @$ORACLE_HOME/rdbms/admin/utlu112i.sql (3)执行升级脚本SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sql SQL> @$ORACLE_HOME/rdbms/admin/utlu112s.sqlSQL> @$ORACLE_HOME/rdbms/admin/catuppst.sqlSQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql(4)重启数据库SQL> shutdown immediate;SQL> startup;