ORA-38856: Cannot Mark Instance UNNAMED_INSTANCE As Enabled

Solution :

SQL> alter system set "_no_recovery_through_resetlogs"=TRUE scope=both;

System altered.

SQL> shutdown immediate;
ORA-01109: database not open

SQL> alter database open resetlogs;

Database altered.