Skip Headers
Oracle® Database Quality of Service Management User's Guide
11g Release 2 (11.2)

Part Number E16542-06
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

5 Troubleshooting Oracle Database QoS Management

This chapter describes some problems you might encounter when using Oracle Database QoS Management and how you can resolve them. This chapter also describes how to locate the trace or log files for Oracle Database QoS Management.

This chapter contains the following sections:

Common Problems

After the initial configuration, Oracle Database Quality of Service Management is an automated system. As a result, most of the problems you might encounter are related to configuring Oracle Database QoS Management. The following sections illustrate the most common problems, and how to resolve them:

Cannot Enable Oracle Database Quality of Service Management

Before you can enable Oracle Database QoS Management within a cluster, you must first create a Policy Set. To create a Policy Set, use the Create Policy Set link on the Oracle Enterprise Manager Database Control Cluster Administration page.

Cannot Enable Oracle Database QoS Management for a Database

For a database to be managed by Oracle Database QoS Management, the database must be compliant, enabled, and Oracle Database QoS Management must be able to access APPQOSSYS database user:

  • A compliant database is an Oracle RAC database that is running Oracle Database release 11.2.0.2 or greater and is configured to run in a Policy-managed deployment.

  • For a database to be enabled, Oracle Database QoS Management must be able to connect to the database. The connection is configured when you select the Enable Quality of Service Management link in the Oracle Enterprise Manager Database Control Database Availability page. When you select this link, you are prompted for the cluster credentials and the password for the APPQOSSYS account in the database. By default the APPQOSSYS account is expired. When you submit a password, the account is unlocked.

  • If the password for the APPQOSSYS user is changed through other methods or the account is locked, Oracle Database QoS Management is disabled for this database until this condition is corrected by selecting the Enable Quality of Service Management link again.

Oracle Database Resource Manager Not Enabled and Resource Plan Errors

Oracle Database QoS Management installs a special Oracle Database Resource Manager plan whenever a database is enabled for management by Oracle Database QoS Management. Oracle Database QoS Management requires this resource plan to move Performance Classes to different levels of CPU scheduling. No other plan can be active while Oracle Database QoS Management is enabled on this database. If a resource plan is not enabled for the Oracle RAC database, then an error results when trying to enable the database for management by Oracle Database QoS Management. After a resource plan is enabled, then enabling the database for management by Oracle Database QoS Management succeeds.

Do Not Have Access to a Server Pool

Server pools are a new Oracle Clusterware entity beginning in Oracle Grid Infrastructure 11g release 2. Server pools can be managed separately from the database by configuring special operating system groups. By default, the user that installed Oracle Grid Infrastructure for a cluster can perform operations on server pools. If you use a separate operating system for the Oracle Database installation, then execute permissions on a server pool must be granted to the database software owner before a database can be deployed in that server pool. To grant this permission, you must use the CRSCTL utility to modify the server pool ACL attribute. A database administrator can also create server pools using Server Control (SRVCTL) or Oracle Enterprise Manager.

See Also:

Oracle Clusterware Administration and Deployment Guide for information about crsctl commands

Server Pool Is Marked As Unmanageable

A server pool is marked as unmanageable if Oracle Database QoS Management is not able to properly measure or predict the performance of Performance Classes deployed in that server pool. A server pool can be considered unmanageable under the following conditions in Oracle Database 11g release 2 (11.2.0.2):

  1. The servers in the server pool have different physical CPU counts.

  2. The CPU count for every database instance could not be retrieved.

  3. The sum of the configured CPU counts for all databases on a server is greater than its physical CPU count

  4. Singleton services are deployed in a server pool with a maximum size larger than one.

  5. Oracle Database QoS Management is unable to collect the metrics for all Performance Classes, or the metrics collected do not contain valid data.

  6. The server pool has a database that is not enabled for Oracle Database QoS Management.

Metrics Are Missing For a Performance Class

Metrics are captured by Oracle Database QoS Management by querying the managed database instances in the cluster. Metrics are not be displayed under the following circumstances:

  1. The database calls (work being done) do not match the classifiers defined for a specific Performance Class and "No demand" is displayed.

  2. A more general classifier of a Performance Class is evaluated first. As a result, the Performance Class with the more specific classifier is shown as having "No demand". For example, if the sales_pc Performance Class uses the classifier service=Sales and the sales_search Performance Class uses the classifier (service=Sales and action=Search), then, if the sales_pc Performance Class was listed first in the Edit Policy Set Performance Class Order screen, then any work request that uses the sales service would be placed in the sales_pc Performance Class, including those that are performing the Search action. The sales_search Performance Class does not generate any metrics and "No demand" is displayed for that Performance Class.

  3. The database instance is over-utilized and the metrics query reaches the time out limit and "Incomplete data" is displayed.

  4. The database is not producing mutually consistent data for the Performance Class and "Nonconforming data" is displayed. For example a Performance Class that is classifying database calls that exceed one second will cause this response.

  5. The metrics collected through the query do not pass the sanity verification checks performed by Oracle Database QoS Management and "Nonconforming data" is displayed.

Oracle Database QoS Management is not Generating Recommendations

Recommendations are generated once a minute when logged into the Oracle Database QoS Management Dashboard (the Dashboard). Recommendations do not appear on the Dashboard in the following cases:

  1. Oracle Database QoS Management is disabled.

  2. An action is in progress implementing a recommendation.

  3. During the first minute of enabling Oracle Database QoS Management, or when submitting a Policy Set or activating a Policy Set.

Recently Added Server was Placed in the Wrong Server Pool

Servers are moved within a cluster by Oracle Clusterware, or as directed by an administrator. When a new server joins the cluster, Oracle Clusterware places the server in a server pool according to the placement algorithm and the state of the server pool attributes of Min, Max and Importance. See the Oracle Clusterware Administration and Deployment Guide for a complete description of this placement process.

RMI Port Conflict Detected

When you install Oracle Grid Infrastructure for a cluster, the default port for the Oracle Application Server Containers for J2EE (OC4J) resource is set to 23792. This can cause a port conflict with Java Remote Method Invocation (RMI). You should set the OC4J_PORT environment variable in your environment to the number of an available port, then restart the OC4J resource using the following command:

srvctl start oc4j

Locating Log or Trace Files

The log files for Oracle Database QoS Management are located in the Oracle Grid Infrastructure home directory:

Enabling Tracing

A default level of tracing is set at installation time. Finer-grained tracing may be enabled under the direction of Oracle Support.