HANotification
database parameter
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
|
1 |
HANotification=value |
|
Parameter |
Description |
|---|---|
|
value |
A value specifying whether the client will be
|
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:
1SQLCA.DBParm="HANotification='Yes'"