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:
|
Default value
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 MTS/COM+ and will be ignored in PowerBuilder component connections on MTS/COM+.
Examples
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.DBParm="HANotification='Yes'"
