Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2002
    Location
    Norwood, MA
    Posts
    20

    Angry Unanswered: How to read a listener.log file

    Hi all. Was wondering if anyone could guide me gently through this snippet of a listener.log file. I am experiencing ORA-12500 errors eventually from db server and have begun to investigate the possibility of too many connections hanging around - no doubt a result of poor programming in the DLL's, but that is another story - and want to get a grip on what the listener.log is telling me.

    This snippet is what the listener.log generates when I log into my ASP web-based application from IE5.5 on Windows NT, Microsoft Transaction Server-enabled, with Visual Basic Middle tier COM+ DLL's within MTS.

    20-FEB-2002 14:46:54 * (CONNECT_DATA=(SERVICE_NAME=OZZIEDB001.OZZIEWORKS. COM)(CID=(PROGRAM=C:\WINNT\System32\dllhost.exe)(H OST=OZZIELIVE02)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.YYY.16.73)(PORT=21 32)) * establish * OZZIEDB001.OZZIEWORKS.COM * 0
    20-FEB-2002 14:46:54 * (CONNECT_DATA=(SERVICE_NAME=OZZIEDB001.OZZIEWORKS. COM)(CID=(PROGRAM=C:\WINNT\System32\msdtc.exe)(HOS T=OZZIELIVE02)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.YYY.16.73)(PORT=21 34)) * establish * OZZIEDB001.OZZIEWORKS.COM * 0
    20-FEB-2002 14:46:54 * (CONNECT_DATA=(SERVICE_NAME=OZZIEDB001.OZZIEWORKS. COM)(CID=(PROGRAM=C:\WINNT\System32\dllhost.exe)(H OST=OZZIELIVE02)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.YYY.16.73)(PORT=21 36)) * establish * OZZIEDB001.OZZIEWORKS.COM * 0
    20-FEB-2002 14:47:01 * (CONNECT_DATA=(SERVICE_NAME=OZZIEDB001.OZZIEWORKS. COM)(CID=(PROGRAM=C:\WINNT\System32\dllhost.exe)(H OST=OZZIELIVE02)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.YYY.16.73)(PORT=21 38)) * establish * OZZIEDB001.OZZIEWORKS.COM * 0
    20-FEB-2002 14:47:01 * (CONNECT_DATA=(SERVICE_NAME=OZZIEDB001.OZZIEWORKS. COM)(CID=(PROGRAM=C:\WINNT\System32\msdtc.exe)(HOS T=OZZIELIVE02)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.YYY.16.73)(PORT=21 40)) * establish * OZZIEDB001.OZZIEWORKS.COM * 0
    20-FEB-2002 14:47:01 * (CONNECT_DATA=(SERVICE_NAME=OZZIEDB001.OZZIEWORKS. COM)(CID=(PROGRAM=C:\WINNT\System32\dllhost.exe)(H OST=OZZIELIVE02)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.YYY.16.73)(PORT=21 42)) * establish * OZZIEDB001.OZZIEWORKS.COM * 0
    20-FEB-2002 14:47:01 * (CONNECT_DATA=(SERVICE_NAME=OZZIEDB001.OZZIEWORKS. COM)(CID=(PROGRAM=C:\WINNT\System32\dllhost.exe)(H OST=OZZIELIVE02)(USER=IWAM_CTLIVE01))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.YYY.16.73)(PORT=21 44)) * establish * OZZIEDB001.OZZIEWORKS.COM * 0
    20-FEB-2002 14:47:02 * (CONNECT_DATA=(SERVICE_NAME=OZZIEDB001.OZZIEWORKS. COM)(CID=(PROGRAM=C:\WINNT\System32\dllhost.exe)(H OST=OZZIELIVE02)(USER=IWAM_CTLIVE01))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.YYY.16.73)(PORT=21 46)) * establish * OZZIEDB001.OZZIEWORKS.COM * 0




    Is this telling me that no less than 8(!) separate connections are being created based on the PORT being different for each CONNECT_DATA element?

    I eventually receive these errors from the listener.log file:

    TNS-12500: TNS:listener failed to start a dedicated server process
    TNS-12540: TNS:internal limit restriction exceeded
    TNS-12560: TNSrotocol adapter error
    TNS-00510: Internal limit restriction exceeded
    32-bit Windows Error: 8: Exec format error

    I need a long-term solution to this problem.

    Thanks In Advance.

  2. #2
    Join Date
    Feb 2002
    Location
    CT,US
    Posts
    1
    By this time you might have answer. If not, here is.
    Each field is delimited by *
    A successful connection returns 0. Failure connection returns oracle error code.
    This is the format
    timestamp*connect info* protocol tcp/ip , spx, port * sid * return value

  3. #3
    Join Date
    Jan 2002
    Location
    italy
    Posts
    39
    Hello!!!
    The error you get is telling you that resources on the server have been depleted, may be due to the usage of oracle or any other process.

    If you have a large number of connections you may need to increase the value of parameter PROCESSES in the init file.

    You may query the view V$RESOURCE_LIMIT and see if any resource raised to the maximum value, and you should notice if PROCESSES are too high.

    Take a look at phisical memory usage. As an alternative, if processes are already high and increasing phisical memory is a problem you may consider configuring the listener for multi threaded server.

    hope this helps,

    astropp
    astropp

  4. #4
    Join Date
    Feb 2002
    Location
    Norwood, MA
    Posts
    20
    Thanks. Here is what I get currently from V$RESOURCE_LIMIT. As you can see, PROCESSES is set to 6000:
    RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU
    ------------------------------ ------------------- --------------- ---------- ----------
    processes 30 56 6000 6000
    sessions 30 57 6605 6605
    enqueue_locks 270 275 80142 80142
    enqueue_resources 270 291 31130 31130
    _lm_procs 0 0 0 0
    lm_ress 0 0 0 UNLIMITED
    lm_locks 0 0 0 UNLIMITED
    lm_cache_ress 0 0 0 UNLIMITED
    dml_locks 0 20 29062 29062
    temporary_table_locks 0 2 UNLIMITED UNLIMITED
    transactions 0 5 7266 7266
    sort_segment_locks 0 2 UNLIMITED UNLIMITED
    max_rollback_segments 40 40 1454 1454
    distributed_transactions 0 2 7266 7266
    mts_max_servers 0 0 20 20
    parallel_max_servers 0 0 13 13

  5. #5
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    It could be you have hit a resource limit at the OS end rather than the database. Your OS may limit the number of processes and or sockets.

    Alan

Posting Permissions

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