Error starting LISTENER

Error starting LISTENER

Post by David Won » Sun, 31 Dec 1899 09:00:00



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)
**************************************************************************

  david.wong.vcf
< 1K Download
 
 
 

Error starting LISTENER

Post by Sybrand Bakk » Sun, 31 Dec 1899 09:00:00


On Tue, 04 Jan 2000 19:30:19 +0800, David Wong


>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

 
 
 

Error starting LISTENER

Post by Neil » Sun, 31 Dec 1899 09:00:00


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


> 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)
> **************************************************************************

 
 
 

Error starting LISTENER

Post by David Won » Sun, 31 Dec 1899 09:00:00


Thanks guys.  The ownership of the directory was changed to another DBA's id as
opposed to the ORACLE superuser.  Everything works fine now.

  david.wong.vcf
< 1K Download