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
>
>
>
>
Received on Sun Apr 28 2002 - 06:24:44 CDT
