This chapter describes the tasks you must complete to install and configure Oracle Database QoS Management on your system. Some of the tasks in this section must be performed by the cluster administrator.
Oracle Clusterware Administration and Deployment Guide for information about the cluster administrator
The minimum size of this server pool is the number of database instances. If the maximum size of the server pool is greater than the minimum size, then new instances can be added to the database to handle peak workloads or to accommodate growth.
The installation and configuration of Oracle Grid Infrastructure for a cluster is not covered in this book. Refer to Oracle Grid Infrastructure Installation and Upgrade Guide for your platform for information about installing and configuring Oracle Grid Infrastructure for a cluster.
By default, a server pool called the Free pool is created during Oracle Grid Infrastructure installation. To create server pools for your Oracle RAC database, you can use SRVCTL or Oracle Enterprise Manager.
When you use DBCA to create an Oracle RAC database, you select policy-managed for the database, and choose the server pools which the database instances should run in.
Oracle Clusterware Administration and Deployment Guide for information about server pools
Oracle Real Application Clusters Administration and Deployment Guide for information about using SRVCTL to create a server pool
Oracle Real Application Clusters Installation Guide for Linux and UNIX for information about using DBCA to create an Oracle RAC database
If you use a cluster administrator that is separate from the database administrator, then only the cluster administrator user can create server pools. The cluster administrator then grants privileges on the server pools to the operating system user that owns the Oracle RAC installation. See Oracle Clusterware Administration and Deployment Guide for more information.
When creating a server pool for use with Oracle Database QoS Management, do not configure the
SERVER_NAMES attribute (the
-servers option of
srvctl add svrpool or
srvctl modify svrpool commands) for the server pool; Oracle Database QoS Management does not support server pools that use candidate lists.
The steps for creating and configuring an Oracle RAC database are not covered in this book. Refer to Oracle Real Application Clusters Administration and Deployment Guide for information on creating an Oracle RAC database using server pools. When creating a database, the DBA should choose to create a policy-managed database.
After you have created the databases, perform the following steps to configure the databases for use with Oracle Database QoS Management:
CPU_COUNT parameter for each database instance that runs in a server pool must be set to the same value if the database is managed by Oracle Database QoS Management.
On each server, the sum of the values for
CPU_COUNT for all database instances running on that server must be less than or equal to the physical CPU count. For example, if you have a server with eight CPUs, and there are two database instances running on this server, then, for the databases to be managed by Oracle Database QoS Management, the
CPU_COUNT parameter for each database instance must be set so that the values of the
CPU_COUNT parameters for all instances on the server add up to eight or less. For example, you could have
CPU_COUNT=3 on one instance and
CPU_COUNT=4 on the other instance, or
CPU_COUNT=6 on one instance and
CPU_COUNT=2 on the other instance.
By default, the CPU count of each database that is started on a server is set to the number of physical CPUs installed for that server.
If you are running more than one database in a server pool, then using the default settings for
CPU_COUNT will cause Oracle Database QoS Management to report a violation. To avoid this error, manually configure the
CPU_COUNT value in the SPFILE using either Oracle Enterprise Manager or SQL*Plus.
CPU_COUNTdatabase initialization parameter for all instances of your Oracle RAC database:
ALTER SYSTEM SET cpu_count=n SCOPE=BOTH SID='*';
In the previous command, n is the number of CPUs that should be used by the database instances.
CPU_COUNT is a dynamic parameter that is not set by default. It should be set to the maximum number of CPUs that the database instance should utilize at any time. The sum of the values of
CPU_COUNT for all instances on a server should not exceed the number of physical CPUs for that server. As a best practice, Oracle recommends using a minimum value of 2 for
Applications and users connect to the database using services.
For information about creating services for your Oracle RAC database, refer to Oracle Real Application Clusters Administration and Deployment Guide.
Before logging in to the Oracle Database QoS Management Dashboard (the Dashboard), you must create an Oracle Database QoS Management administrative user. The operating system user associated with this account must be a cluster administrator user to initially set this up.
The administrative user for the Oracle Database QoS Management server is referred to as the QoS Admin user. This user has access to all the features of the Oracle Database QoS Management server, including checking and changing the account password for the QoS Admin user. You can have multiple QoS Admin users.
srvctl status oc4j
srvctl stop oc4j
qosctl qosadmin -setpasswd qosadmin
After you enter this command, you are prompted to enter the password of the default QoS Admin user one or more times.
If you want to use a different user name, then you would enter the following command:
qosctl qosadmin -adduser username
In this example:
qosadmin is the name of the default QoS Admin user.
username is the name of the QoS Admin user you are creating. You are prompted to enter a password for this user
srvctl start oc4j
"Creating Administrative Users for Oracle Database QoS Management" for a complete description of the QOSCTL utility and its commands
Managing the cluster
Managing individual databases that run on the cluster
If you have multiple databases running on the same cluster, you can determine which databases are managed by Oracle QoS Management. To manage a database, all the databases that use the same server pool must be enabled for Oracle Database QoS Management; otherwise a violation is signalled when you try to access the Dashboard for the database.
To enable Oracle QoS Management for your system, perform the following steps:
To complete this step, you must specify the login information for both a SYSDBA and a cluster administrator account.
The Enable/Disable QoS Management screen is displayed.
When you provide a password, the following actions take place:
The APPQOSSYS account, which enables the Oracle Database QoS Management server to connect to the database, is unlocked and the new password is set.
APPQOS_PLANis set as the active Oracle Database Resource Manager plan for all actively managed databases, so that Oracle Database QoS Management can adjust CPU access for Performance Classes. The APPQOS_PLAN is not required for databases where all their Performance Classes are checked Measure-Only.
backoffice. Click Next.
On the last step of the Create Policy Set Wizard, click Submit Policy Set.