Database Reference
In-Depth Information
Start the hr1 service:
$srvctl status service -db cpdb -service hr1
Service hr1 is not running
$ srvctl start service -db cpdb -service hr1
Check the status of the pdb1 PDB:
SQL> connect sys@pdb1 as sysdba
SQL> select NAME, OPEN_MODE from V$PDBS
NAME OPEN_MODE
------ --------------
PDB1 READ WRITE
While the startup of the service can open the closed PDB with which the service is associated, shutdown
operation of the service will not change the open mode of the PDB. In other words, if we shut down the hr1 service
while the pdb1 PDB is open for READ and WRITE, the pdb1 PDB keeps open for READ and WRITE.
Creating Net Service Names for PDBs
With the user-defined services with the property of the PDB, you can create the net service names in the tnsnames.
ora file for applications to access the PDBs. Using the previous example of the hr1 and sales1 services for the pdb1
PDB, we can create the HR_PDB1 and SALES_PDB1 net service names, which the HR application uses and the sales
application can use, respectively, to connect to the pdb1 PDB database:
HR_PDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
knewracscan.kcloud.dblab.com
)
(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =
hr1.kcloud.dblab.com
)
)
)
SALES_PDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
knewracscan.kcloud.dblab.com
)
(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =
sales1.kcloud.dblab.com
)
)
)
12cR1: Miscellaneous New Features for RAC
In addition to the significant new features presented in detail in the previous sections, the following sections present
a brief high-level synopsis and overview of some of the notable miscellaneous new features within Oracle 12cR1
Clusterware.
