Configure Advanced Connect Data Options

Besides the service name or Oracle System Identifier (SID) of the database, the CONNECT_DATA portion of a connect descriptor can be configured with the following options:

- Instance Name to connect to a specific database instance

- Oracle home of the database to start the database from across the network

- Session Data Unit Size to specify the buffer size

- Dedicated Server to connect a dedicated server process

- Heterogeneous Services to access a non-Oracle system

- Oracle Rdb settings to access an Oracle Rdb database

To configure advanced connection options for a net service name:

1. In the navigator pane, expand Net8 Configuration > Directory > Local or Service Naming.

2. Select a net service name or database service. The right pane displays the current destination service and address list.

3. In the Service Identification box, choose Advanced. The Advanced Service Options dialog box appears.

4. Enter fields or select options as appropriate, and then choose OK.

5. In the right pane, choose Apply.

6. Choose File > Save Network Configuration.