Tuesday 23 June 2015

ORA-39700: database must be opened with upgrade option


After RMAN restore for database to a test server appear this error, 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> @/oracle/app/product/11.2.0/db/rdbms/admin/catupgrd.sql;
SQL> shutdown immediate;
SQL> startup;
SQL> @/oracle/app/product/11.2.0/db/rdbms/admin/utlrp.sql

No comments:

Post a Comment

Number of Visitors