Oracle Net8 Configuration and Troubleshooting

Name

CONNECT_DATA

Synopsis

CONNECT_DATA =
  [(FAILOVER_MODE...)]
  [(GLOBAL_DBNAME = global_database_name)]
  [(HS = OK)]
  [(INSTANCE_NAME = instance_name)]
  [(RDB_DATABASE = rdb_filename)]
  [(SERVER = {DEDICATED | SHARED}]
  [(SERVICE_NAME = database_service)]
  [(SID = system_identifier)]

Identifies the database service or instance that is the target of a description. Oracle8i databases should normally be identified by their service name. Alternatively, you can specify a SID in order to connect to a specific instance.

Parameters

global_database_name

Identifies an Oracle Rdb database. This parameter should only be used when connecting to an Oracle Rdb database.

HS = OK

Tells Net8 that you are connecting to a service that is not an Oracle or Oracle Rdb database. The HS is an acronym for Heterogeneous Services.

instance_name

Identifies a specific Oracle instance to which you want to connect. This is useful when a service has more than one instance, and you want to connect specifically to one of those instances. An instance name should always be specified in conjunction with a service name.

Tip

An instance name is usually, but not always, identical to the SID. Instance names are set using the INSTANCE_NAME parameter in the instance’s parameter file.

rdb_ filename

Identifies an Oracle Rdb database by its filename. You may include the path and extension as part of the filename.

SERVER

Specifies the type of connection to make to an Oracle database. Valid values are as follows:

DEDICATED

Create a dedicated server connection. ...