查oracle监听,oracle基本概念之–查看oracle监听日志 | 学步园

最新推荐文章于 2024-04-16 15:01:58 发布

星巴超超

最新推荐文章于 2024-04-16 15:01:58 发布

阅读量272

点赞数

文章标签：查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

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

星巴超超

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
查oracle监听,oracle基本概念之–查看oracle监听日志 | 学步园

察看listener.log 确认没有问题# find / -name listener.log/home/oracle/app/OraHome_1/network/log/listener.log位置在$ORACLE_HOME/network/log/listener.logTNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Pr...
复制链接

扫一扫