ORA-02288: invalid OPEN mode

C:\Windows\system32>cd ..

C:\Windows>cd ..

C:\>set ORACLE_HOME=D:\App\OracleUser\product\12.1.0\dbhome_1

C:\>SET ORACLE_SID=dbname

C:\>sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Sat Feb 18 11:36:53 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> alter pluggable database pdborcl open;
alter pluggable database pdborcl open
*
ERROR at line 1:
ORA-01109: database not open


SQL> startup
SP2-0642: SQL*Plus internal error state 2133, context 1219:0:0
Unsafe to proceed
ORA-01219: database or pluggable database not open: queries allowed on fixed
tables or views only


SQL> shutdown immediate
ORA-03113: end-of-file on communication channel
SQL> startup
SP2-0642: SQL*Plus internal error state 2133, context 3114:0:0
Unsafe to proceed
ORA-03114: not connected to ORACLE


SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 2533359616 bytes
Fixed Size                  3048824 bytes
Variable Size             671091336 bytes
Database Buffers         1845493760 bytes
Redo Buffers               13725696 bytes
Database mounted.
Database opened.
SQL> alter database open pluggable database pdborcl open;
alter database open pluggable database pdborcl open
                    *
ERROR at line 1:
ORA-02288: invalid OPEN mode


SQL> select service_id, name, pdb from v$services;

SERVICE_ID NAME
---------- ----------------------------------------------------------------
PDB
------------------------------
         0 pdborcl
PDBORCL

         0
CDB$ROOT

         5 mcorXDB
CDB$ROOT


SERVICE_ID NAME
---------- ----------------------------------------------------------------
PDB
------------------------------
         6 mcor
CDB$ROOT

         1 SYS$BACKGROUND
CDB$ROOT

         2 SYS$USERS
CDB$ROOT


6 rows selected.

SQL> alter database open pluggable database pdborcl mount;
alter database open pluggable database pdborcl mount
                    *
ERROR at line 1:
ORA-02288: invalid OPEN mode


SQL> alter database open pluggable database pdborcl open;
alter database open pluggable database pdborcl open
                    *
ERROR at line 1:
ORA-02288: invalid OPEN mode


SQL> select status from v$instance;

STATUS
------------
OPEN

SQL>  SELECT NAME, CDB, CON_ID FROM V$DATABASE;

NAME      CDB     CON_ID
--------- --- ----------
dbname      YES          0

SQL>

Select allOpen in new window