Operating System - HP-UX
1748266 Members
3533 Online
108760 Solutions
New Discussion

HPUX Oracle RAC TNSListener stops randomly

 
sgreyling
Advisor

HPUX Oracle RAC TNSListener stops randomly

Hi,

Please have a look at this log from /oracle/10.2.0/db_1/network/log


13-FEB-2011 22:24:28 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=vbedi_taf)(CID=(PROGRAM=edi@ecedipr1)(HOST=ecedipr1)(USER=ediswit))(INS
TANCE_NAME=vbedi1)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=59525)) * establish * vbedi_taf * 0
13-FEB-2011 22:24:31 * service_update * vbedi1 * 0
13-FEB-2011 22:24:31 * service_update * vbedi1 * 0
13-FEB-2011 22:24:34 * service_update * vbedi1 * 0
13-FEB-2011 22:24:34 * service_update * vbedi1 * 0
13-FEB-2011 22:24:53 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=vbedi_taf)(CID=(PROGRAM=edi@ecedipr1)(HOST=ecedipr1)(USER=ediswit))(INS
TANCE_NAME=vbedi1)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=59635)) * establish * vbedi_taf * 0
13-FEB-2011 22:24:55 * service_update * vbedi1 * 0
13-FEB-2011 22:24:55 * service_update * vbedi1 * 0
13-FEB-2011 22:24:58 * service_update * vbedi1 * 0
13-FEB-2011 22:24:58 * service_update * vbedi1 * 0
13-FEB-2011 22:25:04 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=vbedi_taf)(CID=(PROGRAM=edi@ecedipr1)(HOST=ecedipr1)(USER=ediswit))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=59671)) * establish * vbedi_taf * 0
13-FEB-2011 22:25:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ecorapr1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_ECORAPR1)(V
ERSION=169870592)) * status * 0
13-FEB-2011 22:25:39 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=vbedi_taf)(CID=(PROGRAM=edi@ecedipr1)(HOST=ecedipr1)(USER=ediswit))(INS
TANCE_NAME=vbedi1)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=59809)) * establish * vbedi_taf * 0
13-FEB-2011 22:25:40 * service_update * vbedi1 * 0
13-FEB-2011 22:25:40 * service_update * vbedi1 * 0
13-FEB-2011 22:25:43 * service_update * vbedi1 * 0
13-FEB-2011 22:25:43 * service_update * vbedi1 * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.201.11)(PORT=1526)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.201.13)(PORT=1526)))
Listener completed notification to CRS on stop
13-FEB-2011 22:26:21 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ecorapr1)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER_ECORAPR1)(VER
SION=169870592)) * stop * 0

TNSLSNR for HPUX: Version 10.2.0.5.0 - Production on 14-FEB-2011 07:32:47

Copyright (c) 1991, 2010, Oracle. All rights reserved.

System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener_ecorapr1.log
Trace information written to /u01/app/oracle/product/10.2.0/db_1/network/trace/listener_ecorapr1.trc
Trace level is currently 0

Started with pid=24906
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.201.11)(PORT=1526)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.201.13)(PORT=1526)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
14-FEB-2011 07:32:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ecorapr1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_ECORAPR1)(V
ERSION=169870592)) * status * 0
14-FEB-2011 07:32:48 * service_register * +ASM1 * 0
14-FEB-2011 07:32:55 * service_register * vbedi2 * 0
14-FEB-2011 07:33:10 * service_register * vbedi1 * 0


At random times the listener just stops working.

HP11.31
/etc/hosts

###############################################
# 10g RAC requirement - DO NOT CHANGE: A Judeel
# NODE 1
192.168.201.11 ecorapr1
192.168.201.13 ecorapr1-vip
172.16.0.10 ecorapr1-priv

# NODE 2
192.168.201.12 ecorapr2
192.168.201.14 ecorapr2-vip
172.16.0.11 ecorapr2-priv
###############################################