ORA-12571: TNS:packet writer failure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-12571: TNS:packet writer failure

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    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?
    Agasimani
    OCP(10g/9i/8i/8)

  2. #2
    Join Date
    Nov 2000
    Posts
    245

    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
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Apr 2009
    Posts
    1
    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 9.2.0.8.0 - 64bit Production
    PL/SQL Release 9.2.0.8.0 - Production
    CORE 9.2.0.8.0 Production
    TNS for HPUX: Version 9.2.0.8.0 - Production
    NLSRTL Version 9.2.0.8.0 - 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