SQL*net v2 under HP/UX 9

From: John Peach <epeas_at_abds7.aberdeen.chevron.com>
Date: 11 Mar 93 10:44:52 GMT
Message-ID: <1993Mar11.104452_at_abds7.aberdeen.chevron.com>

---

HP 9000/877 HP/UX 9.0
Oracle 7.0.12.1.0
SQL*net v2.0.12.1.0

Has anyone managed to get the listener up and running under this soet of configuration? We have the same versions running (reasonably) happily on a SparcServer 10, but on the HP the listener appears to come up, but nothing can connect to it (including the status command issued in the startup).

oracle_abhp1: lsnrctl start oralsn

LSNRCTL for HPUX: Version 2.0.12.1.0 - Developer's Release on 11-MAR-93 10:49:15

Copyright (c) Oracle Corporation 1992. All rights reserved.

Starting /local/vend/oracle/HP_7.0.12/bin/tnslsnr: please wait...

Opened parameter file: /local/vend/oracle/HP_7.0.12/network/admin/listener.ora Opened log file: /local/vend/oracle/HP_7.0.12/network/log/oralsn.log Resolved CONNECT_TIMEOUT_oralsn to: 10
Resolved PRESPAWN_oralsn to: 0
Resolved STARTUP_WAIT_TIME_oralsn to: 0
Resolved TRACE_LEVEL_oralsn to: admin
LISTENING ON: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=abhp1.aberdeen.chevron.com)(PORT=oralsn)))

Failed to contact: (ADDRESS=(PROTOCOL=TCP)(HOST=abhp1.aberdeen.chevron.com)(PORT=oralsn)) TNS-12537: TNS:connection closed

netstat shows that the listener is indeed there....

and the trace file gives a whole series of apparently successful events, followed by:

nsprecv:reading from transport...
nsprecv:165 bytes from transport
nscon:got NSPTCN packet
nscon:discarding connect data (137 bytes) nsinherit:connection inherited
nsinherit:connected
nscon:sending NSPTAC packet
nspsend:24 bytes to transport
nscon:sending 415 bytes connect data
nsdo:415 bytes to NS buffer
nsdofls:sending NSPTDA packet
nspsend:425 bytes to transport
nscon:connect handshake is complete

nsevwait:0 event(s) posted
nsevwait:waiting for transport event...
nsevwait:1 event(s) posted
nsevwait:event is NSVCALL, on 0

tnslsnr:Event occured at 11-MAR-93 10:49:17

nsopen:opening transport...
nttcnr:waiting to accept a connection.
nsopen:transport is open
nsopen:global context check-in (to slot 2) complete

nscon:doing connect handshake...

nsprcvs:transport read error
nserror:nsres: id=2, op=RECV, ns=TIMEDOUT, ns2=0; nt[0]=505, nt[1]=0, nt[2]=0
nsclose:closing transport
nsclose:global context check-out (from slot 2) complete
tnslsnr:nsanswer error 12535
nsgerr:ERROR at 11-MAR-93 10:49:27 (see log file for more details)
nsgerr:nsanswer failed
nsgerr:  Tns error struct:
nsgerr:    nr err code: 0
nsgerr:    ns main err code: 12535
nsgerr:    ns secondary err code: 0
nsgerr:    nt main err code: 505

nsgerr: nt secondary err code: 0
nsgerr: nt OS err code: 0
nsevwait:0 event(s) posted
nsevwait:waiting for transport event...

I have reported this to Oracle technical support, but.... Also, needless to say, they have not yet been forthcoming with the SQL*net trilogy...

My guess is that I am missing something at the Op. Sys. / networking level, but what?

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas_at_aberdeen.chevron.com       Phone: +44 224 242637

Received on Thu Mar 11 1993 - 11:44:52 CET