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