Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

ORA-39700: database must be opened with upgrade option

ORA-39700: database must be opened with upgrade option

ERROR

ORA-39700: database must be opened with upgrade option

SOLUTION

Step 1: Open with Upgrade Option

SQL> startup upgrade;

 

Step 2: upgrade database – it means run script $ORACLE_HOME/rdbms/admin/catupgrd.sql

SQL> @/u01/app/oracle/product/11.2.0/db_home1/rdbms/admin/catupgrd.sql;
Step 3: Shutdown database and Startup

SQL> shutdown immediate;

SQL> startup;

 

Step 4: Run script $ORACLE_HOME/rdbms/admin/utlrp.sql – for recompile all invalid PL/SQL packages

SQL> @/u01/app/oracle/product/11.2.0/db_home1/rdbms/admin/utlrp.sql

 

 

Related Posts
Write a comment