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.
Controls
-
O10 Oracle 10g
Syntax
|
1 |
HANotification=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
A value specifying whether the client
|
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
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.DbParameter="HANotification='Yes'"