Besides the service name or Oracle System Identifier (SID) of the database, you can optionally configure the CONNECT_DATA section of a connect descriptor 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:
In the navigator pane, expand Oracle Net Configuration > Directory > Local or Service Naming.
Select a net service name or database service. The right pane displays the current destination service and address list.
In the Service Identification box, choose Advanced. The Advanced Service Options dialog box appears.
Enter fields or select options as appropriate, and then choose OK.
In the right pane, choose Apply.
If you are making these changes to the Local folder, choose File > Save Network Configuration.
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.