Re: Error starting LISTENER

On Tue, 04 Jan 2000 19:30:19 +0800, David Wong <david.wong_at_actfs.com.hk> wrote:

>This is a multi-part message in MIME format.
>--------------655B088BD956F0FB86A50844
>Content-Type: text/plain; charset=big5
>Content-Transfer-Encoding: 7bit
>
>We've been running ORACLE 7.3.4 on Solaris 2.6 without any problems until a
>system reboot today. For some reason our listener cannot be started after a
>system reboot. The same server was tested for Y2K so I'm pretty sure it's not a
>Y2K issue. Without the listener, we can only connect the database directly from
>the server. Any help is greatly appreciated. Thank you.
>
>
>listner.log
>-----------
>
>TNSLSNR for Solaris: Version 2.3.4.0.0 - Production on 04-JAN-00 15:17:14
>
>Copyright (c) Oracle Corporation 1994. All rights reserved.
>
>System parameter file is /var/opt/oracle/listener.ora
>Log messages written to /user/oracle/product/v734/network/log/listener.log
>Trace information written to
>/user/oracle/product/v734/network/trace/listener.trc
>Trace level is currently 0
>
>Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=192.168.1.13)(PORT=1521))
>Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
>TNS-12546: TNS:permission denied
> TNS-12560: TNS:protocol adapter error
> TNS-00516: Permission denied
> Solaris Error: 13: Permission denied
>
>
>extracted listener.trc
>----------------------
>
>connected
>Resolved "CONNECT_TIMEOUT_LISTENER" to: 10
>Resolved "STARTUP_WAIT_TIME_LISTENER" to: 0
>(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=valery)(PORT=1521)
>
>))
>port resolved to 1521
>looking up IP addr for host: valery
>opening transport...
>No PROTOCOL.ORA file is found
>Validnode Table IN use; err 0x0
>getting sockname
>transport is open
>global context check-in (to slot 1) complete
>completing partial addr: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP
>
>)(HOST=valery)(PORT=1521)))Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=14)(HOST=19
>
>2.168.1.13)(PORT=1521))

>(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
>opening transport...
>-<ERROR>- sd=16, op=1, resnt[0]=516, resnt[1]=13, resnt[2]=0
>-<ERROR>- sd=16, op=1, resnt[0]=516, resnt[1]=13, resnt[2]=0
>-<ERROR>- nsres: id=0, op=65, ns=12546, ns2=12560; nt[0]=516, nt[1]=13, nt[2]=0
>-<ERROR>- unable to open transport
>-<ERROR>- Reporting the following error stack:
>TNS-12546: TNS:permission denied
> TNS-12560: TNS:protocol adapter error
> TNS-00516: Permission denied
> Solaris Error: 13: Permission denied

Apparently this is a problem with the IPC driver, implemented through sockets and semaphores. Usually a socket file is created on disk, AFAIK in /var/tmp/oracle. Either the privilege of this directory is incorrect, or the listener tries to overwrite an already existing file (the file name is constituted from the letter s, a #, and the pid of the listener.) You could start with searching for socket files and remove them

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Jan 04 2000 - 05:47:13 CST