Which statement is correct about this configuration?

You are in the planning stages for upgrading your Oracle RAC database from Oracle Database
10g Release 2 to Oracle Database 11g Release 2 to run under the Oracle Grid Infrastructure.
You decide to use an administrator-managed configuration because the cluster is fairly small.
Which statement is correct about this configuration?

You are in the planning stages for upgrading your Oracle RAC database from Oracle Database
10g Release 2 to Oracle Database 11g Release 2 to run under the Oracle Grid Infrastructure.
You decide to use an administrator-managed configuration because the cluster is fairly small.
Which statement is correct about this configuration?

A.
A parent pool of the GENERIC server pool will be used.

B.
You must define a new server pool called MANUAL.

C.
A subpool of the GENERIC server pool will be used.

D.
A subpool of the FREE server pool will be used.

Explanation:
With Oracle RAC 11g Release 2, there is only a database resource define to Oracle
Clusterware. This resource will contain the Oracle Home, the spfile, the server pool(s) and the
ASM diskgroup(s) required for the database. The database resource will have a weak start
dependency on the VIP which means it will try to start the VIP for the node when the instance
starts however if the VIP does not start successfully, the instance will still be started. When
reviewing the database resource for an administrator Managed database, you will see a server
pool defined with the same name as the Oracle database. This pool will be part of a special Oracle
defined server pool called Generic. The Generic server pool is managed by Oracle to support
Administrator Managed databases. The server pools that are part of Generic will be automatically
created or removed when you add or remove an Administrator Managed database.
Oracle Database 11gR2 Upgrade Companion (Version 2.70)



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is wrong. GENERIC pool is a sub pool
B is wrong. there is no default MANUAL pool
C is right. sub pool GENERIC will be used for admin-managed database
D is wrong. sub pool FREE is for policy-managed database

So C is correct.