Home / Errors/Workarounds10g / 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

 

 

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleDBconfig

Manually remove ODA DB HOME

Manually remove OLD DB HOMES if odacli-delete dbhome fails Please follow the instructions below: 1. …

Leave a Reply