In Oracle 12c multitenant databases consist of a container database CDB which contain one or more pluggable databases PDB. Startup of the CDB can be done with none of the PDBs it contains being started. This procedures covers the startup of a CDB.
- Logon to your server as the oracle software owner.
[larry@linux2 ~]$ su – oracle
Password:
Last login: Mon Apr 24 14:55:04 EDT 2016 on pts/1
[oracle@linux2 ~]$
- No CDB in non-RAC system acts the same as any Oracle single instance database with three startup modes: NOMOUNT, MOUNT, and OPEN. Please see related article about modes. You can check for running CDB instances from the OS layer by searching for the SMON process. This does not show what startup mode the instance is in.
[oracle@linux2 ~]$ ps -ef|grep smon
oracle 2660 2395 0 09:34 pts/1 00:00:00 grep –color=auto smon
oracle 3849 1 0 Apr24 ? 00:00:02 ora_smon_cdb1
[oracle@linux2 ~]$
This shows that there is one instance started in some mode called cdb1. In this example our CDB database is cdb1. NOTE: You cannot validate any PDB in this manner. PDBs are services within a CDB and cannot be viewed via OS layer.
- Since this CDB is up and running, we will first demonstrate the shutdown process which is identical to non-CDB databases in single instance mode with three options: IMMEDIATE, ABORT, NORMAL. Please see related articles about modes. You have to connect to CDB as the SYSDBA privileged user to perform shutdown as shown below.
[oracle@linux2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 25 09:39:29 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@linux2 ~]$
- Now to startup the CDB, again you have to connect with SYSDBA privileged user, as shown below. Open is the default mode.
[oracle@linux2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 25 09:41:06 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup open
ORACLE instance started.
Total System Global Area 734003200 bytes
Fixed Size 2928728 bytes
Variable Size 524292008 bytes
Database Buffers 201326592 bytes
Redo Buffers 5455872 bytes
Database mounted.
Database opened.
SQL>
- Note you have to startup the listener process to enable oracle networking, but as far as the CDB is concerned, the database is ready for use.
- This completes startup of CDB in Oracle 12c.
Larry Catt
OCP