HP Serviceguard Toolkit for Oracle E-Business Suite User Guide HP Part Number: 5900-1563 Published: May 2011 Edition: 1
© Copyright 2011 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice.
Contents 1 Introduction...............................................................................................4 SGeEBS Overview....................................................................................................................4 EBS APPS tier...........................................................................................................................4 2 Configuring EBS and SGeEBS......................................................................
1 Introduction Serviceguard is the software (or middleware) that gives you the ability to create a High Availability (HA) clustering environment. HP Serviceguard extension for E-Business Suite (SGeEBS) extends HP Serviceguard failover cluster capabilities to Oracle E-Business Suite environments. It also protects the application tier of Oracle Enterprise Business Suite (EBS). Serviceguard Manager Version B.03.10 included in Serviceguard version 11.
2 Configuring EBS and SGeEBS Configuring EBS for SGeEBS SGeEBS does not require custom modifications of EBS configuration files, application code, or AutoConfig generated scripts. This ensures that when EBS configuration and patching processes are performed, unexpected errors do not occur.
NOTE: For more information on configuring for an external entry point, see Oracle Metalink note 380489.1. For example, by using the configuration shown in Figure 1 (page 7), the Web entry point and external URLs on node sg-serv1 and sg-serv2 are changed from containing sg-serv1 and sg-serv2 to ebsapps.
applications tier services, that is, concurrent manager is run on the same server at the same time as the Web and Forms components. If an APPS tier server failure occurs, the concurrent processing subsystem undergoes a failover with the rest of the application tier services to the alternative node and is automatically restarted on that server. Through PCP functionality, concurrent managers are now restarted on the alternate server and batch and asynchronous job processing can now continue.
Figure 2 Failover of the Oracle EBS APPS tier package Configuring SGeEBS for EBS Download or copy the SGeEBS depot file, along with the required patches to all nodes of the cluster and install the depot and the patches using the swinstall command. After installing SGeEBS, the installed scripts/or files can be found in four directories as described below: 1. /opt/cmcluster/ebs/common README SGAlert.sh parse_ebs_xml.pl 2. /opt/cmcluster/ebs/apps ebsapps.conf toolkit.sh Tier haebsapps.sh haapps.sh ebsapps.
Procedure to upgrade DB tier from 11gR1 to 11gR2 version of Oracle 1. 2. 3. Stop the APPS Tier packages on all nodes of the cluster if APPS tier is configured with the multiple application instances configuration. If APPS tier is configured as a single application instance, APPS tier package must be stopped on the node hosting the application package. For complete Oracle upgrade procedure, see the latest version of Oracle document Interpretability Notes EBS R12 with Database 11gR2 [ID 1058763.1].
Serviceguard first tries to use the toolkit.sh script in the configuration directory. If this script is not found in the configuration directory, it takes them from the installation directory. NOTE: EBS APPS Tier accesses Oracle database instance through a 'hostname'. Therefore you need to add entries for the relocatable IP-addresses of both, the APPS and the database package, to the /etc/hosts file on the nodes used for running EBS.
Figure 3 (page 10) shows ECMT EBS DB Tier package and SGeEBS APPS Tier package in single instance EBS APPS Tier configuration. SGeEBS APPS Tier package will start EBS APPS tier services depending on these four attributes: • ROOT_SERVICE • WEB_ENTRY_POINT • WEB_APPLICATION • BATCH_PROCESSING Set ROOT_SERVICE attribute to “yes”, to start opmn process. Set WEB_ENTRY_POINT attribute to “yes” to start HTTP server process.
# # # Define base directory in which Intance-specific EBS APPS info is installed ebs/apps/BASE_DIR /oraapps # # # # # Name of the file in which the user name and password of EBS APPS Tier is stored. This file is to be kept in TKIT_DIR/apps and should be protected against unauthorized access.
Configuring multiple node EBS APPS tier – Split EBS APPS tier services on different nodes Figure 4 Split EBS APPS tier services on different nodes SGeEBS Toolkit can be used in multi node APPS tier configuration. You can configure EBS APPS tier as two different packages, where one package includes Batch processing services and another package supports all OLTP transaction processes, which includes opmn, oc4j, and forms services.
package_type node_name node_name failover Node2 Node1 # #"run_script_timeout" is the number of Seconds allowed for package to start. #"halt_script_timeout" is the number of Seconds allowed for package to halt.
# package_name OLTP_APPSpackage # # "package_description" specifies the application that the package runs. # package_description "APPS Tier OLTP Package" # # "package_type" is the type of package. # The package_type attribute specifies the behavior for this package. # package_type failover node_name Node3 node_name Node4 # # "run_script_timeout" is the number of Seconds allowed for package to start. # "halt_script_timeout" is the number of Seconds allowed for package to halt.
Configuring multiple APPS tier nodes with multiple OLTP and batch processing services Figure 5 Configuring multiple APPS tier nodes with multiple OLTP and batch processing services Figure 5 (page 16) shows the cluster where multiple EBS APPS tier nodes are configured. ECMT EBS DB Tier package is configured to run on Node1. If there is any failure in any of the EBS DB Tier process, the package is configured to failover to Node2.
NOTE: 1. Set DNS with the symbolic hostname for the package IP address. 2. While starting all the server processes of the APPS Tier, the attributes ROOT_SERVICE, WEB_ENTRY_POINT, WEB_APPLICATION, and BATCH _PROCESSING must be set to "yes". While stopping the APPS Tier, all server processes are allowed to shutdown gracefully. Hence the Start/Stop sequence of APPS Tier takes a long time. To avoid timeouts, you must set high values for run_script_timeout and halt_script_timeout. 3.
is an outage at primary site and a timeout has occurred, but first the DB Tier package must be recovered. Once the DB Tier package comes up on the recovery cluster, the APPS Tier package can be recovered. You can recover individual recovery groups by using the following commands: # cmrecovercl -g DBTier_RecoveryGroup # cmrecovercl -g APPSTier_RecoveryGroup If you run cmrecovercl with option -g it starts up only the recovery package configured in the specified recovery group.
3 Troubleshooting Oracle E-Business Suite is a complex product and has strong dependency on the configuration environment. HP recommends you not to make configuration changes when the application is up and running. To avoid undesirable problems, ensure the following: 1. 2. 3. 4. Always bring up the DB Tier package prior to the APPS Tier package. The DB Tier and APPS tier can run on the same node or on different nodes of the cluster. The APPS Tier start and stop takes 1 to 2 minutes.
4 Support and other resources Information to collect before contacting HP Be sure to have the following information available before you contact HP: • Software product name • Hardware product model number • Operating system type and version • Applicable error message • Third-party hardware or software • Technical support registration number (if applicable) How to contact HP Use the following methods to contact HP technical support: • In the United States, see the Customer Service/Contact HP Uni
HP authorized resellers For the name of the nearest HP authorized reseller, see the following sources: • In the United States, see the HP U.S. service locator website: http://www.hp.com/service_locator • In other locations, see the Contact HP worldwide website: http://welcome.hp.com/country/us/en/wwcontact.html Documentation feedback HP welcomes your feedback. To make comments and suggestions about product documentation, send a message to: docsfeedback@hp.
Computer output Information displayed by the computer. Ctrl+x or Ctrl-x A key sequence that indicates you must hold down the keyboard key labeled Ctrl while you press the letter x. ENVIRONMENT VARIABLE The name of an environment variable, for example, PATH. Key The name of a keyboard key. Return and Enter both refer to the same key. Term A term or phrase that is defined in the body text of the document, not in a glossary. User input Indicates commands and text that you type exactly as shown.
Index A AutoConfig, 5 Automatic storage, 9 C Concurrent Manager Process , 11 Concurrent processing, 6 Concurrent processing manager, 6 Configuring SGeEBS for EBS, 8 E EBS APPS Tier, 4 Enterprise Business Suite (EBS) , 4 Enterprise Cluster Master Toolkit (ECMT) for Oracle, 4 H High availability, 4 O Oracle 11gR2 , 8 P Package log file, 19 Parallel concurrent processing, 6 Parallel Concurrent Processor, 6 R RapidInstall, 5 S Serviceguard Continentalclusters, 17 Serviceguard extension for E-Business Sui
