Understanding the HP Serviceguard Extension for Oracle E-Business Suite (SGeEBS)

The APPS package will remain in this state for 10 iterations of the monitoring loop. For a monitoring

interval of 30 seconds, this will result in a maximum time of 5 minutes. If the DB package returns to

the running state within this time interval, the APPS Tier will reestablish JDBC connection with the DB

Tier and both the packages will continue to run in normal state. This feature helps end users of APPS

to retain their http connections during failover of the DB Tier.

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/files can be found in six directories as described below:

1. /opt/cmcluster/ebs/common - (Files common to DB and APPS)

README - Integration instructions

SGAlert.sh - Alert Mail generation script

parse_ebs_xml.pl - Perl script to parse EBS Apps configuration file

2. /opt/cmcluster/ebs/common/db - (Files of DB Tier)

haebsdb.conf - EBS DB user configuration file

toolkit.sh - Wrapper used from Serviceguard run script to invoke EBS DB package

haebsdb.sh - Main shell script for starting and stopping Oracle DB

hadb.sh - Second level scripts to start/stop Oracle DB

ebsdb.mon - Called by haebsdb.sh to monitor Oracle DB processes

ebslsnr.mon - Called by haebsdb.sh to monitor Oracle listener process

3. /opt/cmcluster/ebs/common/apps - (Files of APPS Tier)

ebsapps.conf - EBS APPS user configuration file

toolkit.sh - Wrapper used from Serviceguard run script to invoke EBS APPS Tier

haebsapps.sh - Main shell script for starting and stopping EBS APPS Tier

haapps.sh - Second level scripts to start/stop EBS Apps Tier servers

ebsapps.mon - Called by haebsapps.sh to monitor EBS Apps Tier servers

4. /etc/cmcluster/modules/ebs - (ADF Module files of EBS)

Db - Soft link to db. 1

db. 1 - ADF module definition for DB Tier

apps - Soft link to apps. 1

apps. 1 - ADF module definition for APPS Tier

5. /etc/cmcluster/scripts/ebs/db (Module scripts of DB Tier)

tkit_module.sh - DB Tier Module script

tkit_gen.sh - DB Tier Configuration file generator script