ORA-03123: Operation Would Block
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-03123: Operation Would Block

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    ORA-03123: Operation Would Block

    FATAL ERROR IN TWO_TASK SERVER

    Docs say its not an error. Ok.
    But what's causing it? What does it actually mean?
    From the trace files its a 'SELECT * FROM a complicated view that draws data across a link from a remote database' that triggers it.

    Why would the SELECT be blocking anything?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Code:
    Solution Description:  
    =====================    
    Upgrade your version of SQL*Net to 2.3. Older versions of SQL*Net
    (prior to   version 2.3) are not multi-threaded and its commands are
    issued to SQL*Net   before executing commands are finished.  This can
    result in an ORA-03123.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    How do I check my version of SQL*Net?

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