DIFFERENT WAYS TO STOP AND START A PLUGGABLE DATABASE:

 DIFFERENT WAYS TO STOP A PLUGGABLE DATABASE:

 

OPTION:1:

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB                        READ WRITE NO

 

SQL> alter pluggable database ORCLPDB close immediate;

 

Pluggable database altered.

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB                        MOUNTED

 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

OPTION:2:

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB                        READ WRITE NO

 

SQL> alter session set container=ORCLPDB;

 

Session altered.

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 ORCLPDB                        READ WRITE NO

 

 

SQL> shut immediate

Pluggable Database closed.

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 ORCLPDB                        MOUNTED

 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

 

OPTION:3:

 

 

SQL> show con_name;

 

CON_NAME

------------------------------

CDB$ROOT

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB                        READ WRITE NO

SQL> alter session set container=ORCLPDB;

 

Session altered.

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 ORCLPDB                        READ WRITE NO

 

SQL> alter pluggable database close immediate;

 

Pluggable database altered.

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 ORCLPDB                        MOUNTED

 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

DIFFERENT WAYS TO START A PLUGGABLE DATABASE:

 OPTION:1:

SQL> show con_name;

CON_NAME

------------------------------

CDB$ROOT

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB                        MOUNTED

 

SQL> alter pluggable database ORCLPDB open;

 

Pluggable database altered.

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB                        READ WRITE NO

 

OPTION:2:

 

SQL> show con_name;

 

CON_NAME

------------------------------

CDB$ROOT

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB                        MOUNTED

 

SQL> alter session set container=ORCLPDB;

 

Session altered.

 

SQL> alter database open;

 

Database altered.

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 ORCLPDB                        READ WRITE NO

 

 

OPTION:3:

 

SQL> show con_name;

 

CON_NAME

------------------------------

CDB$ROOT

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB                        MOUNTED

 

SQL> alter session set container=ORCLPDB;

 

Session altered.

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 ORCLPDB                        MOUNTED

 

SQL> alter pluggable database open;

 

Pluggable database altered.

 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

OPTION:4:

 

SQL> show con_name;

 

CON_NAME

------------------------------

CDB$ROOT

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB                        MOUNTED

 

SQL> alter session set container=ORCLPDB;

 

Session altered.

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 ORCLPDB                        MOUNTED

 

SQL> startup

Pluggable Database opened.

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 ORCLPDB                        READ WRITE NO

 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++