5 Configuring Your Oracle Network

The instructions in this section describe how to configure the network whether your gateway is using the SNA or TCP/IP communication protocol.

The gateway must be defined to the Oracle Net 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\12.2)
           (PROGRAM=pg4asrv) 
      )

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

      where: C:\oracle\pga\12.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 database is located. The service name is specified in the USING parameter of the database link defined for accessing the gateway from the Oracle database . 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 database 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 database are not on the same system,

    • or, if the gateway and the Oracle database are on the same system but the Oracle database Listener is different than the gateway listener,

    then you must define the Oracle database 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 database listener.ora for the TCP protocol;

    • ora_srv is the TCP/IP host name of the system where the Oracle database resides; and

    • ora_server is the SID of the Oracle database .

    Make sure to start your defined listeners. Refer to the Oracle Database 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 Gateway Initialization Parameters for SNA Protocol (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 Gateway Initialization Parameters for TCP/IP Communication Protocol (if your communication protocol is TCP/IP).

Example 5-1 Proceed with Configuring Your Communication Package for the Gateway