DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: TNS-12518: TNS:listener could not hand off client connection

  1. #1
    Join Date
    Jan 2004
    Location
    Nottinghamshire, UK
    Posts
    14

    TNS-12518: TNS:listener could not hand off client connection

    hello one and all,

    Would the error message above cause us to have ora-04030 errors or are they completely separate?

    I raised an Oracle SR about it and they are suggesting that the Oracle process is running out of RAM (hitting the magical 2gb limit, didnt know there was one!)


    Cheers

    Sean
    Last edited by savourys; 09-11-2007 at 07:06 AM.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You need to trace the listener and when this happens again you need to upload the tracefile to oracle support for analysis

    regards
    Hrishy

  3. #3
    Join Date
    Jan 2004
    Location
    Nottinghamshire, UK
    Posts
    14
    would do but the trc file is massive over 2gb

    sean

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Whats the operating system and ae you using shared server ?

    How much memory is there on thsi server ? what version of oracle is it

    You need to upload only the relevant posrtion of the listener trace and search for the time when this error occured and the corresponding trace in the long file not the entire 2Gb

    regards
    Hrishy

  5. #5
    Join Date
    Jan 2004
    Location
    Nottinghamshire, UK
    Posts
    14
    hi,

    Windows 2003 r2 32bit standard edition

    We do have 4GB of ram on the server and are running oracle version 10.2.0.1

    Would love to open the file and upload the appropriate part but I dont have a machine that is capable of opening the file.


    sean

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    use useful unix commands.. to achive what u wanted.. you can zip whole file and send it to oracle support.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Hmm i am not familair with windows but one thing i would try would be backup this 2gb logfile for now.

    And then truncate the logfile using something like
    type null >listener.log

    and then see if you can reproduce the problem and then upload the trace file for analysis

    setting up a AT job to do perodic log rotation so that the log file stays within manageable limits is also a good option

    regards
    Hrishy

  8. #8
    Join Date
    Jan 2004
    Location
    Nottinghamshire, UK
    Posts
    14
    hrishy

    is that a windows or unix command?


    sean

  9. #9
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    My dear, right, you can´t open the full file, but exactly WHAT stops you from reading ONLY the last n lines (last 1000 lines or so), and upload that to Support ????? IF your SO don´t have the appropriate TAIL command , download any suitable freeware, I use CYGWIN...

    Regards,

    Chiappa

  10. #10
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    type null >listener.log

    Thats a windows command the truncate the listener.log file to zero bytes test it first on a copy of listener log see how it truncate the file

    You can also try downloading cygwin for windows Just goole for it if you are familair with unix style commands


    regards
    Hrishy
    Last edited by hrishy; 09-11-2007 at 08:03 AM.

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