5 Configuring Your Oracle Network

This chapter describes how to configure the network.

5.1 Configuring the Oracle Network for the Gateway

The instructions in this section will show you how to configure the network if the gateway is utilizing the SNA or TCP/IP communication protocol.

The gateway must be defined to the TNS listener, and a service name must be defined for accessing the gateway. To do this, perform the following steps:

Add an entry for the gateway to the listener.ora file:

If you are using SNA:
```
(SID_DESC=
     (SID_NAME=PGA)
     (ORACLE_HOME=/oracle/pga/10.2)
     (PROGRAM=pg4asrv) 
)
```
where: /oracle/pga/10.2 is your gateway Oracle home and PGA is the gateway SID name.
Or, if you are using TCP/IP:
```
(SID_DESC=
     (SID_NAME=PGA)
     (ORACLE_HOME=/oracle/pga/10.2)
     (PROGRAM=pg4t4ic)
)
```
where: /oracle/pga/10.2 is the gateway Oracle home and PGA is the gateway SID name.

Add a service name for the gateway to the tnsnames.ora file on the system where your Oracle Integrating Server is located. The service name is specified in the USING parameter of the database link defined for accessing the gateway from the Oracle Integrating Server. For example, if you are using the IPC protocol adapter and your gateway sid is PGA, then add the following entry to tnsnames.ora:

pgaipc= 
        (DESCRIPTION = 
                (ADDRESS = (PROTOCOL = ipc) (KEY=key))
                (CONNECT_DATA = (SID=PGA)) 
                (HS=) 
        )

In this example, key is the IPC key defined in the listener.ora file for the IPC protocol. You can use the IPC protocol only if the Oracle Integrating Server and the gateway are on the same system.

If you are using the TCP/IP protocol adapter, and if your gateway sid is PGA, then add the following entry to tnsnames.ora:

pgatcp= 
        (DESCRIPTION = 
              (ADDRESS = (PROTOCOL= TCP)(Host= gateway)(Port= port)) 
                (CONNECT_DATA = (SID=PGA)) 
                (HS=) 
        )

In this example, port is the TCP port defined in the listener.ora file for the TCP protocol, and gateway is the TCP/IP host name of the system where the gateway is located.

Note:

For the following cases:

If your gateway and Oracle Integrating Server are not on the same system,
If the gateway and the Oracle Integrating Server are on the same system but the Oracle Integrating Server Listener is different than the gateway listener

You must define the Oracle Integrating Server to PGAU by adding a service name to tnsnames.ora on the system where your gateway is located. For example:

ora_server =
   (DESCRIPTION=
     (ADDRESS = 
       (PROTOCOL= TCP) 
       (PORT= port) 
       (HOST= ora_srv)
      )
      (CONNECT_DATA= (SID= ora_server))
   )

In this example:

port is the TCP port defined in the Oracle Integrating Server listener.ora for the TCP protocol;
ora_srv is the TCP/IP host name of the system where the Oracle Integrating Server is located; and
ora_server is the SID of the Oracle Integrating Server.

Ensure that you start the defined listener(s).