HANotification

Description

Specifies whether a High Availability (HA) client connected to an RAC database will be notified if the database server shuts down.

Applies to

Syntax

HANotification=value

Parameter

Description

value

A value specifying whether the client will be notified if the database server shuts down. Values are:

Default

HANotification=“No”

Usage

Oracle Real Application Clusters (RAC) is a cluster database that uses a shared cache architecture. In Oracle 10g Release 2, a High Availability (HA) client connected to an RAC database can register a callback to indicate that it wants the server to notify it in case of a database failure event that affects a connection made by the client. The DBNotification event on the Transaction object is triggered when the client is notified that such an event has occurred.

The HANotification database parameter must be set to “Yes” for the DBNotification event to be triggered when the database server shuts down. If HANotification is set to “Yes”, the Oracle client and server must both be Oracle 10g version 10.2.0.1.0 or higher or the connection will fail.

This database parameter is not supported by EAServer and MTS/COM+ and will be ignored in PowerBuilder component connections on EAServer and MTS/COM+.

Examples

Example 1

To specify that the HA client should be notified when the database server shuts down: