Define Oracle Protocol parameters

The Oracle Protocol Agent handles Oracle Transparent Network Substrate (TNS) protocol-based SQL*Net, Net7, and Net8 connections.

CAUTION:
The Oracle Protocol Agent is for cases where TCP port 1521 is used only for negotiating the port number for Oracle database connections, and the port number for the actual connection is assigned dynamically. It must not be used in any other cases.
The Oracle Protocol Agent is meant only for non-SSL connections where the port number is assigned dynamically. If TCP port 1521 is used for the actual database connection, do not use a Service that contains this Protocol element. This can consume excessive resources on the engine and lead to performance problems. Instead, use a Service that matches TCP port 1521 without any Protocol element.

If you plan to use NAT for Oracle connections, you must configure the Oracle listener so that the listener tells the client its original non-NATed IP address. This configuration, and the Protocol Agent itself, is necessary only if the database is located on a different computer than the Oracle listener. The Oracle Protocol Agent does not modify payload data because the database service connections could go through a different route than the listener connection.

For more details about the product and how to configure features, click Help or press F1.

Steps

  1. In the properties of a custom Service you have created, click Select next to the Protocol field and select Oracle.
  2. On the Protocol Parameters tab, set the parameters for the Protocol.
  3. Click OK.