Check listener. log to confirm no problem
# Find/-name listener. Log
/Home/Oracle/APP/orahome_1/Network/log/listener. Log
The location is $ ORACLE_HOME/Network/log/listener. log.
Tnslsnr for IBM/aix risc system/6000: Version 10.2.0.4.0-production on 29-dec-2009 15:12:15
Copyright (c) 1991,200 7, Oracle. All rights reserved.
System parameter file is/home/Oracle/APP/orahome_1/Network/admin/listener. ora
Log messages written to/home/Oracle/APP/orahome_1/Network/log/listener. Log
Trace information written to/home/Oracle/APP/orahome_1/Network/Trace/listener. TRC
Trace Level is currently 0
Started with PID = 856304
Listening On: (description = (address = (Protocol = TCP) (host = data1) (Port = 1521 )))
Listening On: (description = (address = (Protocol = IPC) (Key = extproc0 )))
Listener completed notification to CRS on Start
Timestamp * connect data [* protocol info] * event [* Sid] * return code
29-dec-2009 15:12:15 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = C:/program files/ksec/tdcsserverf
Orl0150/tdcsserver.exe) (host = ksec01) (user = System) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port =
3274). * establish * l150 * 12514
TNS-12514: TNS: Listener does not currently know of Service requested in connect Descriptor
Warning: subtasks for node down event still pending
29-dec-2009 15:12:15 * (CONNECT_DATA = (cid = (program =) (host = data1) (user = Oracle) (command = status) (Argument
S = 64) (Service = listener) (version = 169870336) * status * 0
29-dec-2009 15:12:15 * service_register * l150 * 0
29-dec-2009 15:12:16 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = D:/timms_wms/tmeventsvr/tmeventsv
R.exe) (host = ksec01) (user = administrator) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port = 3275) * E
Stablish ** l150 * 12528
TNS-12528: TNS: Listener: all appropriate instances are blocking new connections
29-dec-2009 15:12:19 * (CONNECT_DATA = (SERVICE_NAME = l152) (cid = (program = C:/tmeventsvr/tmeventsvr.exe) (hos
T = C) (user = administrator) * (address = (Protocol = TCP) (host = 192.168.200.5) (Port = 3023) * establish * l152
* 12514
TNS-12514: TNS: Listener does not currently know of Service requested in connect Descriptor
29-dec-2009 15:12:20 * service_update * l150 * 0
29-dec-2009 15:12:16 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = D:/timms_wms/tmeventsvr/tmeventsv
R.exe) (host = ksec01) (user = administrator) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port = 3275) * E
Stablish ** l150 * 12528
TNS-12528: TNS: Listener: all appropriate instances are blocking new connections
29-dec-2009 15:12:19 * (CONNECT_DATA = (SERVICE_NAME = l152) (cid = (program = C:/tmeventsvr/tmeventsvr.exe) (hos
T = C) (user = administrator) * (address = (Protocol = TCP) (host = 192.168.200.5) (Port = 3023) * establish * l152
* 12514
TNS-12514: TNS: Listener does not currently know of Service requested in connect Descriptor
29-dec-2009 15:12:20 * service_update * l150 * 0
29-dec-2009 15:12:22 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = C:/program files/ksec/tdcsserverf
Orl0150/tdcsserver.exe) (host = ksec01) (user = System) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port =
3276) * establish * l150 * 0
29-dec-2009 15:12:22 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = C:/program files/ksec/tdcsserverf
Orl0150/tdcsserver.exe) (host = ksec01) (user = System) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port =
3277) * establish * l150 * 0
29-dec-2009 15:12:22 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = C:/program files/ksec/tdcsserverf
Orl0150/tdcsserver.exe) (host = ksec01) (user = System) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port =
3278) * establish * l150 * 0
29-dec-2009 15:12:23 * service_update * l150 * 0
29-dec-2009 15:12:30 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = D:/timms_wms/interface Timer/dll/tmtim
Ermanager.exe) (host = ksec01) (user = administrator) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port = 32
79) * establish * l150 * 0
29-dec-2009 15:12:32 * service_update * l150 * 0
29-dec-2009 15:12:32 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = D:/timms_wms/TM/tmsvr.exe) (host = K
Sec01) (user = administrator) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port = 3280) * establish * L1
50*0
29-dec-2009 15:12:35 * service_update * l150 * 0
29-dec-2009 15:12:48 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = D:/timms_wms/tmeventsvr/tmeventsv
R.exe) (host = ksec01) (user = administrator) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port = 3281) * E
Stablish * l150 * 0
29-dec-2009 15:12:50 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = C:/program files/ksec/tdcsserverf
Orl0150/tdcsserver.exe) (host = ksec01) (user = System) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port =
3282) * establish * l150 * 0
29-dec-2009 15:12:50 * service_update * l150 * 0
29-dec-2009 15:12:51 * (CONNECT_DATA = (SERVICE_NAME = l152) (cid = (program = C:/tmeventsvr/tmeventsvr.exe) (hos
T = C) (user = administrator) * (address = (Protocol = TCP) (host = 192.168.200.5) (Port = 3024) * establish * l152
* 12514
TNS-12514: TNS: Listener does not currently know of Service requested in connect Descriptor
29-dec-2009 15:12:51 * service_register * l152 * 0
Warning: subtasks for node down event still pending
29-dec-2009 15:12:55 * (CONNECT_DATA = (cid = (program =) (host = data1) (user = Oracle) (command = status) (Argument
S = 64) (Service = listener) (version = 169870336) * status * 0
29-dec-2009 15:12:56 * service_update * l152 * 0
29-dec-2009 15:12:59 * service_update * l152 * 0
29-dec-2009 15:13:07 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = C:/program files/ksec/tdcsserverf
Orl0150/tdcsserver.exe) (host = ksec01) (user = System) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port =
3283) * establish * l150 * 0
29-dec-2009 15:13:08 * service_update * l150 * 0
29-dec-2009 15:13:55 * (CONNECT_DATA = (SERVICE_NAME = l152) (cid = (program = C:/tmeventsvr/tmeventsvr.exe) (hos
T = C) (user = administrator) * (address = (Protocol = TCP) (host = 192.168.200.5) (Port = 3026) * establish * l152
* 0
29-dec-2009 15:13:56 * service_update * l152 * 0
29-dec-2009 15:14:05 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = C:/program files/ksec/tdcsserverf
Orl0150/tdcsserver.exe) (host = ksec01) (user = System) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port =
3284) * establish * l150 * 0
29-dec-2009 15:14:05 * service_update * l150 * 0
29-dec-2009 15:15:18 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = D:/timms_wms/TM/tmsvr.exe) (host = K
Sec01) (user = administrator) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port = 3289) * establish * L1
50*0
29-dec-2009 15:15:20 * service_update * l150 * 0
29-dec-2009 15:15:50 * service_update * l150 * 0
29-dec-2009 15:15:57 * (CONNECT_DATA = (SERVICE_NAME = l150) (cid = (program = C:/program files/ksec/tdcsserverf
Orl0150/tdcsserver.exe) (host = ksec01) (user = System) * (address = (Protocol = TCP) (host = 192.168.200.4) (Port =
3292) * establish * l150 * 0