Very Computer

>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

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