LSNRCTL - services command output
Oracle 8.1.5 on Windows
The LSNRCTL control utility has a SERVICES command that displays the following...
Quote:
C:\>lsnrctl
LSNRCTL for 32-bit Windows: Version 8.1.5.0.0 - Production on 21-MAR-03 12:05:17
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
BLAZE has 1 service handler(s)
DEDICATED SERVER established:44635 refused:27
LOCAL SERVER
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
The command completed successfully
LSNRCTL>
Now, in the above quote, connections refused is 27. When connections are refused, is error information logged in the listener.log file? If so, what is the format, to identify it in the listener.log file of 17mb?
Normally, the listener.log file has the following similar entries...
Quote:
21-MAR-03 11:00:33 * (CONNECT_DATA=(SID=blaze)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.66.254)(PORT=61401)) * establish * blaze * 0
21-MAR-03 11:00:34 * (CONNECT_DATA=(SID=blaze)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.66.254)(PORT=61403)) * establish * blaze * 0
21-MAR-03 11:00:34 * (CONNECT_DATA=(SID=blaze)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.66.254)(PORT=61405)) * establish * blaze * 0
21-MAR-03 11:00:34 * (CONNECT_DATA=(SID=blaze)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.66.254)(PORT=61407)) * establish * blaze * 0
21-MAR-03 11:00:34 * (CONNECT_DATA=(SID=blaze)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.66.254)(PORT=61409)) * establish * blaze * 0
21-MAR-03 11:00:34 * (CONNECT_DATA=(SID=blaze)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.66.254)(PORT=61411)) * establish * blaze * 0
Thanks.
