Skip to Main Content
  • Questions
  • When shutting down a container database

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Travis.

Asked: October 25, 2016 - 3:10 pm UTC

Last updated: October 26, 2016 - 8:46 am UTC

Version: 12.1.0.2.0

Viewed 1000+ times

You Asked

Hello,

Some background info:

We are working in a 12c multitenant environment on windows server 2012 R2.
Container database contains about 20-25 pluggable databases.

Typically we have to shutdown the container database to perform maintenance on the server, I was wondering if there is any difference between the following methods of doing this shutdown:

Shutting down each PDB individually, then shutting down the container.
Shutting down just the container, without shutting down any PDBs first.
Stopping the Oracle service for the container.

Typically, we shut down each PDB first, then shut down the container and I was wondering if it was worth the extra time to do so.

Thanks!

and Chris said...

Unless there's something specific you're doing as part of the PDB shutdown (e.g. making sure certain jobs have run), I'm not aware of any advantage to shutting them down first.

Shutting down the container will stop any open PDBs at the same time anyway!

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Travis Hunt, October 25, 2016 - 5:20 pm UTC


Startup the container

Rajeshwaran Jeyabal, October 26, 2016 - 8:12 am UTC

How ever if you Startup the container doesn't mean all PDB's were open, instead they would in MOUNT status.

which means we have to open each PDB manually, else make use of this Trigger trick.

https://blogs.oracle.com/UPGRADE/entry/starting_up_252_pdbs_automatically
Chris Saxon
October 26, 2016 - 8:46 am UTC

You can save the state of PDBs in 12.1.0.2. When you start the container, Oracle will place each PDB in its saved state whether it was open or closed at shutdown:

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9531671900346425939

You should only use the trigger trick in 12.1.0.1.

More to Explore

Multitenant

Need more information on Multitenant? Check out the Multitenant docs for the Oracle Database