How to fix the Oracle error ORA-39702: database not open for UPGRADE or DOWNGRADE?

In this post, you’ll learn more about the Oracle ErrorORA-39702: database not open for UPGRADE or DOWNGRADE with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-39702: database not open for UPGRADE or DOWNGRADE

Reason for the Error ORA-39702: database not open for UPGRADE or DOWNGRADE

An upgrade, downgrade, reload, or patch script was invoked when the database was not open for UPGRADE or DOWNGRADE.

How to fix the Error ORA-39702: database not open for UPGRADE or DOWNGRADE ?

You can fix this error in Oracle by following the below steps

Use STARTUP UPGRADE to open the database for upgrade or to apply a patch set. Use STARTUP DOWNGRADE for running a downgrade script or the reload script.