ORA-12571 TNS Packet Writer Failure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-12571 TNS Packet Writer Failure

Hybrid View

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

    ORA-12571 TNS Packet Writer Failure

    Suddenly cropped in today's Trace file.

    Any ideas what's causing it? Why did the SQL statement produce this warning/error?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    shutdown immediate for example

    lost network connection fr example

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    check oracle errors messages in docs. u will get some more
    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"

  4. #4
    Join Date
    Apr 2002
    Location
    Bangalore
    Posts
    47

    Re: ORA-12571 TNS Packet Writer Failure

    ORA-12571 TNS Packet Writer Failure
    Originally posted by JMac
    Any ideas what's causing it? Why did the SQL statement produce this warning/error?
    This error occurs when the client is sending data to the server.
    The possible cause can be
    *Database halted
    *Listener Down
    *network failure
    Most often than not it is the network failure
    Cheers
    Murali

  5. #5
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Users never even reported a problem!

    Tracked it (or narrowed ir) down to network failure. Thanks guys.

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: Re: ORA-12571 TNS Packet Writer Failure

    Originally posted by dasari98
    ORA-12571 TNS Packet Writer Failure
    *Listener Down
    I guess this would not cause any problem if db is in dedicated server mode.

    Thanks
    Abhay.
    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"

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