DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2001
    I have Oracle 8.1.6 on Sun Solaris. If I open a session, and leave it idle for about couple of seconds (about a minute), and then try to execute SQL statement it shows following error:

    ORA-12571: TNSacket writer failure

    What is the cause and how can I eliminate this and keep the session open for indefinite period?

  2. #2
    Join Date
    Nov 2000

    I had same error "constantly". based on oracle:

    12571, 00000, "TNSacket writer failure"
    // *Cause: An error occurred during a data send.
    // *Action: Not normally visible to the user. For further details, turn
    // on tracing and reexecute the operation. If error persists, contact
    // Oracle Customer Support.

    the problem is I can not recreate it manully (when I see the error on trace file the process back to normal)

    anyone has idea?

  3. #3
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    Check the profile that you have assigned for the user. There you might have set the idle time limit low, which would disconnect the session connection to the user if the session were to be idle (i.e. literally dead) for the specified period then it would be disconnected by the server.

    Good luck,

    Life is a journey, not a destination!

  4. #4
    Join Date
    Apr 2009
    For last couple of months i am encountering the below errors in my production environment.

    Today i encountered this error
    ORA-12571: TNSacket writer failure
    ORA-12500: TNS:listener failed to start a dedicated server process

    Few days back the below error was seen
    TNS-12500: TNS:listener failed to start a dedicated server process
    TNS-12547: TNS:lost contact
    TNS-12560: TNSrotocol adapter error
    TNS-00517: Lost contact
    HPUX Error: 32: Broken pipe

    TNS-12500: TNS:listener failed to start a dedicated server process
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    HPUX Error: 23: File table overflow

    I am just wondering when all things working fine and all of sudden why these errors. what is the reason? I have the following version of oracle

    Oracle9i Enterprise Edition Release - 64bit Production
    PL/SQL Release - Production
    CORE Production
    TNS for HPUX: Version - Production
    NLSRTL Version - Production

    Any help is greatly appreciated. Thanks in advance...

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.