Operating System(s): RHEL/OEL 5.x
Oracle version(s): 11.2.x.x
MC, Manjunatha Reddy
How do I configure a Server Pool in Oracle 11gR2?
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
NOTE: Oracle Clusterware will only move servers if you have non-default values for minimum or importance
Clusterware can move nodes from the free pool or from different pools whose importance is low and where there are more nodes than the minimum number of nodes set.
The following steps are performed to create a server pool via the command line:
- Log in as grid user
- Run the srvctl command from the Grid Home bin to see the default configuration. For example:
- $GRID_HOME/bin/srvctl config srvpool
- Add a server pool by running the following command:
- $ GRID_HOME/bin/srvctl add srvpool -g pspool -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 pspool, 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.
- Verify the server pool configuration by running the following command:
- $ GRID_HOME/bin/srvctl config srvpool
- Select Use Existing Server Pool for this database and select the server pool that you created. For example, pspool.
Perform the following steps to create the server pool from the Graphical User Interface:
- During Database Creation using DBCA in the Database Identification window, select the Configuration Type as Policy-Managed
- Enter the Global Database Name.
- Select Create New Server pool for this database and enter Server Pool Name and Cardinality.
- Click Next.