Tuesday, April 29, 2025

How to start pluggable database in oracle 19c ?

 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