Re: Problems getting oracle 8.0.5 to listen on HPUX

"Patrick Mackeown @patmac.demon.co.uk>" <patrick<nospam> wrote in message news:1019918492.10697.0.nnrp-13.c2def390_at_news.demon.co.uk...
> when I run : lsnrctl start LISTENER
> I get the following error
>
>
> LSNRCTL for HPUX: Version 8.0.5.0.0 - Production on 27-APR-02 13:31:06
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Message 1070 not found; No message file for product=NETWORK,
> facility=TNSTNS-12545: Message 12545 not found; No message file for
> product=NETWORK, facility=TNS
> TNS-12560: Message 12560 not found; No message file for product=NETWORK,
> facility=TNS
> TNS-00515: Message 515 not found; No message file for product=NETWORK,
> facility=TNS
> HPUX Error: 2: No such file or directory
>
>
> Troubleshooting:
> [1] uname -a : HP-UX ns3 B.11.00 A 9000/712 2001037593 two-user license
> export ORACLE_HOME=/opt/Oracle
> export ORACLE_SID="ns3"
> export ORACLE_OWNER="oracle"
> /opt/Oracle/network/admin tnsnames.ora listener.ora names.ora sqlnet.ora
>
> [Problem traced] using tusc
> ================ When I stack trace lsnrctl start LISTENER================
> I see the following rejection of my socket connection for the oracle
> listener
> access("/tmp/.oracle/sns3.help-desk.co.uk", F_OK)
> = 0
> connect(4, 0x7f7e6ac4, 94)
> ERR#239 ECONNREFUSED
>
> I've put these in /etc/services
> listener 1521/tcp # oracle listener
> ns3 1530/tcp # oracle listener
> sns3 1530/tcp # oracle listener
>
> I think the last one's stupid, because I think sns3.help-desk.co.uk just
> means ns3 socket, but I wasn't
> sure so I created it anyway.
>
> Anyway, none of them work. and the /opt/Oracle/dbs/create/sqlnet.log keeps
> repeating
> Fatal NI connect error 12545, connecting to:
>

(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/opt/Oracle/bin/oracle)(ARGV0=o
> raclens3)(ARGS='(DESCRIPTION=(LOCAL=YES
> )(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST
=n
> s3)(USER=root))))
>
> VERSION INFORMATION:
> TNS for HPUX: Version 8.0.5.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for HPUX: Version 8.0.5.0.0 -
> Production
> Time: 29-JUL-00 16:25:33
> Tracing not turned on.
> Tns error struct:
> nr err code: 12206
> TNS-12206: Message 12206 not found; No message file for
product=NETWORK,
> facility=TNS
> ns main err code: 12545
> TNS-12545: Message 12545 not found; No message file for
product=NETWORK,
> facility=TNS
> ns secondary err code: 12560
> nt main err code: 515
> TNS-00515: Message 515 not found; No message file for product=NETWORK,
> facility=TNS
> nt secondary err code: 2
> nt OS err code: 0
>
>
>

Please post your listener.ora. It looks like it is wrong. Also you should check your evironment variables against the installation manual. You are missing at least one (for which I, right now, don't remember the exact name)

Hth Received on Sat Apr 27 2002 - 10:16:44 CDT