This appendix contains a sample Gateway Initialization files and tnsnames.ora
and listener.ora
files of Oracle Net.
This appendix contains the following sections:
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
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=) )
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) )