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> alter session set container=pdborcl;
Session altered.
SQL> startup
ORA-65054: Cannot open a pluggable database in the desired mode.
SQL> shutdown
ORA-65011: Pluggable database PDBORCL does not exist.
SQL> select * from v$pdbs;
CON_ID DBID CON_UID GUID
---------- ---------- ---------- --------------------------------
NAME OPEN_MODE RES
------------------------------ ---------- ---
OPEN_TIME
---------------------------------------------------------------------------
CREATE_SCN TOTAL_SIZE BLOCK_SIZE RECOVERY SNAPSHOT_PARENT_CON_ID
---------- ---------- ---------- -------- ----------------------
3 2643978541 2643978541 18E7C1E9404F4FE3B4564526E37EC139
PDBORCL MOUNTED
2244208 0 8192 ENABLED 0
SQL> select * from cdb_pbs;
select * from cdb_pbs
*
ERROR at line 1:
ORA-01219: database or pluggable database not open: queries allowed on fixed
tables or views only
SQL> alter pluggable database pdborcl open;
alter pluggable database pdborcl open
*
ERROR at line 1:
ORA-65054: Cannot open a pluggable database in the desired mode.
SQL> shutdown
ORA-65011: Pluggable database PDBORCL does not exist.
SQL> startup
ORA-65011: Pluggable database PDBORCL does not exist.
i did this also
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PDBORCL MOUNTED
SQL> alter pluggable database PDBORCL open;
alter pluggable database PDBORCL open
*
ERROR at line 1:
ORA-65011: Pluggable database PDBORCL does not exist.