Dear friends,
I created an application pdb but failed to open it. It's in 19c. I have opened application root appcon1. Please see the follows and help. Thanks in advance!
SYS@cdb(CDB$ROOT)> show con_name
CON_NAME
------------------------------
CDB$ROOT
SYS@cdb(CDB$ROOT)> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY YES
3 PROD3 READ WRITE YES
4 PDB4 READ WRITE YES
5 PDB6 READ WRITE YES
6 PDB5 MOUNTED
7 PDB_SNAP_TEST READ WRITE YES
8 PDB9 READ WRITE YES
9 PDB7 READ WRITE YES
10 PDB8 READ WRITE YES
11 DB1_1 READ WRITE YES
12 ORCL READ WRITE YES
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
13 APPCON1 READ WRITE YES
14 APPPDB1 MOUNTED
15 APPPDB2 MOUNTED
16 APPPDB01 MOUNTED
SYS@cdb(CDB$ROOT)> alter session set container=appcon1;
Session altered.
SYS@cdb(CDB$ROOT)> show con_name
CON_NAME
------------------------------
APPCON1
SYS@cdb(CDB$ROOT)> alter session set container=apppdb1;
Session altered.
SYS@cdb(CDB$ROOT)> startup
ORA-65054: Cannot open a pluggable database in the desired mode.