And most of these new commands are available via a simple right-click in the current release of Oracle’s SQLDeveloper (DBA Menu).
When everyone finally moves to Oracle pluggable databases, one thing to remember is that stopping and starting a database is not going to be as simple as it use to be. Shutting down and starting up a database is done simply with the following commands:
shutdown normalshutdown immediateshutdown abortstartupstartup nomountstartup mount
If we use one of these traditional shutdown methods at the container database (CDB) layer, we will bring down the CDB and the associated PDBs under it. This is something to be aware of when looking to reboot a container databases. Lets take a look at bringing down a CDB.
[oracle@oel ~]$ sqlplus / as sysdbaSQL*Plus: Release 126.96.36.199.0 Production on Sun Jul 21 21:42:53 2013Copyright (c) 1982, 2013, Oracle. All rights reserved.
Oracle Database 12c Enterprise Edition Release 188.8.131.52.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real…
View original post 687 more words