Specifies whether a High Availability (HA) client connected to an RAC database will be notified if the database server shuts down.
O10 Oracle 10g
HANotification=value
Parameter |
Description |
|---|---|
value |
A value specifying whether the client will be notified if the database server shuts down. Values are:
|
HANotification=“No”
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+.
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'"
