Skip Headers
Oracle® Transparent Gateway for DRDA Installation and User's Guide
10g Release 2 (10.2) for UNIX

Part Number B16217-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

B Sample Files

This appendix contains a sample Gateway Initialization files and tnsnames.ora and listener.ora files of Oracle Net.

This appendix contains the following sections:

Sample Gateway Initialization File

The following Gateway Initialization File (initdrdahoa1.ora) needs customization. For information on customizing this file, refer to "Configuring the Host" in Chapter 11, "Configuring the Gateway". Also, refer to Appendix C.

#
# HS specific parameters
#
FDS_CLASS=TG4DRDA_DB2MVS
#TRACE_LEVEL=255
#LOG_DESTINATION=DB2.log
#ORACLE_DRDA_TCTL=debug.tctl
HS_COMMIT_POINT_STRENGTH=255
HS_NLS_DATE_FORMAT=YYYY-MM-DD
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
HS_RPC_FETCH_REBLOCKING=off
HS_RPC_FETCH_SIZE=32767
HS_FDS_FETCH_ROWS=20
#
# DRDA specific parameters
#
DRDA_CONNECT_PARM=DRDACON1
DRDA_REMOTE_DB_NAME=DB2V7R1
DRDA_PACKAGE_COLLID=ORACLE
DRDA_PACKAGE_NAME=G2DRSQL
DRDA_PACKAGE_CONSTOKEN=A92617CB3FE54701
DRDA_RECOVERY_USERID=ORADRDA 
DRDA_RECOVERY_PASSWORD=ORADRDA
DRDA_ISOLATION_LEVEL=CS
#DRDA_PACKAGE_OWNER=ORADRDA
#DRDA_DISABLE_CALL=TRUE  

Sample Oracle Net tnsnames.ora File

For information on modifying your tnsnames.ora file for the gateway, refer to the instructions for "Configuring Oracle Net".

ipc-ora=(DESCRIPTION=
             (ADDRESS=
                 (PROTOCOL=IPC)
                 (KEY=ORAIPC)
 
             )
             (CONNECT_DATA=(SID=ORA102))

          )
   ipc-gtw=(DESCRIPTION=
              (ADDRESS=
                  (PROTOCOL=IPC)
                  (KEY=ORAIPC)

               )
              (CONNECT_DATA=(SID=drdahoa1))
              (HS=)
          )

Sample Oracle Net listener.ora File

For information on modifying your listener.ora file for the gateway, refer to the instructions for "Configuring Oracle Net".

#
# Sample listener.ora file for the Transparent gateway for IBM DRDA
# Version Date: Jan-01-2002
# Filename: Listener.ora
# 
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS= 
        (PROTOCOL= IPC)
        (KEY= ORAIPC))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC=
      (SID_NAME=drdahoa1)
      (ORACLE_HOME=/oracle/tg4drda/10.2.0)
      (PROGRAM=g4drsrv)
    )
  )

STARTUP_WAIT_TIME_LISTENER = 0
INBOUND_CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF

This sample listener.ora file isolated at the $ORACLE_HOME/network/admin directory. If the listener uses the Oracle Net TCP/IP adapter instead of the IPC adapter, then replace the following lines under the LISTENER keyword:

(ADDRESS=
           (PROTOCOL=IPC)
           (KEY=ORAIPC)
         )
with
        (ADDRESS=
           (PROTOCOL=TCP)
           (HOST=your_IP_node_name)
           (PORT=your_port_number)
        )