Re: Error starting LISTENER

check the permissions on the directory path /var/tmp/.oracle

(note the . is not a typo) make sure you use the -al flags with ls to show the hidden .oracle directory. The listener needs to be able to create a file in this directory.

HTH NeilC

David Wong wrote:
>
> 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
> sending NSPTRF packet
> 12 bytes to transport
> sending 558 bytes connect data
> 558 bytes to NS buffer
> no timer allocated
> 568 bytes to transport
> closing transport
> global context check-out (from slot 0) complete
> no timer allocated
> closing transport
> global context check-out (from slot 1) complete
> Deallocating cxd 0x1b89a0.
>
> listener.ora
> ------------
>
> #########
> #
> # Listener name = LISTENER
> # Created Wed Apr 1 13:56:27 EST 1998
> # by root
> #
> #########
>
> LISTENER=
> (ADDRESS_LIST=
> (ADDRESS=
> (PROTOCOL= TCP)
> (HOST= valery)
> (PORT= 1521)
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = ukdb)
> (ORACLE_HOME = /user/oracle/product/v734)
> )
> )
>
> STARTUP_WAIT_TIME_LISTENER=0
> CONNECT_TIMEOUT_LISTENER=10
> #TRACE_LEVEL_LISTENER=ADMIN
> TRACE_DIRECTORY_LISTENER=/user/oracle/product/v734/network/trace
> TRACE_FILE_LISTENER=LISTENER
> LOG_DIRECTORY_LISTENER=/user/oracle/product/v734/network/log
> LOG_FILE_LISTENER=LISTENER
>
> oratab
> ------
>
> ukdb:/user/oracle/product/v734:Y
>
> /etc/system
> -----------
>
> forceload: sys/semsys
> forceload: sys/shmsys
> *
> set semsys:seminfo_semmap=66
> set semsys:seminfo_semmni=120
> set semsys:seminfo_semmns=1000
> set semsys:seminfo_semmnu=70
> set semsys:seminfo_semmsl=80
> set semsys:seminfo_semopm=10
> set semsys:seminfo_semume=10
> set semsys:seminfo_semusz=96
> set semsys:seminfo_semvmx=32767
> set semsys:seminfo_semaem=16384
> *
> set shmsys:shminfo_shmmax=500000000
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=200
> set shmsys:shminfo_shmseg=120
> #
> set ncsize=5000
> set ufs_ninode=5000
> * System V pseudo terminals
> set pt_cnt =1000
>
> --
>
> **************************************************************************
> This communication is confidential to ACT Financial Systems (Asia Pacific)
> and is intended for use only by the addressee. The views and opinions
> expressed in this email are the senders own and do not represent the
> views and opinions of ACT Financial Systems (Asia Pacific)
> **************************************************************************
Received on Tue Jan 04 2000 - 09:24:45 CST