When DirectConnect for Oracle is installed for the first time, a configuration file for DirectConnect for Oracle is automatically created for it. The configuration file, a plain text file which contains definitions for DirectConnect, is located in $SYBASE/$SYBASE_DCO/install for UNIX, or %SYBASE%\%$SYBASE_DCO%\install for Windows.
The configuration file must have the same name as the DirectConnect 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 DirectConnect 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 following lists the contents of the DirectConnect for Oracle configuration file
Contains all of the configuration information for a particular server.
An instance of a DirectConnect for Oracle 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 DirectConnect for Oracle to have different attributes or targets.
A single configuration file for an instance of DirectConnect for Oracle defines one or more services.
One of the service names must be the same as the server name you selected. All global properties 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.
You can modify the configuration file by using DirectConnect Manager or by using sp_configure.
