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

Setup and design database architecture to meet SLA - 99.9 , 99.99 , 99.999

Achieving distinct Service Level Agreements (SLAs) for a database requires scaling redundancy and infrastructure complexity.  The three-nine...