Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2012
    Posts
    4

    Unanswered: Oracle Transparent Gateway Problem

    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.18 8.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 ******

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    does a Firewall exist between Oracle & DB2?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2012
    Posts
    4
    Yes but we thought that we had opened all the required ports as we can tnsping the AS400 and the request actually gets as far as generating the trace on the AS400. But I'm open to any suggestion

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >REDIR="(ADDRESS=(PROTOCOL=tcp)(DEV=0)(HOST=10.252 . 188.206)(PORT=17015))"
    DB2 system must be allowed to initiate packet exchange with Oracle on "random" high port;
    as evidenced by line above.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Mar 2012
    Posts
    4
    Thanks! How did we miss this?! I'll make the changes and get back to you

  6. #6
    Join Date
    Mar 2012
    Posts
    4
    Hi, We got the network team to check all the ports between oracle and the AS400 and its wide open so it doesn't look to be a problem with the firewall.

    The other thing that caught my eye on the trace was "error getting tcp.nodelay value" but no one on the iSeries team know what this means.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •