Database Reference
In-Depth Information
List the services with the pdb1 PDB:
SQL> connect sys@pdb1 as sysdba
SQL> select NAME, PDB from all_services;
NAME PDB
----------- ------------------
hr1 PDB1
sales1 PDB1
In the Oracle RAC-based environment, these database services are managed through the Oracle 12c Clusterware.
You can check the service configuration of the cpdb CDB with the following srvctl command:
$ srvctl config service -db cpdb
Service name: hr1
Service is enabled
Server pool: cpdb_hr1
Cardinality: 1
......
Pluggable database name: pdb1
......
Preferred instances: cpdb1
Available instances: cpdb2
Service name: sales1
Service is enabled
Server pool: cpdb_sales1
Cardinality: 1
......
Pluggable database name: pdb1
......
Preferred instances: cpdb2
Available instances: cpdb3
......
......
In the previous section, we mentioned that PDBs can be opened or shut down with the startup and shutdown
command as well as the ALTER PLUGGABLE DATABASE OPEN or the ALTER PLUGGABLE DATABASE CLOSE
command. Starting the service that is associated with the PDB can also open the PDB. If the PDB is currently closed
and you use the SRVCTL command to start the service that is associated the PDB, the PDB will be opened in read/
write on the nodes where the service is started. The following is the test:
Close the pdb1 PDB:
SQL> connect sys@pdb1 as sysdba
SQL> alter pluggable database close immediate;
SQL> select NAME, OPEN_MODE from V$PDBS
NAME OPEN_MODE
------ --------------
PDB1 MOUNTED
