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.

Server pool attributes are the attributes that you define to create and manage server pools.

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.

When you use SRVCTL to create a server pool, the server pool attributes available to you are:

-category
-importance
-min
-max
-serverpool
-servers

SRVCTL prepends "ora." to the name of the server pool.

See Also:

"crsctl add serverpool" for more information

Table 3-1 Server Pool Attributes

Attribute	Values and Format	Description
ACL	String in the following format: owner:user:rwx,pgrp:group:rwx,other::r—	Defines the owner of the server pool and which privileges are granted to various operating system users and groups. The server pool owner defines the operating system user of the owner, and which privileges that user is granted. The value of this optional attribute is populated at the time a server pool is created based on the ACL of the user creating the server pool, unless explicitly overridden. The value can subsequently be changed, if such a change is allowed based on the existing privileges of the server pool. In the string: `owner`: The operating system user of the server pool owner, followed by the privileges of the owner `pgrp`: The operating system group that is the primary group of the owner of the server pool, followed by the privileges of members of the primary group `other`: Followed by privileges of others `r`: Read only `w`: Modify attributes of the pool or delete it `x`: Assign resources to this pool By default, the identity of the client that creates the server pool is the `owner`. Also by default, `root`, and the `user` specified in `owner` have full privileges. You can grant required operating system users and operating system groups their privileges by adding the following lines to the `ACL` attribute: user:user_name:rwx group:group_name:rwx The operating system user that creates the server pool is the owner of the server pool, and the `ACL` attribute for the server pool reflects the UNIX-like read, write, and execute ACL definitions for the user, primary group, group, and other.
ACTIVE_SERVERS	A string of server names in the following format: server_name1 server_name2 ...	Oracle Clusterware automatically manages this attribute, which contains the space-delimited list of servers that are currently assigned to a server pool.
EXCLUSIVE_POOLS	String	This optional attribute indicates if servers assigned to this server pool are shared with other server pools. A server pool can explicitly state that it is mutually exclusive of any other server pool that has the same value for this attribute. Two or more server pools are mutually exclusive when the sets of servers assigned to them do not have a single server in common. For example, server pools A and B must be mutually exclusive if they both have the value of this attribute set to the same string, such as `pools_A_B`. Top-level server pools are mutually exclusive, by default.
IMPORTANCE	Any integer from 0 to 1000	Relative importance of the server pool, with `0` denoting the lowest level of importance and `1000`, the highest. This optional attribute is used to determine how to reconfigure the server pools when a node joins or leaves the cluster. The default value is `0`.
MIN_SIZE	Any nonnegative integer	The minimum size of a server pool. If the number of servers contained in a server pool is below the number you specify in this attribute, then Oracle Clusterware automatically moves servers from other pools into this one until that number is met. Note: The value of this optional attribute does not set a hard limit. It governs the priority for server assignment whenever the cluster is reconfigured. The default value is `0`.
MAX_SIZE	Any nonnegative integer or `-1` (no limit)	The maximum number of servers a server pool can contain. This attribute is optional and is set to `-1` (no limit), by default. Note: A value of `-1` for this attribute spans the entire cluster.
NAME	String	The name of the server pool, which you must specify when you create the server pool. Server pool names must be unique within the domain of names of user-created entities, such as resources, types, and servers. A server pool name has a 254 character limit and can contain any platform-supported characters except the exclamation point (!), the tilde (~), and spaces. A server pool name cannot begin with a period nor with ora. Note: When you create server pools using SRVCTL, the utility prepends "ora." to the name of the server pool.
PARENT_POOLS	A string of space-delimited server pool names in the following format: sp1 sp2 ...	Use of this attribute makes it possible to create nested server pools. Server pools listed in this attribute are referred to as parent server pools. A server pool included in a parent server pool is referred to as a child server pool. Note: If you use SRVCTL to create the server pool, then you cannot specify this attribute.
SERVER_CATEGORY	String	The name of a registered server category, used as part of server categorization. Oracle Clusterware standard Clusters and Oracle Flex Clusters have default categories of `hub` and `leaf`. When you create a server pool, if you set a value for `SERVER_CATEGORY`, then you cannot set a value for `SERVER_NAMES`. Only one of these parameters may have a non-empty value. Use the `SERVER_CATEGORY` attribute to classify servers assigned to a server pool based on server attributes. You can organize servers and server pools in a cluster to match specific workload to servers and server pools, based on server attributes that you define. See Also: `"crsctl status server"` for a list of server attributes
SERVER_NAMES	A string of space-delimited server names in the following format: server1 server2 ...	A list of candidate node names that may be associated with a server pool. If you do not provide a set of server names for this optional attribute, then Oracle Clusterware is configured so that any server may be assigned to any server pool, to the extent allowed by values of other attributes, such as `PARENT_POOLS`. The server names identified as candidate node names are not validated to confirm that they are currently active cluster members. Use this attribute to define servers as candidates that have not yet been added to the cluster. If you set a value for `SERVER_NAMES`, then you cannot set a value for `SERVER_CATEGORY`; Only one of these attributes may have a non-empty value. Note: If you set the `SERVER_CATEGORY` attribute and you need to specify individual servers, then you can list servers by name using the `EXPRESSION` server category attribute.