HP Serviceguard Toolkits for Database Replication Solutions manual Single-instance environment

Page 24

Single-instance environment

The sample configuration mentioned below uses the installation directory mode operation. This example on ODG package setup and configuration is for an ODG configuration using LVM. It illustrates the creation of a package for ODG in a single-instance environment.

1.Creating a package configuration

Create two packages: one for the primary database on the primary cluster and the other for the standby database on the standby cluster.

Create a directory in/etc/cmcluster,

for example, /etc/cmcluster/pkg/dgpkg

This directory becomes TKIT_DIR and cd to this directory.

Run the following commands to create the package configuration file templates.

NOTE: For a single-instance database, the ODG toolkit must be used in combination with the ECMT toolkit.

In the below mentioned example, the ODG toolkit module is used with the ECMT Oracle modules as follows:

#cmmakepkg -m ecmt/oracle/oracle -m tkit/dataguard/dataguard dgpkg.conf

Specifying configuration parameters in the package

After the package configuration file is created, you must specify various parameter values. Only the parameters that are to be modified in dgpkg.conf specifically for this configuration are shown here.

The package configuration file shown below contains attributes of both the ECMT Oracle toolkit and the ODG toolkit.

The following attributes are specific to the Oracle toolkit in ECMT:

#

#“package_name” is the name that is used to identify the package.

#Package names must be unique within a cluster.

#

package_name dgpkg

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

#

#“package_description” specifies the application that the package runs.

package_description “Serviceguard Package”

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

#“package_type” is the type of package.

#The package_type attribute specifies the behavior for this package.

#

package_type failover

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

#

#“run_script_timeout” is the number of seconds allowed for the package to start.

#“halt_script_timeout” is the number of seconds allowed for the package to halt.

run_script_timeout 300 halt_script_timeout 600

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

#“script_log_file“ is the full path name for the package control script log

#file.

script_log_file /etc/cmcluster/pkg/dgpkg/pkg.log

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

#

#Define package configuration directory

ecmt/oracle/oracle/TKIT_DIR /etc/cmcluster/pkg/dgpkg

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

24 Serviceguard toolkit for Oracle Data Guard

Image 24
Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Overview AdvantagesSupported configuration DependenciesSingle-instance Oracle database Cmmakepkg -i pkgasciifile -m modulefilename outputfilename RAC environment RAC environmentServiceguard 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 Configuring multiple instances of Oracle Data Guard Multiple Data Guard instances in each Serviceguard clusterSetting up Oracle Data Guard toolkit Installing and uninstalling Oracle Data Guard toolkit# swinstall -s depot path High availability for data guard broker# swlist -l product T2259AA Files for the ADF module Activestandby Configuring Oracle Data Guard toolkit Package attributesSingle-instance environment For example, /etc/cmcluster/pkg/dgpkgSetting up Oracle Data Guard toolkit #ecmt/oracle/oracle/LISTENERRESTART Servicefailfastenabled no servicehalttimeout RAC environment For example, /etc/cmluster/pkg/racdgpkgWhere ocmnp is the Smnp package for Oracle CLusterware Adding the package to the Serviceguard cluster Maintaining Oracle Data Guard toolkitCluster verification for Oracle Data Guard toolkit Single-instance environmentTroubleshooting Pkg.conf commandLimitations Startstandbyasprimary to yes Prerequisites Using the DB2 Hadr toolkit Supported configurationWhen primary and standby packages are in the same cluster Event 1 Standby database or Hadr goes downEvent 2 Primary package fails When primary and standby packages are in different clusters Primary and Standby Packages in Different ClustersCreating packages To provide high availability only to primary databaseGo to the /etc/cmcluster/hadrprimary directory Cmmakepkg -m ecmt/db2/db2 -m tkit/db2hadr/db2hadr pkg.confInstancename Hadrip Managing packages Running packagesMaintaining packages And, $ cmmodpkg -e hadrpkgHalting packages # cmhaltpkg packagenameHost key verification failed. Lost connection Limitations How to contact HP Information to collect before contacting HPWarranty information HP authorized resellersDocumentation feedback Related information Typographic conventionsTIP Db2 get db cfg for db2 database name grep -i hard Node3# /usr/bin/ssh-keygen -t rsaNode3# /usr/bin/ssh-keygen -t dsa Node2# /usr/bin/ssh-keygen -t rsaPage To add a new key to/home/user/.ssh/knownhosts Page Glossary Index