SOLVED

ORA-38856: Cannot Mark Instance UNNAMED_INSTANCE As Enabled

Asked by OracleDba12 viewsoracle

ORA-38856: Cannot Mark Instance UNNAMED_INSTANCE As Enabled

#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
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.
OracleDba

Post Your Solution