Hello guys,
I hav an application that connects to the Oracle Database, this application have a really extrange behavior, it's reporting several opened ports in the listener.log file, here are an example:
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 18-FEB-2009 07:30:02
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is e:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Log messages written to e:\oracle\product\10.2.0\db_1\network\log\listener.log
Trace information written to e:\oracle\product\10.2.0\db_1\network\trace\listener.trc
Trace level is currently 0
Started with pid=5084
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE_HOST)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 18-FEB-2009 07:30:07
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is e:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Log messages written to e:\oracle\product\10.2.0\db_1\network\log\listener.log
Trace information written to e:\oracle\product\10.2.0\db_1\network\trace\listener.trc
Trace level is currently 0
Started with pid=7056
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE_HOST)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
18-FEB-2009 08:33:08 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2303)) * establish * PRISM * 0
18-FEB-2009 08:33:09 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2305)) * establish * PRISM * 0
18-FEB-2009 08:33:09 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2310)) * establish * PRISM * 0
18-FEB-2009 08:33:09 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2311)) * establish * PRISM * 0
18-FEB-2009 08:33:10 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2312)) * establish * PRISM * 0
18-FEB-2009 08:33:10 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2313)) * establish * PRISM * 0
18-FEB-2009 08:33:10 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2314)) * establish * PRISM * 0
18-FEB-2009 08:33:10 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2315)) * establish * PRISM * 0
18-FEB-2009 08:33:10 * service_update * prism * 0
18-FEB-2009 08:33:19 * service_update * prism * 0
18-FEB-2009 08:33:23 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2316)) * establish * PRISM * 0
18-FEB-2009 08:33:23 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2317)) * establish * PRISM * 0
18-FEB-2009 08:33:23 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2318)) * establish * PRISM * 0
18-FEB-2009 08:33:23 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2319)) * establish * PRISM * 0
18-FEB-2009 08:33:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2320)) * establish * PRISM * 0
18-FEB-2009 08:33:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2321)) * establish * PRISM * 0
18-FEB-2009 08:33:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2322)) * establish * PRISM * 0
18-FEB-2009 08:33:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=2323)) * establish * PRISM * 0
18-FEB-2009 08:33:25 * service_update * prism * 0
18-FEB-2009 08:33:31 * service_update * prism * 0
18-FEB-2009 08:33:34 * service_update * prism * 0
18-FEB-2009 08:36:55 * (CONNECT_DATA=(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program?Files\Microsoft?Office\OFFICE11\EXCEL.EXE)(HOST=WKST-W21062)(USER=USER3019))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.227.60)(PORT=3845)) * establish * PRISM * 0
18-FEB-2009 08:36:56 * (CONNECT_DATA=(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program?Files\Microsoft?Office\OFFICE11\EXCEL.EXE)(HOST=WKST-W21062)(USER=USER3019))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.227.60)(PORT=3846)) * establish * PRISM * 0
18-FEB-2009 08:36:58 * service_update * prism * 0
18-FEB-2009 08:37:22 * service_update * prism * 0
18-FEB-2009 08:37:37 * service_update * prism * 0
18-FEB-2009 08:44:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1260)) * establish * PRISM * 0
18-FEB-2009 08:44:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1261)) * establish * PRISM * 0
18-FEB-2009 08:44:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1265)) * establish * PRISM * 0
18-FEB-2009 08:44:25 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1266)) * establish * PRISM * 0
18-FEB-2009 08:44:25 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1267)) * establish * PRISM * 0
18-FEB-2009 08:44:25 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1268)) * establish * PRISM * 0
18-FEB-2009 08:44:25 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1269)) * establish * PRISM * 0
18-FEB-2009 08:44:25 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1270)) * establish * PRISM * 0
18-FEB-2009 08:44:25 * service_update * prism * 0
18-FEB-2009 08:44:28 * service_update * prism * 0
18-FEB-2009 08:44:31 * service_update * prism * 0
18-FEB-2009 08:44:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1275)) * establish * PRISM * 0
18-FEB-2009 08:44:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1276)) * establish * PRISM * 0
18-FEB-2009 08:44:36 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1277)) * establish * PRISM * 0
18-FEB-2009 08:44:36 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1278)) * establish * PRISM * 0
18-FEB-2009 08:44:36 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1279)) * establish * PRISM * 0
18-FEB-2009 08:44:36 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1280)) * establish * PRISM * 0
18-FEB-2009 08:44:36 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1281)) * establish * PRISM * 0
18-FEB-2009 08:44:36 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1282)) * establish * PRISM * 0
18-FEB-2009 08:44:37 * service_update * prism * 0
18-FEB-2009 08:44:43 * service_update * prism * 0
18-FEB-2009 08:46:52 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\msqry32.exe)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1308)) * establish * PRISM * 0
18-FEB-2009 08:47:07 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\msqry32.exe)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1309)) * establish * PRISM * 0
18-FEB-2009 08:47:07 * service_update * prism * 0
18-FEB-2009 08:47:46 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1310)) * establish * PRISM * 0
18-FEB-2009 08:47:49 * service_update * prism * 0
18-FEB-2009 08:47:56 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1313)) * establish * PRISM * 0
18-FEB-2009 08:48:14 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\msqry32.exe)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1314)) * establish * PRISM * 0
18-FEB-2009 08:48:23 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\msqry32.exe)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1315)) * establish * PRISM * 0
18-FEB-2009 08:48:25 * service_update * prism * 0
18-FEB-2009 08:49:10 * service_update * prism * 0
18-FEB-2009 08:49:12 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1316)) * establish * PRISM * 0
18-FEB-2009 08:49:13 * service_update * prism * 0
18-FEB-2009 08:49:16 * service_update * prism * 0
18-FEB-2009 08:49:44 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1318)) * establish * PRISM * 0
18-FEB-2009 08:49:46 * service_update * prism * 0
18-FEB-2009 08:49:52 * service_update * prism * 0
18-FEB-2009 08:49:59 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1319)) * establish * PRISM * 0
18-FEB-2009 08:50:03 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1320)) * establish * PRISM * 0
18-FEB-2009 08:50:04 * service_update * prism * 0
18-FEB-2009 08:50:07 * service_update * prism * 0
18-FEB-2009 08:50:31 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1323)) * establish * PRISM * 0
18-FEB-2009 08:50:31 * service_update * prism * 0
18-FEB-2009 08:50:37 * service_update * prism * 0
18-FEB-2009 08:51:04 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1324)) * establish * PRISM * 0
18-FEB-2009 08:51:07 * service_update * prism * 0
18-FEB-2009 08:51:10 * service_update * prism * 0
18-FEB-2009 08:51:28 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1327)) * establish * PRISM * 0
18-FEB-2009 08:51:28 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1328)) * establish * PRISM * 0
18-FEB-2009 08:51:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1329)) * establish * PRISM * 0
18-FEB-2009 08:51:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1330)) * establish * PRISM * 0
18-FEB-2009 08:51:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1331)) * establish * PRISM * 0
18-FEB-2009 08:51:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1332)) * establish * PRISM * 0
18-FEB-2009 08:51:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1333)) * establish * PRISM * 0
18-FEB-2009 08:51:30 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=\\ORACLE_HOST\PRISMPM\PRISMPM.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1334)) * establish * PRISM * 0
18-FEB-2009 08:51:31 * service_update * prism * 0
18-FEB-2009 08:51:37 * service_update * prism * 0
18-FEB-2009 08:53:07 * service_update * primavera * 0
18-FEB-2009 08:53:46 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRISM)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE)(HOST=WKST-W20972)(USER=USER3157))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.180.225.7)(PORT=1346)) * establish * PRISM * 0
18-FEB-2009 08:53:49 * service_update * prism * 0
18-FEB-2009 08:53:52 * service_update * prism * 0
These opened port are not reused again, so in one day the listener hangs and I need to restart the service, the extrange part is when I execute the netstat command just a few of the reported ports are used.
Any hints or configuration that I need to do?
Best regards.
Edited by: Cristian Orellana on Feb 18, 2009 7:28 AM