Re: TNS Problem

answering my own question.

apparently the TMPDIR environment variable isn't sufficient in telling IPC where to put the .oracle directory. I had mine set to /tmp.

the linux default is /usr/tmp, but that didn't work either once I created it.

the _solaris_ default is /var/tmp, and that worked fine. so obviously the key to oracle installs is to pretend you are on a different OS than you really are...

now if I can just fix that 12500 error...

-mac

In article <836ts3$3vj$1_at_nnrp1.deja.com>,   z1mac_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 10:22:04 CST