Visit Counter

Wednesday, April 20, 2016

ORA-39710 only connect AS SYSDBA is allowed when OPEN in UPGRADE mode



Oracle Database Error ORA-39710

We upgrade oracle 11g database patch on solaris. Database showing restricted mode.
You have to shutdown the database (Shutdown immediate) & startup database in normal mode.


ORA-39710 only connect AS SYSDBA is allowed when OPEN in UPGRADE mode

Cause



An attempt was made to connect to a database when the database was OPEN for UPGRADE or DOWNGRADE.

Action

Try to connect again after the database upgrade or downgrade is complete.