Hello all..

I have this Listener.log file...where i have a webserver trying to connect to this Unix Box which has database 9.0.1 version.

Now my webserver which uses ODBC connection to connect to ORacle 9.0.1 , after certain period of time loses its connection to the database...

si i want to see when exactly its loosing its connection. I guess i need to look into Listener.log file to see the connection times.

This is what my listener.log looks like...
********************************************************************
Trace level is currently 0
15-JAN-2003 14:51:17 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ora2.dpi.state.nc.us)(
USER=oracle901b))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=LISTENER901)(VERSION=150999040)) * reload * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=149.168.35.22)(PORT=2482))(PRESENTATION=GIOP)(SESSION=RAW ))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=149.168.35.22)(PORT=2481))(PRESENTATION=GIOP)(SESSION=RAW) )
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)HOST=149.168.35.22)(PORT=9090))(PRESENTATION=http://admin)(SESSION=RAW))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=8080))(PRESENTATION=http://admin)(SESSION=RAW))
15-JAN-2003 14:51:17 * service_register * heat901t * 12542
TNS-12542: TNS:address already in use
TNS-12560: TNSrotocol adapter error
TNS-00512: Address already in use
Solaris Error: 125: Address already in use
15-JAN-2003 15:01:19 * service_update * heat901t * 0
15-JAN-2003 15:21:23 * service_update * heat901t * 0
15-JAN-2003 15:31:25 * service_update * heat901t * 0
15-JAN-2003 15:41:27 * service_update * heat901t * 0
15-JAN-2003 15:51:29 * service_update * heat901t * 0
15-JAN-2003 16:01:31 * service_update * heat901t * 0
15-JAN-2003 16:11:33 * service_update * heat901t * 0
15-JAN-2003 16:15:43 * (CONNECT_DATA=(SERVICE_NAME=heat901t)(CID=(PROGRAM=C:\Pro
gram Files\HEAT\CallLog32.exe)(HOST=PEDPIHEAT)(USER=Administrator))) * (ADDRESS=
(PROTOCOL=tcp)(HOST=199.90.6.227)(PORT=2676)) * establish * heat901t * 0
15-JAN-2003 16:20:41 * service_update * heat901t * 0
15-JAN-2003 16:30:43 * service_update * heat901t * 0
15-JAN-2003 16:40:45 * service_update * heat901t * 0
15-JAN-2003 16:59:31 * (CONNECT_DATA=(SERVICE_NAME=heat901t)(CID=(PROGRAM=C:\WIN
NT\System32\dllhost.exe)(HOST=PEDPIHEAT)(USER=IUSR_PEDPIHEAT))) * (ADDRESS=(PROT
OCOL=tcp)(HOST=199.90.6.227)(PORT=3503)) * establish * heat901t * 0
15-JAN-2003 17:00:49 * service_update * heat901t * 0
15-JAN-2003 17:02:02 * (CONNECT_DATA=(SERVICE_NAME=heat901t)(CID=(PROGRAM=C:\Pro
gram Files\HEAT\CallLog32.exe)(HOST=PEDPIHEAT)(USER=Administrator))) * (ADDRESS=
(PROTOCOL=tcp)(HOST=199.90.6.227)(PORT=3550)) * establish * heat901t * 0
15-JAN-2003 17:10:51 * service_update * heat901t * 0
15-JAN-2003 17:20:53 * service_update * heat901t * 0
15-JAN-2003 17:30:55 * service_update * heat901t * 0
15-JAN-2003 17:40:57 * service_update * heat901t * 0
15-JAN-2003 17:50:59 * service_update * heat901t * 0
15-JAN-2003 18:01:01 * service_update * heat901t * 0
15-JAN-2003 18:11:03 * service_update * heat901t * 0
15-JAN-2003 18:21:05 * service_update * heat901t * 0
15-JAN-2003 18:31:07 * service_update * heat901t * 0
15-JAN-2003 18:41:09 * service_update * heat901t * 0
15-JAN-2003 18:51:11 * service_update * heat901t * 0
15-JAN-2003 19:01:13 * service_update * heat901t * 0
15-JAN-2003 19:15:34 * service_update * heat901t * 0
15-JAN-2003 19:25:36 * service_update * heat901t * 0
bash-2.05$
****************************************************




Can we make anything out of Listener.log file ?.....I mean how do we read and understand Listener.log file ?...

Thanks and any help is appreciated.

Ron