Oracle RAC 11gR2 Policy Managed Database Creation using DBCA.

Policy managed databases depend upon server pools in order to work.


Starting from 11gR2, Oracle RAC has three kinds of server pools.

1) Free Server Pool - This pool contains servers which are not assigned to 
   any server pools.
2) Generic Server Pool - This pool contains Pre 11gR2 databases as well as administrator-managed
   databases. 
3) User Created pool - This server pool is created by the user and is used for running 
   policy managed databases.




I have a test three node cluster, Which will be used for creating 
policy managed database.

# Make sure that clusterware services are running on all the nodes
# before starting starting with the installation.

[root@rac1 ~]# su - grid
[grid@rac1 ~]$ crsctl check cluster -all
**************************************************************
rac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac3:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

Also, make sure that you have appropriate servers in the free pool.

[grid@rac1 ~]$ crsctl status serverpool
NAME=Free
ACTIVE_SERVERS=rac1 rac2 rac3

NAME=Generic
ACTIVE_SERVERS=
 

In my test cluster i did not have servers in the free pool as they were being
used in the generic pool because of the administrator managed database that i had
created earlier.

So, i had to drop that database in order get servers in the free pool. 


Start with the database creation.

[root@rac1 ~]# xhost +
access control disabled, clients can connect from any host
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ dbca










In the server pool creation step i have set the cardinality to "2"

this means that out of three nodes my database will run only on 2 nodes

at a time. 




















[grid@rac1 ~]$ crsctl status serverpool
NAME=Free
ACTIVE_SERVERS=rac1

NAME=Generic
ACTIVE_SERVERS=

NAME=ora.myserverpool
ACTIVE_SERVERS=rac2 rac3

[oracle@rac1 ~]$ srvctl status database -d dell
Instance dell_1 is running on node rac2
Instance dell_2 is running on node rac3