Which three statements are true about the services created when the DBCA is used to create a RAC database?
A.
They can be policy managed for a multitenant database.
B.
Singleton services are not permitted for multitenant databases.
C.
A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service.
D.
Policy-managed services specified for a database allow the creation of a new server pool using DBCA.
E.
They can be administrator managed for a multitenant database.
Explanation:
C: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in Oracle Enterprise Manager Cloud
Control, if available, or SRVCTL.
E: During installation, if you select a multitenant container database (CDB), and configure pluggable databases (PDBs), then Oracle recommends that you add
services to the PDBs after installation.
Incorrect Answers:
D: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in Oracle Enterprise Manager Cloud
Control, if available, or SRVCTL.
https://docs.oracle.com/database/121/RIWIN/dbcacrea.htm#RIWIN1320
Hi guys
A new multitenant database can be policy-managed no? for me A is correct
We can create a non uniform service in a a multitenant database by specifiying singleton keyword: for me B is not correct
using dbca we can create a new serverpool or choose an existing one for policy managed database : For me D is correct
To resume I will choose :
A,D,E
Any comments
Regards
A) DBCA enables you to create both policy-managed and administrator-managed databases
C) To manage an application using either deployment scheme, you must create a server pool before adding the resource to the cluster
D) Oracle recommends you create server pools for database management before you create the respective databases. DBCA, however, will present you with a choice of either using precreated server pools or creating a new server pool, when you are creating a policy-managed database.
The correct is A, C & D
A) This is right
You manage PDBs in an Oracle RAC-based CDB by managing services, regardless of whether the PDBs are policy managed or administrator managed. Assign one dynamic database service to each PDB to coordinate start, stop, and placement of PDBs across instances in a clustered container database.
B) This is wrong
Example, if you have a CDB called raccont with a policy-managed PDB called spark, which is in a server pool called prod, then assign a service called plug to this database using the following command:
srvctl add service -db raccont -pdb spark -service plug -serverpool prod
The service plug will be uniformly managed across all nodes in the server pool. If you want to have this service running as a singleton service in the same server pool, use the -cardinality singleton parameter…
C)
To manage an application using either deployment scheme, you must create a server pool before adding the resource to the cluster
D)
Oracle recommends you create server pools for database management before you create the respective databases. DBCA, however, will present you with a choice of either using precreated server pools or creating a new server pool, when you are creating a policy-managed database.
E) This is wrong
You manage PDBs in an Oracle RAC-based CDB by managing services, regardless of whether the PDBs are policy managed or administrator managed. Assign one dynamic database service to each PDB to coordinate start, stop, and placement of PDBs across instances in a clustered container database.
DBCA – Create Database Setp 5 of 14
———————————–
Because policy-managed configuration was selected, the server pool to host the new CDB must be defined. Choose between using an existing server pool or creating a new one and specifying the detail of the new server pool to be used by the CDB.
Policy-managed deployments facilitate consolidation. In the case of schema consolidation, where multiple applications are being hosted in a single database (CDB) separated into PDBs, since server pools determine which services run together or separately, you can configure and maintain required affinity or isolation of PDB services.
Managing a policy-managed database requires less configuration and reconfiguration steps than an administrator-managed one with respect to creation, sizing, patching, and load balancing. Also, because any server in the server pools within the cluster can run any of the CDB instances and PDB services, you do not have to create and maintain CDB instance-to node-name mappings and PDB service-to-node-name mappings.
The correct is: A, D & E