4 Administering Services

Using Services in Real Application Clusters Environments

Services are groups or classifications of applications that comprise business components that extend and respond to application workloads. Examples of services are Accounts Payable (AP), Customer Relationship Management (CRM), and so on. Services in RAC enable continuous, uninterrupted database operations to support multiple services on more than one instance.

Services enable RAC to integrate cluster database resources into a single system image to optimize cluster manageability. This simplifies system deployment, testing, and disaster recovery and administrative overhead. With services, users connect to a database without regard for which instance executes the SQL application service.

You assign services to run on one or more instances, and alternate instances can serve as backup instances in case the primary instance fails. If a primary instance fails, then Oracle moves the service from the failed instance to a surviving alternate instance.

Services enable you to model and deploy both planned and unplanned operations for all types of high availability or disaster recovery scenarios. During outages, RAC automatically restarts key components. Components that are eligible for automatic restart include instances, Oracle Net Services listeners, and the database as well as several database subcomponents.

To respond to changes in your cluster database, RAC uses events for rapid notification of state changes. After failures, event notifications initiate recovery processing to eliminate network timeouts and to provide end-to-end recovery of critical applications.

Because key resources are linked by RAC high availability events, resources respond to these events regardless of where the events occur in your environment. You can also define events to extend notification to middle-tier applications to simplify monitoring.

You can also modify your cluster configuration and still maintain service availability due to the resiliency of client-to-database connections. This is because RAC continually propagates both service and cluster configuration information throughout your cluster database. With connect-time and run-time routing, the number of instances that offer a service is transparent to applications.

Using the DBCA to Add and Modify Services

The DBCA Service Management feature enables you to manage service assignments and service preferences for instances and to configure Transparent Application Failover (TAF) policies. You can execute these procedures while your RAC database is running. Even if your instances or the RAC database is not running, you can still use the DBCA to configure services, but the services will not start. To add or modify services using the DBCA Services Management feature:

1. On the DBCA Welcome page, select the Oracle Real Application Clusters option and click Next.

2. On the DBCA Operations page, select Services Management and click Next.

3. On the DBCA List of Databases page, select the cluster database for which you want to configure services and click Next. If the database that you selected already has services assigned to it, then the DBCA displays these on this page.

4. Click Add or Modify.

5. To add a service, enter the name of the service. Note that service names with the prefix SYS$ are reserved for use by Oracle internal processes. To modify a service, edit the service and configure the service's instance preferences and TAF policies. Assign the service to instances for preferred (normal) and available (recovery) processing. The DBCA records your changes when you select another service or proceed to another page.

   
   

   Note: Entries you make in the Add a Service dialog are appended to the SERVICE_NAMES parameter entry which has a 4KB limit. Therefore, the total length of the names of all services assigned to an instance cannot exceed 4KB.

6. To remove a service, select the service and click Remove.

7. Click Finish and the DBCA displays the Summary page. Click OK and the DBCA displays a progress dialog while it configures your services.

When you click Finish, the DBCA configures the Cluster Ready Services (CRS) resources for the services that you added, modified, or removed. The DBCA also configures the net service entries for these services and starts them. When you use the DBCA to remove services, the DBCA stops the service, removes the CRS resource for the service, and removes the net service entries.

Changing VIP Addresses

Use the following procedure to change a VIP address:

1. Stop all database and ASM instances.

2. Stop the listeners, and node applications using the srvctl stop nodeapps command.

3. Run the srvctl modify nodeapps command with the -A option as described in Appendix B.

4. Restart all of the instances and node applications that you stopped in Step 1 and 2.

Administering Services in Real Application Clusters with Enterprise Manager

Use the Enterprise Manager service administration page to:

• Enable, disable, start, stop, and relocate cluster database services

• View the services that are available on the instances of a cluster database

• View the lists of running, preferred, and available instances that were configured during service definition

• View the TAF policy set for each service.

To access the Cluster Managed Database Services page, from the Enterprise Manager Home page, under View select Cluster Databases and click Go. This takes you to a cluster database's home page. Click the Administration tab and on the Cluster Database Administration page, under the High Availability options list in the right, click Cluster Managed Database Services.

The Cluster Managed Database Services page displays services that are available on cluster database instances. Also use this page to manually load balance services. On the Services Detail page, select the service that you want to administer using the radio buttons on the left-hand side of the panel and select an operation by clicking the command buttons on the right-hand side of the panel, such as ENABLE, DISABLE, and so on, and click OK. When you click OK, Enterprise Manager performs the operation that you selected on the service. Refer to the online help for more information about this page.

You can only administer a service with Enterprise Manager after creating the service with the DBCA or SRVCTL. In addition, to use TAF, you must have previously configured the service for TAF; you cannot use Enterprise Manager to create services or to set service TAF policies. To access the Services Details page:

• To start or stop a service, access the service by way of the Cluster Database page Administration tab and click Start or Stop.

Administering Services in Real Application Clusters with SRVCTL

The following sections explain how to use SRVCTL to administer services.

srvctl start service -d name [-s service_name_list] [-i inst_name]  [-o start_options] [-c connect_str | -q]

srvctl stop service -d name -s service_name_list [-i inst_name]  [-o start_options] [-c connect_str | -q]

srvctl enable service -d db_name -s service_name_list [-i inst_name]

srvctl disable service -d db_name -s service_name_list [-i inst_name]

srvctl relocate service -d crm -s crm -i crm1 -t crm3

srvctl status service -d crm -s crm -v

srvctl status service -d crm -s crm