Oracle Net8 Configuration and Troubleshooting

Name

FAILOVER_MODE

Synopsis

FAILOVER_MODE =
  [(BACKUP = backup_net_service_name)]
  (TYPE = {SESSION | SELECT | NONE})
  (METHOD = {BASIC | PRECONNECT})
  [(RETRIES = retry_attempts)]
  [(DELAY = retry_delay)]

This entry is used to implement transparent application failover. See Chapter 8 for a description of this feature.

Parameters

backup_net_service_name

The net service name to use as the backup connection.

TYPE

Specifies the type of failover, which controls what Net8 does when the primary connection fails. Valid values are as follows:

SESSION

Establish a session with the backup instance.

SELECT

Establish a session with the backup instance, reopen cursors for any outstanding SELECT statements, and reposition those cursors so that fetching continues from the point the client was at when the primary connection failed.

NONE

Don’t fail over at all. This TYPE option allows you to explicitly specify the default behavior.

METHOD

Specifies when to make the connection to the backup instance. The following values are valid:

BASIC

Establish the connection to the backup instance only if and when the connection to the primary instance fails.

PRECONNECT

Establish the backup connection at the same time as the primary connection. This allows failover to occur more quickly, but it also places a resource demand on the backup instance.

retry_attempts

Specifies the number of attempts to retry a connection to the backup instance when a failover occurs. The default is normally 0, but if a value is specified for DELAY, the default ...