Start up and shut down a CDB/PDB

Overview

Starting and shutting down a CDB is the same as a non-CDB. However. starting and shutting down a PDB requires the use of the ALTER PLUGGABLE DATABASE command.

References

• Database Administrator’s Guide
  • 3 Starting Up and Shutting Down
  • 40 Administering a CDB with SQL*Plus
    • 40.4 Modifying a CDB
      • 40.4.6 Modifying the Open Mode of PDBs
        • 40.4.6.4 Modifying the Open Mode of PDBs with ALTER PLUGGABLE DATABASE
        • 40.4.6.5 Modifying the Open Mode of PDBs with the SQL*Plus STARTUP Command
  • 42 Administering PDBs with SQL*Plus
    • 42.3 Modifying a PDB
      • 42.3.1 Modifying a PDB with the ALTER PLUGGABLE DATABASE Statement
• Oracle® 12.1 Database Reference
  • Part III Dynamic Performance Views
    • V$CONTAINERS
• Oracle® 12.1 SQL Language Reference
  • ALTER PLUGGABLE DATABASE
  • ALTER SESSION
• SQL*Plus® User's Guide and Reference 12.1
  • SHUTDOWN
  • STARTUP

Reading Notes

"40.4.6.4 Modifying the Open Mode of PDBs with ALTER PLUGGABLE DATABASE" lists the following examples:

ALTER PLUGGABLE DATABASE salespdb, hrpdb OPEN READ WRITE; ALTER PLUGGABLE DATABASE salespdb OPEN READ ONLY RESTRICTED; ALTER PLUGGABLE DATABASE salespdb OPEN UPGRADE; ALTER PLUGGABLE DATABASE ALL OPEN READ WRITE; ALTER PLUGGABLE DATABASE ALL OPEN READ WRITE FORCE; ALTER PLUGGABLE DATABASE ALL EXCEPT salespdb, hrpdb CLOSE IMMEDIATE;

"40.4.6.5 Modifying the Open Mode of PDBs with the SQL*Plus STARTUP Command" lists the following examples:

STARTUP PLUGGABLE DATABASE hrpdb OPEN STARTUP PLUGGABLE DATABASE hrpdb RESTRICT STARTUP PLUGGABLE DATABASE hrpdb OPEN READ ONLY RESTRICT STARTUP PLUGGABLE DATABASE hrpdb OPEN READ ONLY STARTUP PLUGGABLE DATABASE hrpdb FORCE

Procedure

All of these commands are run against the JAR CDB on PADSTOW.

Get Initial State of All PDBs

Run the following SQL query to get the initial state of all PDBs:

SELECT name, open_mode, restricted FROM V$CONTAINERS ORDER BY name;

The expected output is:

NAME OPEN_MODE RES ------------------------------ ---------- --- CDB$ROOT READ WRITE NO JAM READ WRITE NO JAM0 READ WRITE NO JAM1 READ WRITE NO PDB$SEED READ ONLY NO PLUM READ WRITE NO VEGEMITE READ ONLY NO VEGEMITER READ WRITE NO 8 rows selected.

Connect to PLUM PDB

Run the following SQL command to connect to the PLUM PDB:

alter session set container=plum;

The expected output is:

Session altered.

Shut Down PLUM PDB

Run the following SQL command:

shutdown immediate

The expected output is:

Pluggable Database closed.

Get Current State of PLUM PDB

Run the following SQL query to get the current state of PLUM PDB:

SELECT name, open_mode, restricted FROM V$CONTAINERS ORDER BY name;

The expected output is:

NAME OPEN_MODE RES ------------------------------ ---------- --- PLUM MOUNTED

Start Up PLUM PDB While Connected to PLUM

Run the following SQL command to start up the PLUM PDB in read/write mode:

startup open

The expected output is:

Pluggable Database opened.

Get Current State of PLUM PDB

Run the following SQL query to get the current state of PLUM PDB:

SELECT name, open_mode, restricted FROM V$CONTAINERS ORDER BY name;

The expected output is:

NAME OPEN_MODE RES ------------------------------ ---------- --- PLUM READ WRITE NO

Close PLUM PDB

Run the following SQL command to close the PLUM PDB:

alter pluggable database plum close;

The expected output is:

Pluggable database altered.

Get Current State of PLUM PDB

Run the following SQL query to get the current state of PLUM PDB:

SELECT name, open_mode, restricted FROM V$CONTAINERS ORDER BY name;

The expected output is:

NAME OPEN_MODE RES ------------------------------ ---------- --- PLUM MOUNTED

Open PLUM PDB

Run the following SQL command to open the PLUM PDB:

alter pluggable database plum open;

The expected output is:

Pluggable database altered.

Get Current State of PLUM PDB

Run the following SQL query to get the current state of PLUM PDB:

SELECT name, open_mode, restricted FROM V$CONTAINERS ORDER BY name;

The expected output is:

NAME OPEN_MODE RES ------------------------------ ---------- --- PLUM READ WRITE NO

Shut Down PLUM PDB While Connected to PLUM

Run the following SQL command to shut down the PLUM PDB while connected to it:

shutdown immediate

The expected output is:

Pluggable Database closed.

Connect to Root Container

Run the following SQL command to connect to the ROOT container:

alter session set container=cdb$root;

The expected output is:

Session altered.

Start Up PLUM PDB While Connected to ROOT Container

Run the following SQL command to start up the PLUM PDB:

startup pluggable database plum

The expected output is:

Pluggable Database opened.

Get Current State of All PDBs

Run the following SQL query to get the current state of all PDBs:

SELECT name, open_mode, restricted FROM V$CONTAINERS ORDER BY name;

The expected output is:

NAME OPEN_MODE RES ------------------------------ ---------- --- CDB$ROOT READ WRITE NO JAM READ WRITE NO JAM0 READ WRITE NO JAM1 READ WRITE NO PDB$SEED READ ONLY NO PLUM READ WRITE NO VEGEMITE READ ONLY NO VEGEMITER READ WRITE NO 8 rows selected.