Sunday, October 27, 2013

Server pool in Oracle 11gR2

The following steps are performed to create a server pool via the command line:
1.     Log in as grid user
2.     Run the srvctl command from the Grid Home bin to see the default configuration. For example:

$GRID_HOME/bin/srvctl config srvpool
3.     Add a server pool by running the following command:

$ GRID_HOME/bin/srvctl add srvpool -g oracle -l 2 -u 4 -i 2 -n node1, node2, node3, node4
where -g is the Server pool name, -l is the minimum number of nodes, -u is the maximum number of nodes, -i is the importance given to the server pool, -n is the node names which are part of the server pool. In this example,the server pool name is oracle   the maximum number of nodes are four, the minimum number of nodes are two, the relative priority of the server pool is two, and names of nodes in the pool are node 1, node 2, node 3,and node 4.

4.     Verify the server pool configuration by running the following command:
$ GRID_HOME/bin/srvctl config srvpool


A server pool is the logical division of the cluster into pools of servers for effective resource utilization. Server pools are used to create Policy Managed Databases.

A Policy-Managed database is dynamic with instances managed automatically based on resource requirement for expected workload where as Admin-Managed databases result in instances tied to specific servers.

Policy-Managed database facilitates easy allocation of resources to specific workload and simplifies the consolidation of Databases and Applications on Clusters.
There are 2 default pools after a Grid Infrastructure Installation or Upgrade:
• Free – any unassigned nodes go there and
• Generic – for administrator-managed databases

A server pool is defined by 3 attributes:
• Min- The minimum number of servers that should run in the server pool (default 0)
• Max– The maximum number of servers that can run in the server pool (default 0 or -1)
• Importance – Importance specifies the relative importance between server pools. 0 (least important) to 1000


No comments:

Post a Comment