Skip to Main Content
Oracle Net8 Configuration and Troubleshooting
book

Oracle Net8 Configuration and Troubleshooting

by Hugo Toledo, Jonathan Gennick
December 2000
Intermediate to advanced content levelIntermediate to advanced
408 pages
12h 26m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro Oracle Database 11g RAC on Linux

Pro Oracle Database 11g RAC on Linux

Steve Shaw, Martin Bach
Oracle 11g

Oracle 11g

Lewis Cunningham

Publisher Resources

ISBN: 1565927532Catalog PageErrata