In Oracle 12c multitenant databases consist of a container database CDB which contain one or more pluggable databases PDB. Startup of the PDB must be done after the CDB it is contained in has been started. This procedures covers the startup and shutdown of all PDBs in a CDB.
- Logon to your server as the oracle software owner.
[larry@linux2 ~]$ su – oracle
Password:
Last login: Mon Mar 24 14:55:04 EDT 2016 on pts/1
[oracle@linux2 ~]$
- Logon to your CDB where the PDB you wish to start is stored.
[oracle@linux2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 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>
- View the available PDBs within the CDB with SQL statement: select name, open_mode from v$pdbs.
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
—————————— ———-
PDB$SEED READ ONLY
PDB1 MOUNTED
PDB2 MOUNTED
SQL>
NOTE: MOUNTED is the closed state for a PDB while it CDB is open.
- You have four options for PDBs to choose from:
- MOUNTED – PDB closed but CDB open.
- OPEN MIGRATE – PDB is open for upgrade and patching.
- OPEN READ ONLY – PDB is open for reads but not writes.
- OPEN READ WRITE – PDB is open for all operations.
All of this modes can be moved to and from with the SQL statement: ‘ALTER PLUGGABLE DATABASE all <OPTION>; In this step we will move all the PDBs from mounted to open read write. NOTE: read write is optional.
SQL> alter pluggable database all open;
Pluggable database altered.
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
—————————— ———-
PDB$SEED READ ONLY
PDB1 READ WRITE
PDB2 READ WRITE
SQL>
- You can close all the PDB with close option.
SQL> alter pluggable database all close;
Pluggable database altered.
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
—————————— ———-
PDB$SEED READ ONLY
PDB1 MOUNTED
PDB2 MOUNTED
SQL>
- You can actually specify the read write option and it will be accepted.
SQL> alter pluggable database all open read write;
Pluggable database altered.
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
—————————— ———-
PDB$SEED READ ONLY
PDB1 READ WRITE
PDB2 READ WRITE
SQL>
- You cannot move from read write to simply read option with all PDB and you cannot move all PDB into read only mode. You can only open all PDBs in read write mode and close all PDBs with all option.
SQL> alter pluggable database all open read;
alter pluggable database all open read
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL> alter pluggable database all close;
Pluggable database altered.
SQL> alter pluggable database all open read;
alter pluggable database all open read
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL>
- There are no other options to move all PDBs open mode. This completes startup and shutdown of all PDB within its CDB.
Larry Catt
OCP