Re: SQL*net v2 under HP/UX 9

In article <1993Mar11.104452_at_abds7.aberdeen.chevron.com>, epeas_at_abds7.aberdeen.chevron.com (John Peach) writes:
|> -------
|>
|> 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
|>
|>

Many thanks to Oracle US technical support for giving me the answer on this one. There is, indeed, a bug in this implementation of SQL*net v2. The fix is to set CONNECT_TIMEOUT_oralsn = 0 in the listener.ora file.

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