connect_string

The connect_string parameter defines a connection to the target Oracle database. Each service defines a connect_string.

Oracle provides a way of connecting to a target Oracle database using SQLNET8. It searches for the tnsnames.ora file in the <install_dir>/DCO-15_0/network/admin directory.

For this, you need to have an entry in the tnsnames.ora file describing the instance to which you will connect. In the following form:

DCSERVER.world = 
	(DESCRIPTION =
		(ADDRESS_LIST =
			(ADDRESS = (PROTOCOL=TCP) (HOST = dixville) (PORT 				= 1521))
		(CONNECT_DATA =
			(SERVICE_NAME = DCSERVER.world)
		)
	)

where:

• ORA_HOST is the name of the host running Oracle RDBMS. ORACLE_SRV is the SID of the RDBMS you intend to connect to. It is analogous to the subnetwork name: PORT is the socket number on which the TNS Listener is listening for connection requests.

• ORACLE_SERVER is the alias used to connect to the Oracle RDBMS. The alias name can be any logical name. It is the same as the server name in Sybase terminology. You can have multiple entries for different servers in tnsnames.ora, just as in the Sybase sql_ini file.

  In this example, the connect string required by ECDA Option for Oracle is ORACLE_SERVER.

  This is used when defining the connect_string parameter in the configuration file:

Example 9

connect_string = ORACLE_SERVER

This parameter is dynamic.