HP Serviceguard Toolkits for Database Replication Solutions specification

NOTE: The following are the service commands for the package:

service_name oracle_service_test

service_cmd “$SGCONF/scripts/ecmt/oracle/tkit_module.sh oracle_monitor” service_restart none

service_fail_fast_enabled no service_halt_timeout 300

service_name oracle_listener_service_test

service_cmd “$SGCONF/scripts/ecmt/oracle/tkit_module.sh oracle_monitor_listener” service_restart none

service_fail_fast_enabled no service_halt_timeout 300

service_name oracle_hang_service_test

service_cmd “$SGCONF/scripts/ecmt/oracle/tkit_module.sh oracle_hang_monitor 30 failover” service_restart none

service_fail_fast_enabled no service_halt_timeout 300

service_name dataguard_service_test

service_cmd “$SGCONF/scripts/tkit/dataguard/tkit_module.sh dataguard_monitor“ service_restart none

service_fail_fast_enabled no service_halt_timeout 300

NOTE: The following attributes are specific to the ODG toolkit:

------------------------------------------------------------------------

#

#Define ACTIVE_STANDBY

tkit/dataguard/dataguard/ACTIVE_STANDBY no

------------------------------------------------------------------------

#Define MONITOR_DG_BROKER

#

tkit/dataguard/dataguard/MONITOR_DG_BROKERno

------------------------------------------------------------------------

#

#Define REAL_TIME_APPLY

tkit/dataguard/dataguard/REAL_TIME_APPLYno

------------------------------------------------------------------------

#Define START_STANDBY_AS_PRIMARY

#

tkit/dataguard/dataguard/START_STANDBY_AS_PRIMARY no

------------------------------------------------------------------------

#

#Define e-mail address for sending alerts

#tkit/dataguard/dataguard/ALERT_MAIL_ID

------------------------------------------------------------------------

Setting up Oracle Data Guard toolkit 27

Image 27

HP Serviceguard Toolkits for Database Replication Solutions manual Servicefailfastenabled no servicehalttimeout

Contents

HP Part Number Published August Edition Page Contents Glossary Index Introduction Advantages Overview Supported configuration DependenciesSingle-instance Oracle database Cmmakepkg -i pkgasciifile -m modulefilename outputfilename RAC environment RAC environment Serviceguard toolkit for Oracle Data Guard Data Guard replication between RAC primary and RAC standby Continentalclusters environment Continentalclusters environment Metrocluster and extended distance cluster environments Supported configuration Data Guard setup in an EDC environment Three data center configuration Multiple Data Guard instances in each Serviceguard cluster Configuring multiple instances of Oracle Data Guard High availability for data guard broker Setting up Oracle Data Guard toolkitInstalling and uninstalling Oracle Data Guard toolkit # swinstall -s depot path # swlist -l product T2259AA Files for the ADF module Activestandby Package attributes Configuring Oracle Data Guard toolkit For example, /etc/cmcluster/pkg/dgpkg Single-instance environment Setting up Oracle Data Guard toolkit #ecmt/oracle/oracle/LISTENERRESTART Servicefailfastenabled no servicehalttimeout For example, /etc/cmluster/pkg/racdgpkg RAC environment Where ocmnp is the Smnp package for Oracle CLusterware Maintaining Oracle Data Guard toolkit Adding the package to the Serviceguard cluster Single-instance environment Cluster verification for Oracle Data Guard toolkit Troubleshooting Pkg.conf commandLimitations Startstandbyasprimary to yes Prerequisites Supported configuration Using the DB2 Hadr toolkit Event 1 Standby database or Hadr goes down When primary and standby packages are in the same cluster Event 2 Primary package fails Primary and Standby Packages in Different Clusters When primary and standby packages are in different clusters Cmmakepkg -m ecmt/db2/db2 -m tkit/db2hadr/db2hadr pkg.conf Creating packagesTo provide high availability only to primary database Go to the /etc/cmcluster/hadrprimary directory Instancename Hadrip And, $ cmmodpkg -e hadrpkg Managing packagesRunning packages Maintaining packages # cmhaltpkg packagename Halting packages Host key verification failed. Lost connection Limitations Information to collect before contacting HP How to contact HP Related information Typographic conventions Warranty informationHP authorized resellers Documentation feedback TIP Node2# /usr/bin/ssh-keygen -t rsa Db2 get db cfg for db2 database name grep -i hardNode3# /usr/bin/ssh-keygen -t rsa Node3# /usr/bin/ssh-keygen -t dsaPage To add a new key to/home/user/.ssh/knownhosts Page Glossary Index