Error starting LISTENER

From: David Wong <david.wong_at_actfs.com.hk>
Date: Tue, 04 Jan 2000 19:30:19 +0800
Message-ID: <3871D9CA.9C3C2D4F@actfs.com.hk>

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

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 - 05:30:19 CST