Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware?
A.
Server Pools must be managed with the crsctl utility for servers hosting an application or other administrator-defined high-availability resource.
B.
All servers in a new cluster installation belong to the generic server pool.
C.
The server pool contains servers that host administrator-defined high availability resources.
D.
Server pools must be managed with the srvctl utility for servers hosting a database.
E.
All servers in a new cluster installation belong to the free server pool.
Explanation:
C: Server pools divide the cluster into logical groups of servers hosting both singleton and uniform applications. The application can be a database service or a nondatabase application.
D: You manage server pools that contain Oracle RAC databases with the Server Control (SRVCTL) utility.
E: When Oracle Clusterware is installed, two internal server pools are created automatically: Generic and Free. All servers in a new installation are assigned to the
Free server pool, initially
https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92594
Hello
I think that correct answer is ADE
The decision about which utility to use is based upon the type of resource being hosted in the server pool. You must use SRVCTL to create server pools that host Oracle databases. You must use CRSCTL to create server pools that host non-database resources such as middle tiers and applications.
https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92637
Marc
Hi Marc (A,D,E) correct
A,D:
-A DBA uses srvctl to create a server pool for servers
hosting a database or database service.
– A clusterware administrator uses crsctl to create a server
pool to host applications and other nondatabase uses.
E:All servers in a new installation are assigned to the FREE server pool
I think that “D” is not correct
Overview of Server Pools and Policy-Based Management
. Server Pool Attributes
. . You can use SRVCTL or CRSCTL to create server pools for databases and other applications, respectively. If you use SRVCTL to create a server pool, then you can only use a subset of the server pool attributes described in this section. If you use CRSCTL to create server pools, then you can use the entire set of server pool attributes.
Oracle RAC Environment CRSCTL Commands
. crsctl add serverpool
. . Use the crsctl add serverpool command to add a server pool that is for hosting non-database resources (such as application servers) to Oracle Clusterware.
A, C and E
Base on this https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD00100 I would say the answer is A, D, E.
A serverpool does not necessarily contain administrator-defined resources as suggested by C. For instance, where do the default services created during database creation run in a policy managed database?
Think about… my choice is by “C”
https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92105
Overview of Server Pools and Policy-Based Management
Oracle Clusterware 11g release 2 (11.2) introduced server pools, “”where resources that Oracle Clusterware manages”” are contained in logical groups of servers called “”server pools””. Resources are hosted on a shared infrastructure and are contained within server pools. Examples of resources that Oracle Clusterware manages are database instances, database services, application VIPs, and application components.
Server Pools and Policy-Based Management
With policy-based management, administrators specify the server pool (EXCLUDING the Generic and Free pools)…
Default Server Pools
When Oracle Clusterware is installed, two internal server pools are created automatically: Generic and Free. “”All servers in a new installation are assigned to the Free server pool, initially””. Servers move from Free to newly defined server pools automatically.
The Generic Server Pool
The Generic server pool stores any server that is not in a top-level server pool and “”is not policy managed.””
“D” – It is so strong! “MUST BE” and not “CAN BE”… it “can be”!
With policy-based management, administrators specify the
server pool in which the servers run.
– A DBA uses srvctl to create a server pool for servers hosting a database or database service.
– A clusterware administrator uses crsctl to create a server pool to host applications and other nondatabase uses.
Correct :ADE
Ok! “A”, “D” and “E”
“Notes:
…
. To configure Oracle resources, use the server control utility, SRVCTL, which provides you with all configurable options.”
“Server Pools and Policy-Based Management
With policy-based management, administrators specify the server pool (excluding the Generic and Free pools) in which the servers run. For example, a database administrator uses SRVCTL to create a server pool for servers hosting a database or database service. A clusterware administrator uses CRSCTL to create server pools for non-database use, such as creating a server pool for servers hosting an application.”
“How Server Pools Work
…
You manage server pools that contain Oracle RAC databases with the Server Control (SRVCTL) utility. Use the Oracle Clusterware Control (CRSCTL) utility to manage all other server pools. Only cluster administrators have permission to create top-level server pools.
Database administrators use the Server Control (SRVCTL) utility to create and manage server pools that will contain Oracle RAC databases. Cluster administrators use the Oracle Clusterware Control (CRSCTL) utility to create and manage all other server pools, such as server pools for non-database applications. Only cluster administrators have permission to create top-level server pools.”
B is wrong
All servers in a new installation are assigned to the Free server pool
https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92594
So E is correct.
C is wrong
C will be right if The statement should be like this:
The server pool contains servers that host administrator-defined high availability resources and clusterware resource
So correct is: A,D,E