13.1.3 About the Advanced Connect Data Parameters

Starting with Oracle Database 12c release 2 (12.2), data compression can be set in the sqlnet.ora file. The parameters that set compression are SQLNET.COMPRESSION and SQLNET.COMPRESSION_LEVELS. Setting these parameters in the sqlnet.ora file affects all the connections using the sqlnet.ora file, except for Oracle Data Guard streaming redo and SecureFiles LOBs (Large Objects). The following example shows how to set compression:

SQLNET.COMPRESSION = on
SQLNET.COMPRESSION_LEVELS =(low,high)

The CONNECT_DATA section of a connect descriptor in the tnsnames.ora file defines the destination database service. In the following example, SERVICE_NAME defines a service called sales.us.example.com:

sales.us.example.com=
 (DESCRIPTION=
   (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
   (CONNECT_DATA=
    (SERVICE_NAME=sales.us.example.com))) 

In addition to the service name, you can optionally configure the connect data information with the parameters described in Table 13-3.

Table 13-3 Advanced Connect Data Settings in the tnsnames.ora File

Oracle Enterprise Manager Cloud Control/Oracle Net Manager Option	tnsnames.ora File Parameter	Description
Instance Name	INSTANCE_NAME	The database instance to access. The instance name can be obtained from the INSTANCE_NAME parameter in the initialization parameter file.
Session Data Unit Size	SDU	The transfer rate of data packets being sent across the network. You can specify the session data unit (SDU) size to change the performance characteristics having to do with the packets sent across the network. The SDU size limit is 2 MB.
Use for Heterogeneous Services	HS	If you want an Oracle database server to access a third-party system through Heterogeneous Services, then set this option to on.
Oracle RDB Database	RDB_DATABASE	The file name of the Oracle Rdb database.
Type of Service	TYPE_OF_SERVICE	The type of service to use for the Oracle Rdb database.
Global Database Name	GLOBAL_NAME	Oracle Rdb database identifier.

In the following example, the transfer rate for data packets is set:

sales.us.example.com=
 (DESCRIPTION=
   (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
   (CONNECT_DATA=
    (SERVICE_NAME=sales.us.example.com)
    (SDU=8192))) 

Use Oracle Enterprise Manager Cloud Control or Oracle Net Manager to configure advanced CONNECT_DATA parameters for either a network service name or a database service.

Configuring Advanced Connect Descriptor Parameters Using Oracle Enterprise Manager Cloud Control

The following procedure describes how to configure advanced connect descriptor parameters using Oracle Enterprise Manager Cloud Control:

1. Access the Directory Naming or Local Naming page in Oracle Enterprise Manager Cloud Control, as follows:

   1. Access the Net Services Administration page in Oracle Enterprise Manager Cloud Control.

      See Also:

      "Using Oracle Enterprise Manager Cloud Control to Configure Oracle Net Services"

   2. Select Local Naming or Directory Naming from the Administer list, and then select the Oracle home for the directory server or the location of the local configuration files.

   3. Click Go.

      The Directory Naming or Local Naming pages appear.

2. Select the directory service or network service name.

   • For Local Naming, select a network service from the list, and then click Edit.

   • For Directory Naming, search the network service name in the Simple Search section by selecting the network service or database service from the Results list, and then clicking Edit.

3. Click the Advanced tab.

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

5. Click OK to update the connect data information.

Configuring Advanced Connect Descriptor Parameters Using Oracle Net Manager

The following procedure describes how to configure advanced connect descriptor parameters using Oracle Net Manager:

1. Start Oracle Net Manager.

   See Also:

   "Using Oracle Net Manager to Configure Oracle Net Services"

2. In the navigator pane, select Service Naming from Directory or Local menus.

3. Select either the network service name or a database service.

   The right pane displays the current destination service and address list.

4. In the Service Identification box, click Advanced.

   The Advanced Service Options dialog box appears.

5. Enter fields or select options as appropriate, and then click OK.

6. If you are making these changes to the Local folder, then select Save Network Configuration from the File menu. Changes to the Directory folder are saved automatically.