SQL is going down every 2-3 days .

[Sanjoy Paul]

He everyone ,
SQL is going down every 2-3 days , it can't be start thereafter , only solution is rebooting the machine .

The startup log gives below error when trying to restart :
OMS on LDAS01 $ ty SQLSRV$.LOG;848
0213 12473661 Server Mailbox activated
0213 12473666 DECnet Server activated
0213 12473666 %SQLSRV-F-ERRNET, Network error
0213 12473666 -SQLSRV-F-TCPPORT, Unable to declare SQL Services as TCP port 118
%SQLSRV-F-SHTDWN, Shutting down SQL Services
OMS_MGR job terminated at 13-FEB-2009 12:48:45.14


In the UCX front I can see that there is no file attached to telnet service :



OMS on LDAS01 $ ucx sho ver

Digital TCP/IP Services for OpenVMS Alpha Version V4.2 - ECO 2
on a AlphaServer 2100 4/200 running OpenVMS V6.2-1H3

OMS on LDAS01 $ ucx sho service

Service Port Proto Process Address State

FTP 21 TCP UCX$FTPD 0.0.0.0 Enabled
REXEC 512 TCP UCX$REXECD 0.0.0.0 Enabled
SMTP 25 TCP UCX$SMTP 0.0.0.0 Enabled
TELNET 23 TCP not defined 0.0.0.0 Enabled
OMS on LDAS01 $


Can anyone help us in this regard ?

Thanks ,

Sanjoy

[Volker Halle]

Sanjoy,

check to see, if some process is still bound to port 118

$ UCX SHOW DEV/PORT=118

If a BG device is shown, use $ SHOW DEV/FULL BGn to find out, which process owns this device.

Is there any OPCOM message or any message in any of the SQL server logfiles about the reason, why SQL 'is going down' ?

Do other TCPIP services continue to work ?

Volker.