Listener: Linux Error: 111

From: Ekkard Gerlach <SPS_Gerlach_at_online.de>
Date: Wed, 19 Jan 2000 23:57:45 +0100
Message-ID: <38864169.BD06A66E@online.de>

Hello,

I´ve installed Oracle 8.0.5 on Linux (Suse 6.1)

I get the following error while
starting listener:

LSNRCTL> start
Starting /opt/oracle/product/8.0.5/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 8.0.5.0.0 - Production System parameter file is
/opt/oracle/product/8.0.5/network/admin/listener.ora
Log messages written to
/opt/oracle/product/8.0.5/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=ORCL)) Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY)) Listening on:
(ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=192.168.0.48)(PORT=1521))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ORCL)) TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error    TNS-00511: No listener
    Linux Error: 111: Connection refused Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY)) TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error    TNS-00511: No listener
    Linux Error: 111: Connection refused Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=rex)(Port=1521)) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.0.5.0.0 -
Production
Start Date                19-JAN-00 22:25:22
Uptime                    0 days 0 hr. 0 min. 7 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/opt/oracle/product/8.0.5/network/admin/listener.ora
Listener Log File
/opt/oracle/product/8.0.5/network/log/listener.log
Services Summary...

  ORCL          has 1 service handler(s)
  extproc               has 1 service handler(s)

The command completed successfully
LSNRCTL> any idea ?
tia
Ekkard

P.S.

product/8.0.5/network/admin/listener.ora

#
# Installation Generated Net8 Configuration
# Version Date: Jun-17-97
# Filename: Listener.ora
#

LISTENER =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= ORCL))
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
        (ADDRESS= (PROTOCOL= TCP)(Host= rex)(Port= 1521))

  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME= rex.my_DB)
      (ORACLE_HOME= /opt/oracle/product/8.0.5)
      (SID_NAME = ORCL)

)
(SID_DESC =

      (SID_NAME = extproc)
      (ORACLE_HOME = /opt/oracle/product/8.0.5)
      (PROGRAM = extproc)

)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
/product/8.0.5/network/log/listener.log:

TNSLSNR for Linux: Version 8.0.5.0.0 - Production on 19-JAN-00 22:25:22

System parameter file is
/opt/oracle/product/8.0.5/network/admin/listener.ora
Log messages written to
/opt/oracle/product/8.0.5/network/log/listener.log

Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=ORCL))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY))
Listening on:

(ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=192.168.0.48)(PORT=1521)) TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 19-JAN-00 22:25:29 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=rex)(USER=oracle))(COMMAND=s$

rex:~ # fuser -v -u -n tcp 1521

                     USER        PID ACCESS COMMAND
1521/tcp             root       3529 f....  tnslsnr

sqlnet.ora

is not created by installation process. Do I need it ? I´ve found sqlnet.ora
in examples-directory. Received on Wed Jan 19 2000 - 16:57:45 CST