LSNRCTL - services command output
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: LSNRCTL - services command output

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Question LSNRCTL - services command output

    Oracle 8.1.5 on Windows

    The LSNRCTL control utility has a SERVICES command that displays the following...
    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...
    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.
    Share on Google+

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Got it! Search for 'TNS-' string in the listener.log file.

    Thanks.
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width