Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unanswered: oracle transparent gateway for db2/400

    Hello,
    I have a problem whit the oracle transparent gateway for db2/400 v9.2
    We can connect whit from a unix to as/400 to make a query, but we obtein the ORA-02068, and we dont know where is the problem..
    the gateway is v9.2 and the database is v8i, and the AS/400 is v5r2
    can you help me??
    Here I attach the trace resume:

    nsinherit: connecting:Fri Nov 7 12:32:28 2003 ...
    nsinherit: doing connect handshake:Fri Nov 7 12:33:29 2003 ...
    nsinh_hoff: ADR="(ADDRESS=(PROTOCOL=tcp)(DEV=1)(HOST=nn.nn.nn. nn)(PORT=1521))"
    nsopen: opening transport...
    ntvllt: tcp.validnode_checking not turned on
    nttcnp: Validnode Table IN use; err 0x0
    nsopen: transport is open
    nsc2addr: (ADDRESS=(PROTOCOL=tcp)(DEV=1)(HOST=nn.nn.nn.nn)(P ORT=1521))
    nttgetport: port resolved to 1521
    nttbnd2addr: using host IP address: nn.nn.nn.nn
    nsopen: opening transport...
    nttcnp: Validnode Table IN use; err 0x0
    nttcnp: getting sockname
    nsopen: transport is open
    nsopen: global context check-in (to slot 0) complete
    nsinh_hoff: REDIR="(ADDRESS=(PROTOCOL=tcp)(HOST=nn.nn.nn.nn)(P ORT=5736))"
    nsopen: opening transport...
    nttcnp: Validnode Table IN use; err 0x0
    nttcnp: getting sockname
    nttcnr: waiting to accept a connection.
    nttcnr: getting sockname
    nttcnr: connected on ipaddr nn.nn.nn.nn
    nttvlser: valid node check on incoming node nn.nn.nn.nn
    nttvlser: Accepted Entry: nn.nn.nn.nn
    nttcon: couldn't set TCP_NODELAY on 1; errno=3021,
    nttcon: continuing without it
    nsopen: transport is open
    nam_gbp: Reading parameter "sqlnet.authentication_required" from parameter file
    nam_gbp: Found value "FALSE"
    nam_gic: Counting of items in "sqlnet.authentication_services" parameter
    nam_gic: Parameter not found
    nam_gic: Found 0 items
    nau_gslf: Using default value "all available adapters"
    am_gbp: Reading parameter "SQLNET.FIPS_140" from parameter file
    nam_gbp: Parameter not found
    nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_SERVER" from parameter file
    nam_gnsp: Parameter not found
    naequad: Using default value "ACCEPTED"
    nam_gic: Counting of items in "SQLNET.ENCRYPTION_TYPES_SERVER" parameter
    nam_gic: Parameter not found
    naesno: Using default value "all available algorithms"
    nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_SERVER" from parameter file
    nam_gnsp: Parameter not found
    naequad: Using default value "ACCEPTED"
    nam_gic: Counting of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER" parameter
    nam_gic: Parameter not found
    naesno: Using default value "all available algorithms"
    nsnainit: NS Connection version: 312
    NA services unavailable on both processes - negotiation not needed
    nsopen: global context check-in (to slot 1) complete
    nscon: doing connect handshake:Fri Nov 7 12:33:31 2003 ...
    nscon: recving a packet
    nsprecv: reading from transport...
    nsprecv: 197 bytes from transport
    nsprecvacket dump
    nscon: got NSPTCN packet
    nscon: got 139 bytes connect data
    nscon: discarding connect data (139 bytes)
    nstimarmed: no timer allocated
    nsclose: closing transport
    nsclose: global context check-out (from slot 0) complete:
    nsnadisc: no native services in use - returning
    nsinherit: connected
    nscon: sending NSPTAC packet
    nspsend: 32 bytes to transport
    nspsendacket dump
    nscon: connect handshake is complete
    nsconbrok: NTOBROKEN not supported by transport
    native service(s) is (are) wanted
    NA services unavailable on both processes - negotiation not needed
    nsnainconn: signalling that calling function should not continue
    nsrdr: recving a packet
    nsprecv: reading from transport...
    nsprecvacket dump
    nsrdr: got NSPTDA packet
    nstimarmed: no timer allocated
    nsclose: closing transport

  2. #2
    Join Date
    Mar 2012
    Posts
    1

    Question Otg

    Hi,

    I've got a similar problem. Did anyone get back to you or did you figure it out yourself?

    Simon

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Did anyone get back to you or did you figure it out yourself?
    did you actually read the posting date?
    Do you actually expect a response from a 2003 posting?
    If you expect/desire any meaningful assistance, you need to post all details about your situation.
    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.

Posting Permissions

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