5 Configuring Your Oracle Network

5.1 Configuring the Oracle Network for the Gateway

The instructions in this section will show you how to configure the network whether your gateway is using 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:

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

• If you are using SNA:

  (SID_DESC=
       (SID_NAME=PGA)
       (ORACLE_HOME= C:\oracle\pga\10.2)
       (PROGRAM=pg4asrv) 
  )
  

  where: C:\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= C:\oracle\pga\10.2)
       (PROGRAM=pg4t4ic)
  )
  

  where: C:\oracle\pga\10.2 is your gateway Oracle home, and PGA is the gateway SID name.

2. 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: Under the following circumstances: If your gateway and Oracle Integrating Server are not on the same system, or, 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, then you must define the Oracle Integrating Server to PGAU by adding a service name to tnsnames.ora on the system where your gateway resides. 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 resides; and ora_server is the SID of the Oracle Integrating Server.

   
   

   Make sure to start your defined listeners. Refer to the Oracle Net Services Administrator's Guide for more information about configuring the network.

   To see a sample listener.ora file refer to "Sample listener.ora File for a Gateway Using SNA" and "Sample tnsnames.ora File for a Gateway Using SNA" in Appendix A (if your communication protocol is SNA).

   To see a sample listener.ora file refer to"Sample listener.ora File for a Gateway Using TCP/IP" and "Sample tnsnames.ora File for a Gateway Using TCP/IP" in Appendix B (if your communication protocol is TCP/IP).

Proceed with Configuring Your Communication Package for the Gateway

• If your communication protocol is SNA, you must now configure the SNA Server profiles for APPC connections.

  Proceed to Chapter 6, " Configuring the SNA Communication Package on Windows"

• If your communication protocol is TCP/IP, proceed to Chapter 7, "Configuring the TCP/IP Communications Package for IMS Connect".