Re: Problems getting oracle 8.0.5 to listen on HPUX

"Patrick Mackeown" <patrick_nospam__at_patmac.demon.co.uk> wrote in message news:1019992795.753.0.nnrp-13.c2def390_at_news.demon.co.uk...
> I have symlinked /opt/Oracle to /oracle/8.0.5
>
> ################
> # Filename......: listener.ora
> # Name..........: ns3.help-desk.co.uk
> # Date..........: 02-DEC-99 09:07:29
> ################
> SQLNET.AUTHENTICATION_SERVICES = (NONE)
>
> USE_PLUG_AND_PLAY_LISTENER = OFF
> USE_CKPFILE_LISTENER = OFF
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY= ns3.help-desk.co.uk)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY= ns3)
> )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> LOG_DIRECTORY_LISTENER = /oracle/network/log
> TRACE_LEVEL_LISTENER = OFF
> TRACE_DIRECTORY_LISTENER = /oracle/network/trace
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
>
> (GLOBAL_DBNAME = ns3.help-desk.co.uk)
> (SID_NAME = ns3)
> (ORACLE_HOME = /oracle/8.0.5)
> (PRESPAWN_MAX = 10)
> )
> (SID_DESC =
>
> (GLOBAL_DBNAME = ns3dev.help-desk.co.uk)
> (SID_NAME = ns3dev)
> (ORACLE_HOME = /oracle/8.0.5)
> (PRESPAWN_MAX = 10)
> )
> )
>
> Sybrand Bakker wrote in message ...
> >
> >"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=)(HOS
> T
> >=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
> >
> >
> >
> >
>
>

I have symlinked /opt/Oracle to /oracle/8.0.5

Which is, sorry to say so, almost invariably a *bad* idea

You have 2 adresses for the IPC protocol, and the first has a hostname in it.
Delete the first one and/or change it to the TCP protocol (protocol=tcp)(host=ns3.help-desk.co.uk)(port=1521)

In the current situation you will be able to connect to the database *on the server* only. You also need to setup a tnsnames.ora if you didn't already do so.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address