Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2005
    Posts
    67

    Unanswered: TNS-12536: TNS:operation would block and

    Hi all,

    I have an Oracle 8i under Windows 2000 and the listener stops every a couple of hours.
    I checked listener's log and found the following.

    It reaches 2 GB and it stops (or blocks new connections).
    Why does it reaches 2 GB in just a couple of hours ?

    Inside the file I found millions of rows like these:

    TNS-12536: TNSperation would block
    and
    19-MAY-2010 14:06:32 * 1168
    TNS-01168: Cannot allocate memory

    What could the reason of so many TNS-01168 (Millions!!) ???
    What should I check ?

    For the time being I disabled the log, but I'd like to know the root cause.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I have an Oracle 8i under Windows 2000 and the listener stops every a couple of hours.
    >It reaches 2 GB and it stops (or blocks new connections).

    8i is an obsoleted & unsupported version.
    With 32-bit software, 2GB is the largest positive integer that can be represented.
    It stops because it has run out of bits & can not count higher.

    Please join the 21st century at your earliest convenience & upgrade to V11 ASAP

    Code:
    12536, 00000, "TNS:operation would block"
    // *Cause: An internal operation did not commence because to do so would
    // block the current process and the user has requested that operations be
    // non-blocking.
    // *Action:  None needed; this is an information message.
    bcm@bcm-laptop:~$ oerr tns 1168
    01168, 00000, "Cannot allocate memory"
    // *Cause:  Sufficient memory could not be allocated to perform the desired
    // activity.
    // *Action:  Either free some resource for TNS, or add more memory to the
    // machine. For further details, turn on tracing and reexecute the operation.
    Last edited by anacedent; 05-21-10 at 13:06.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2009
    Posts
    7
    Quote Originally Posted by djuritz View Post
    Hi all,

    I have an Oracle 8i under Windows 2000 and the listener stops every a couple of hours.
    I checked listener's log and found the following.

    It reaches 2 GB and it stops (or blocks new connections).
    Why does it reaches 2 GB in just a couple of hours ?

    Inside the file I found millions of rows like these:

    TNS-12536: TNSperation would block
    and
    19-MAY-2010 14:06:32 * 1168
    TNS-01168: Cannot allocate memory

    What could the reason of so many TNS-01168 (Millions!!) ???
    What should I check ?

    For the time being I disabled the log, but I'd like to know the root cause.

    Thanks in advance.
    Either free some resource for TNS, or add more memory to the machine. For further details, turn on tracing and reexecute the operation.

    $ getconf PAGE_SIZE 4096 $ vmstat 2 5 procs memory page faults cpu $ vmstat 2 5 procs memory page faults cpu

  4. #4
    Join Date
    Sep 2005
    Posts
    67
    Hi all,

    thanks for you answers.
    The system is a legacy, so one day it will be removed, but untill then it should work.
    For that reason it cannot be upgraded.

    Regarding the advise from harshul, it's a Windows server, not unix :-(
    It seems that it hangs when the listener's log reaches 2 GB, so I disabled it now.

    What I can do is to generate trace for a while.
    What kind of trace do you mean ?
    All sessions ?
    Do you have the command I should run ?

    Thanks a lot

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Activate sqlnet trace, in sqlnet.ora:
    TRACE_DIRECTORY_CLIENT=<your directory for instance /tmp>
    TRACE_FILE_CLIENT=<a file name for instance sqlnet.trc>
    TRACE_LEVEL_CLIENT=admin


    any clues in listener.log file?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    May 2010
    Posts
    1

    Unhappy Out of the box solution

    Quote Originally Posted by djuritz View Post
    Hi all,

    I have an Oracle 8i under Windows 2000 and the listener stops every a couple of hours.
    I checked listener's log and found the following.

    It reaches 2 GB and it stops (or blocks new connections).
    Why does it reaches 2 GB in just a couple of hours ?

    Inside the file I found millions of rows like these:

    TNS-12536: TNSperation would block
    and
    19-MAY-2010 14:06:32 * 1168
    TNS-01168: Cannot allocate memory

    What could the reason of so many TNS-01168 (Millions!!) ???
    What should I check ?

    For the time being I disabled the log, but I'd like to know the root cause.

    Thanks in advance.
    Until you find reason, put this in scheduler for every 1 hour and delete old log!

    Damir Vadas Linux and Oracle ... as I learned: Rotate listener log (TNS-12547, TNS-12560, TNS-00517) Part II
    http://www.dbforums.com/db_images_v3...ilies/beer.gif

Tags for this Thread

Posting Permissions

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