In previous post we have seen various ways to connect with CDB and PDB.

Establish Connection in CDB and PDB

In this post we will see how we can Start and shutdown particular PDB and how to Start and shut down whole CDB.

1. How to Start Pluggable database

There are two ways possible

a) Connect to the pluggable database

Issue startup command

b) Connect to CDB$ROOT and give the following command

2. How to stop a pluggable database

We can shut down pluggable database in two ways. First is traditional method issuing shut down command after connecting to pluggable database using proper privilege.

a) Connect to a pluggable database

Issue shutdown command.

b) Connect to CDB$ROOT and give the following command to shut down the pluggable database

We can also close all pluggable database using the following command

To close all PDBs except some PDBs we can use PDBs.

3. Starting CDB database

4. Shut down CDB

Stay tuned for More articles on Oracle Multitenant

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.