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

O10 Oracle 10g

Syntax

HANotification=value

Parameter	Description
value	A value specifying whether the client will be notified if the database server shuts down. Values are: No (Default) Do not notify the client if the server shuts down. Yes Notify the client if the server shuts down.

Parameter

Description

value

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

No (Default) Do not notify the client if the server shuts down.
Yes Notify the client if the server shuts down.

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.

Examples

Example 1

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

Database profile Select the HANotification check box on the System page in the Database Profile Setup dialog box.

Application Type the following in code:

SQLCA.DbParameter="HANotification='Yes'"