HP Serviceguard Toolkits for Database Replication Solutions manual Troubleshooting, Limitations

Page 32

verification logs appropriate warning messages. It does not lead to a package validation failure during package apply or package check.

In a single-instance environment, consider a two-node cluster, where both nodes have Serviceguard A.11.20, ECMT B.06.00 and same Oracle database versions but different ODG toolkit versions.

Use cmcheckconf to check package configuration using the node1# cmcheckconf -P

pkg.conf command:

On node2, validation of package dataguard succeeded with:

The toolkit configuration file in the toolkit configuration directory is backed up and a new file is created when the package configuration is applied.

On node1, validation of package dataguard succeeded with:

WARNING: ODG toolkit version on all package nodes does not match.

Check syslog for more details.

cmcheckconf: Verification completed with no errors found.

Use the cmapplyconf command to apply the configuration.

Troubleshooting

This section explains some of the problem scenarios that you may encounter while working with the ODG toolkit in an HP Serviceguard Cluster.

Problem Scenario

Possible Cause

Recommended Action

If the package log for the standby database contains an error message:

RFS process not found. Please check the network connection.

This message is logged when the standby database is unable to connect to the primary database. This could either be because the primary database is down, or the connection between the primary database and the standby database is lost.

Check if the primary database is up and running and the Data Guard state is healthy. Also check if the connection between the primary database and the standby database is good. If ALERT_MAIL_ID package attribute is set, then a mail is sent to the mail ID when this problem scenario occurs.

If the RAC Data Guard package for RAC database fails to start and logs the following message in the package log file:

Data Guard Broker configuration should not be enabled when MONITOR_DG_BROKER parameter in the Package Configuration File is set to no.

This message is displayed only in Data Guard RAC configurations. This message is logged when the package attribute MONITOR_DG_BROKER is set to no and Data Guard Broker is enabled for the database.

If the Data Guard Broker is enabled for the RAC database, the toolkit package attribute MONITOR_DG_BROKER must be set to yes. Otherwise, the package will not start.

Limitations

The ODG toolkit has the following limitations:

Both the primary database and the standby database cannot be part of the same Metrocluster. If standby is configured in the same Metrocluster it becomes a redundant configuration because the primary database is already being replicated (hardware replication) between the sites of the Metrocluster.

It does not support legacy style configuration. Hence, the combinational package of ODG toolkit module and ECMT Oracle toolkit Module (or SGeRAC toolkit database Module) cannot be packaged in legacy style although the ECMT (or SGeRAC) supports legacy style of packaging.

Multiple standby database instances cannot be supported in the Continentalclusters setup because only one recovery package and only one Data Receiver package can exist within the recovery group. Other standby instances can be configured outside the Continentalclusters environment.

32 Serviceguard toolkit for Oracle Data Guard

Image 32
Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Overview AdvantagesSingle-instance Oracle database Supported configurationDependencies 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/racdgpkg Where 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 environmentLimitations TroubleshootingPkg.conf command 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