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)) * 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/介面定時器/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: Subscription 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