Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Name

connect_information

Synopsis

(CONNECT_DATA=
        [(connect_parameter)]
        [(connect_parameter)] . . .
)

Provides connection information. For each service, there is one section containing the appropriate connect information.

Keywords and clauses

The following parameters can be used for connect parameters, each enclosed by parentheses:

FAILOVER_MODE = failover_clause

Used for Transparent Application Failover (TAF). The failover_clause can be one or more of the following parameters, each surrounded by parentheses:

BACKUP = backup_net_service_name

Specifies the net service name for the backup connection.

TYPE = SESSION | SELECT | NONE

Specifies what Oracle Net Services does if a failure on the primary instance occurs. SESSION establishes a session with the backup instance. SELECT establishes a session with the backup instance, reopens cursors for any outstanding SELECT statements, and repositions those cursors so that fetching continues from the point the client was at when the primary connection failed. NONE doesn’t failover at all, which allows you to explicitly specify the default behavior.

METHOD = BASIC | PRECONNECT

BASIC establishes the backup connection only when the connection to the primary instance fails. PRECONNECT establishes the connection to the backup when the primary connection is made.

RETRIES = 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 ...

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

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page