Skip Headers

Oracle® Transparent Gateway for IBM DRDA Installation and User's Guide
Release 9.2.0.1.0 for MS Windows
Part Number A96195-01
Go To Table Of Contents
Contents
Go To Index
Index

Previous Next

B
Sample Files

This appendix contains sample files of gateway initialization and Oracle Net tnsnames.ora and listener.ora files.

Sample Gateway Initialization File

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

# 
# Oracle Transparent Gateway for IBM DRDA Gateway Initialization File
#
#TRACE_LEVEL=255
#LOG_DESTINATION=DB2.log
#ORACLE_DRDA_TCTL=debug.tctl
#
# HS Specific Parameters
#
#FDS_CLASS=TG4DRDA_DB2MVS
#
#HS_COMMIT_POINT_STRENGTH=255
#HS_NLS_DATE_FORMAT=YYYY-MM-DD
#HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
#HS_RPC_FETCH_SIZE=32767
#HS_FDS_FETCH_ROWS=20
#
# DRDA Specific Parameters
#
DRDA_CONNECT_PARM=DRDACON1
DRDA_REMOTE_DB_NAME=DB2V2R3
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 tailoring your tnsnames.ora file for the gateway, refer to the instructions for "Configuring Oracle Net".

ipc-ora9=(DESCRIPTION=
             (ADDRESS=
                 (PROTOCOL=IPC)
                 (KEY=ORCL)
             )
             (CONNECT_DATA=(SID=ORA920))
            (HS=)
				         )
ipc-gw=(DESCRIPTION=
           (ADDRESS=
               (PROTOCOL=IPC)
               (KEY=ORCL)
           )
           (CONNECT_DATA=(SID=drdahoa1))
				           (HS=)
							         

				        )  

Sample Oracle Net listener.ora File

For information on tailoring your listener.ora file for the gateway, refer to the instructions in "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= ORCL))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC=
      (SID_NAME=drdahoa1)
      (ORACLE_HOME=C:\Oracle\GTWHome)
      (PROGRAM=g4drsrv)
    )
	  )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF

This sample listener.ora resides in the %ORACLE_HOME%\network\admin directory.  If your listener uses the Oracle Net TCP/IP adapter instead of the IPC adapter, then replace these lines under the LISTENER keyword:

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


Previous Next
Oracle Logo
Copyright © 2001, 2002 Oracle Corporation

All rights reserved
Go To Table Of Contents
Contents
Go To Index
Index