Oracle9.2.0.4 through transparent gateway visit DB2? Ora92 installed in the machine (Sid=ora92) ibm DB2 UDB (Sample database name), Oracle transparent gateway to connect DB2, I would set up a transparent gateway to the DB2 database. I do not know why the data link can be established, but not to visit the Table Listener.ora ====================================== # LISTENER.ORA Network Configuration File : D:\oracle\ora92\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = yagoo-wzhq) (PORT = 1521))   ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ora92) (ORACLE_HOME = d:\oracle\ora92) (SID_NAME = ora92)     ) (SID_DESC = (SID_NAME=Sample) (ORACLE_HOME=D:\oracle\ora92) (PROGRAM=tg4drda)       )   ) Tnsnames.ora ========================================== # TNSNAMES.ORA Network Configuration File : D:\oracle\ora92\network\admin\tnsnames.ora # Generated by Oracle configuration tools. TPSSC = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.0.0.22) (PORT = 1521))     ) (CONNECT_DATA = (SERVICE_NAME = nivos)     )   ) ORA92 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = yagoo-wzhq) (PORT = 1521))     ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora92)     )   ) JTXM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.0.0.136) (PORT = 1521))     ) (CONNECT_DATA = (SERVICE_NAME = ORA92)     )   ) Sample = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.0.0.136) (PORT = 1521))     ) (CONNECT_DATA = (SERVICE_NAME = Sample)     ) (HS = OK)       ) Initsample.ora ============================================== ############################################################################ #                                                                          # SAMPLE init.ora file for DB2/UDB # # #                                                                          # ############################################################################ # Trace Parameters # Setting up the gateway in trace mode will have adverse effects on performance. # TRACE_LEVEL : Default : 0 # 0 for no tracing, 255 for full tracing. #TRACE_LEVEL=255 # LOG_DESTINATION $ORACLE_HOME/tg4drda/log/gatewaysid_pid.log : Default : # $ORACLE_HOME/tg4drda/log. If this # Destination is correct, enter the trace file desired. If this destination is # Not correct, enter the entire path name and file name. #LOG_DESTINATION=DB2UDB.log # ORACLE_DRDA_TCTL : Default : none # Default destination is $ORACLE_HOME/tg4drda/admin. If this # Destination is correct, enter the file name Killing desired. If this # Destination is not correct, enter the entire path name and Debug file name. # Sample is located in $ORACLE_HOME/tg4drda/admin/debug.tctl #ORACLE_DRDA_TCTL=debug.tctl # ORACLE_DRDA_TRACE value specified by LOG_DESTINATION : Default : Parameter # log is used to specify a different patch for DRDA internal tracing. #ORACLE_DRDA_TRACE=/oracle/tg4drda/mylog/mydrda.log # Hetergeneous Services Parameters # Refer to Oracle9i Hetergeneous Connectivity Administrator 's Guide for more # Detailed information # HS_COMMIT_POINT_STRENGTH : Default : 0 # Parameter is important only if the system can participate in two- non-Oracle # Phase commit. HS_COMMIT_POINT_STRENGTH=255 # HS_NLS_DATE_FORMAT=YYYY-MM-DD : Default : Determined by HS_LANGUAGE HS_NLS_DATE_FORMAT=YYYY-MM-DD Specific System # HS_LANGUAGE : Default : HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1 # HS_RPC_FETCH_REBLOCKING ON : Default : HS # Controls whether attempts to optimize the performance of data transfer. HS_RPC_FETCH_REBLOCKING=off HS_RPC_FETCH_SIZE # 4000 : Default : HS_RPC_FETCH_SIZE=32767 HS_FDS_FETCH_ROWS # 20 : Default : HS_FDS_FETCH_ROWS=20 # HS_DB_DOMAIN WORLD : Default : HS_DB_NAME # HO : Default : # HS_DB_DOMAIN is required if you use the Oracle Names Server. HS_DB_NAME and # HS_DB_DOMAIN define the global name of the combined system and non-ORACLE # They must form a unique address. #HS_DB_DOMAIN=WORLD HS_DB_NAME=SAMPLE # The following parameters are specifically for the # Transparent Gateway for IBM DRDA. # DRDA gateway parameters to access DB2 (D51A instance) # Note : Valid DB2/UDB userid/pw required in database link. # DRDA_CONNECT_PARM : Default : DRDACON1:446 for TCP. Default : DRDACON1 for SNA # System dependent must be customized # TCP Port Number hostname.network:TCP format : # DB2UDB.us.oracle.com:2019 TCP example : # SNA format sideinfo_name from Local SNA configuration : # DB2LU SNA example : DRDA_CONNECT_PARM=yagoo-wzhq:50000 # DRDA_REMOTE_DB_NAME : Default : DB2V2R3, the system must be customized # Name of DB2 instance on UNIX. DRDA_REMOTE_DB_NAME=SAMPLE # DRDA_PACKAGE_COLLID : Default : Oracle, the system must be customized # Id Specifies the collection defined on non-Oracle database system. # On DB2 id : Mr. GRANT TO CREATE IN COLLECTION ORACLE DRDA_PACKAGE_COLLID=ORACLE # DRDA_PACKAGE_NAME G2DRSQL : Default : Parameter # 1-18 can be any distinctive character string. DRDA_PACKAGE_NAME=G2DRSQL #DRDA_PACKAGE_CONSTOKEN : Default : none. Do not change value. DRDA_PACKAGE_CONSTOKEN=A929B170D366FB00 # DRDA_RECOVERY_USERID : Default : ORARECOV, must be a valid UNIX userid. # The recovery if a user connects to the IBM database distributed transaction # Is in doubt. DRDA_RECOVERY_USERID=ORADRDA # DRDA_RECOVERY_PASSWORD : Default : none, must be a valid UNIX password. # The recovery if a user connects to the IBM database distributed transaction # Is in doubt. DRDA_RECOVERY_PASSWORD=ORADRDA CS : Default : # DRDA_ISOLATION_LEVEL # Possible Values : Based on CHG Change (Default for based on DB2/400) # CS Cursor Stability (default for DB2/UDB, and DB2/OS390 # DB2/VM Repeatable Read RR # # Be careful changing the DRDA_ISOLATION_LEVEL. It will effect ALL DB2 users! DRDA_ISOLATION_LEVEL=CS # DRDA_PACKAGE_OWNER : Default : none, must be a valid UNIX userid # This parameter allows you to assign the package to be someone other owner # Than the userid connected when the BIND package program (gtw$_bind_pkg) # Is run. THIS ALSO OWN THE USER Usage ORACLE2PC table. See the Installation # Guide for more information. It is currently commented out. # #DRDA_PACKAGE_OWNER=ORADRDA # DRDA_DISABLE_CALL : Default : True # This parameter is used to disable Stored Procedure support in the gateway # Servers which the gateway for those DRDA does not currently support calling # Stored Procedures. DRDA_DISABLE_CALL=TRUE # DRDA_CAPABILITY : Default : none # Parameter determines which functions will be treated natively mapped Oracle # With no pre/post processing. #DRDA_CAPABILITY={FUNCTION/{ON|OFF}} That. . . # DRDA_CODEPAGE_MAP $ORACLE_HOME/tg4drda/admin/codepage.map : Default : Parameter # codepage map specifies the location of the file. The default search # Location is $ORACLE_HOME/tg4drda/admin. #DRDA_CODEPAGE_MAP=codepage.map # DRDA_CMSRC_CM_IMMEDIATE : Default : FALSE # Parameter sets the SNA session allocation mode. A setting of FALSE will cause # The gatewa to wait for a free session if no free sessions exist. A setting of # True will cause the gateway to fail the allocation immediately if no free # Sessions exist. #DRDA_CMSRC_CM_IMMEDIATE=FALSE # DRDA_DEFAULT_CCSID : Default : None # Parameter specifies the default character set for character set codepage # Conversions when the DRDA server database indicates that a character string # Has a CCSID of 65535. #DRDA_DEFAULT_CCSID= # DRDA_FLUSH_CACHE SESSION : Default : # Parameter specifies when the cursor cache is to be flushed. When parameter is # Set to COMMIT, the cache is flushed whenever a cursor transactio is committed. # When parameter is set to SESSION, the cache is not flushed until the cursor # Session is terminated. #DRDA_FLUSH_CACHE=SESSION DRDA_COMM_BUFLEN : Default : # 32767, the only use for SNA communications Parameter # sends/receives specifies the communications buffer length for SNA. #DRDA_COMM_BUFLEN=32767 # DRDA_DESCRIBE_TABLE : Default : True # Parameters directs the gateway to use the DRDA operation "Table Describe" to # Return the description of tables. #DRDA_DESCRIBE_TABLE=TRUE # DRDA_LOCAL_NODE_NAME AIX_RS6K : Default : # Parameter should not be changed. This name is used internally by the DRDA # Server to identify the local node. #DRDA_LOCAL_NODE_NAME=AIX_RS6K # DRDA_OPTIMIZE_QUERY : Default : True # Parameters turns on or off the distributed query optimizer (DQO) capability. # Parameter only valid on DB2/MVS and DB2/VM. All other servers must set the # Value to FALSE. #DRDA_OPTIMIZE_QUERY=TRUE # DRDA_SECURITY_TYPE : Default : PROGRAM, use only for SNA communications Parameter # specifies the type of SECURITY used for SNA communications. #DRDA_SECURITY_TYPE=PROGRAM DRDA_PACKAGE_SECTIONS # 100 : Default : Parameter # specifies the number of cursors declared at the remote database # When the package is bound. This is the max number of open cursors allowed # At any one time. #DRDA_PACKAGE_SECTIONS=100 # DRDA_READ_ONLY : Default : FALSE Parameter # read-only specifies whether the gateway runs in a transaction mode. # In this mode, the SQL statements that modify data are not allowed. #DRDA_READ_ONLY=FALSE # ORA_MAX_DATE : Default : 4712-12-31 # Parameter value specifies the gateway maximun date. Range of values is any # Valid date less than 4712-12-31 #ORA_MAX_DATE=4712-12-31 Oracle9.2.0.4 through transparent gateway visit DB2? Initsample.ora March 4, then if we can anymore. Sgl server I allocation, do not know the padding [ Closed window ]