TNS Problem

From: <z1mac_at_my-deja.com>
Date: Wed, 15 Dec 1999 02:19:51 GMT
Message-ID: <836ts3$3vj$1@nnrp1.deja.com>

On oracle 8.0.5 on Linux I get:

LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 14-DEC-99 11:22:35

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Starting /usr/oracle/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 8.0.5.0.0 - Production System parameter file is /usr/oracle/network/admin/listener.ora Log messages written to /usr/oracle/network/log/listener.log Trace information written to /usr/oracle/network/trace/listener.trc Listening on:
(ADDRESS=(PROTOCOL=tcp)(DEV=9)(HOST=204.140.165.91)(PORT=1521))
Attempted to listen on:
(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory

my listener.ora looks like:

LISTENER =

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

  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (ORACLE_HOME= /usr/oracle)
      (SID_NAME = ORCL)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = USER tho I've tried some different versions of that file, including the default ;).

my environment seems correct.

ORACLE_HOME, TNS_ADMIN, and ORACLE_BASE are all set. I'm trying to run it as oracle.

the perms on my tnslsnr

-rwsr-x--- 1 root dba 3636562 Dec 14 09:28 bin/tnslsnr

though I've also tried it w/ the file owned by "oracle" without suid.

the various trace/log files exists and are accessible.

I'm open to suggestions...

thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 14 1999 - 20:19:51 CST