查看oracle监听日志

察看listener.log 确认没有问题
# find / -name listener.log
/home/oracle/app/OraHome_1/network/log/listener.log
位置在$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, 2007, 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: Subscription 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)) * est