oracle监听日志地址,查看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