When ECDA Option for Oracle is installed for the first time, a configuration file is automatically created for it. The configuration file is a plain text file is that contains definitions for ECDA Option for Oracle. It is located in <install_dir>/DCO-15_0/install for UNIX, or C:\<install_dir>\DCO-15_0\install for Windows.
The configuration file must have the same name as the ECDA Option for Oracle server name as defined in the interfaces file for UNIX, or the sql.ini file for Windows. For example, if the server name of the ECDA Option for Oracle in the interfaces file is defined as ORACLEDC, the configuration file name will be ORACLEDC.cfg. The name of the configuration file is case sensitive.
The ECDA Option for Oracle configuration file contains:
All of the configuration information for a particular server.
An instance of a ECDA Option for Oracle that can be configured to respond to multiple service names. A service name represents a connection route with a specific target database and a set of attributes defined with service-specific parameters. This allows a single instance of the ECDA Option for Oracle to have different attributes or targets.
A single configuration file for an instance of ECDA Option for Oracle can define one or more services.
One of the service names must be the same as the server name you selected. All global parameters are defined under the server name heading which is also the name of your configuration file.
In the configuration file, lines beginning with “;” are comments and are ignored by the server.
A service name is enclosed in square brackets.