Start pluggable database in oracle
SQL>
SQL> alter session set container=pdb$seed;
Session altered.
SQL>
SQL> show con_name
CON_NAME
------------------------------
PDB$SEED
SQL>
SQL>
SQL> alter pluggable database pdb open read write;
alter pluggable database pdb open read write
*
ERROR at line 1:
ORA-65118: operation affecting a pluggable database cannot be performed from
another pluggable database
SQL> alter session set container=pdb;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDB
SQL>
SQL> alter pluggable database pdb open read write;
Pluggable database altered.
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB READ WRITE NO
SQL>
No comments:
Post a Comment