Home » RDBMS Server » Networking and Gateways » Oracle Transparent Gateway fails on AS400 (11gR1 )
Oracle Transparent Gateway fails on AS400 [message #549126] Wed, 28 March 2012 04:41
srsilvie
Messages: 1
Registered: March 2012
Location: United Kingdom
Junior Member
Hi,

We have setup OTG on the test partition of our AS400 to work with our test 11gR1 implementation. Although everything has been setup as production (and the documentation) we still can't get the gateway to work. Queries sent to DB2 hang and the only indication that it has failed comes from the AS400 side (see log).

Any help gratefully accepted

Simon

connecting:Fri Mar 16 14:00:28 2012 ...
doing connect handshake:Fri Mar 16 14:00:39 2012 ...
ADR="(ADDRESS=(PROTOCOL=tcp)(DEV=1)(HOST=10.252.188.206)(PORT=1721))"
bufl=256
(ADDRESS=(PROTOCOL=tcp)(DEV=1)(HOST=10.252.188.206)(PORT=1721))
port resolved to 1721
using host IP address: 10.252.188.206
opening transport...
Validnode Table IN use; err 0x0
transport is open
(ADDRESS=(PROTOCOL=tcp)(DEV=1)(HOST=10.252.188.206)(PORT=1721))
port resolved to 1721
using host IP address: 10.252.188.206
opening transport...
Validnode Table IN use; err 0x0
getting sockname
transport is open
global context check-in (to slot 0) complete
hoff=12587
REDIR="(ADDRESS=(PROTOCOL=tcp)(DEV=0)(HOST=10.252.188.206)(PORT=17015))"
opening transport...
Validnode Table IN use; err 0x0
getting sockname
waiting to accept a connection.
valid node check on incoming node 10.252.188.207
Accepted Entry: 10.252.188.207
error getting tcp.nodelay value
transport is open
global context check-in (to slot 1) complete
doing connect handshake:Fri Mar 16 14:00:39 2012 ...
got NSPTCN packet
discarding connect data (159 bytes)
no timer allocated
closing transport
global context check-out (from slot 0) complete:Fri Mar 16 14:00:39 2012
sending NSPTAC packet
connect handshake is complete
nsctxinf^0]=0x61, ^1]=0x0
NTOBROKEN not supported by transport
158 bytes from NS buffer
****** END OF DATA ******


Previous Topic: ORA-12154 and ORA-12504:
Next Topic: TRACE_LEVEL_SERVER=off
Goto Forum:
  


Current Time: Tue Oct 21 10:13:35 CDT 2014

Total time taken to generate the page: 0.09851 seconds