This appendix contains sample files of gateway initialization and Oracle Net tnsnames.ora and listener.ora files.
The following sample gateway initialization file (inithoa1.ora) needs customization. For information on customizing this file, refer to "Configuring the Host" in Chapter 10, "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
For information on tailoring the tnsnames.ora file for the gateway, refer to the instructions for "Configuring Oracle Net".
ipc-ora=(DESCRIPTION= (ADDRESS= (PROTOCOL=IPC) (KEY=ORCL) ) (CONNECT_DATA=(SID=ORA102)) (HS=) ) ipc-gw=(DESCRIPTION= (ADDRESS= (PROTOCOL=IPC) (KEY=ORCL) ) (CONNECT_DATA=(SID=drdahoa1)) (HS=) )
For information on tailoring the 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 INBOUND_CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF
This sample listener.ora file resides in the ORACLE_HOME\network\admin directory. If the 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) )