TNS Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TNS Error

  1. #1
    Join Date
    Apr 2001
    Posts
    47
    Hi,


    I'm facing the following error. My connection gets disconnected after some time saying the following error.

    ORA-12571 : TNS packet writer failure0 error

    and second try i have this message error ORA-03114: not connected to ORACLE.

    Could anyone throw some lights on this?


  2. #2
    Join Date
    May 2002
    Posts
    2,645
    The underlying reason for the ORA-03113 and TNS-12571 errors is that the connection is being terminated prematurely. This is caused in part because of the extreme long distance between client and server.

    On Windows NT:

    Increase the retransmission setting on the Windows NT client by editing the registry and adding the key TcpMaxDataRetransmissions (REG_DWORD) set to 15.

    SQL*Net tried to transmit the packet five times before it detected the network was down. This is a default of TCP/IP on Windows NT and Windows 95.

    Possibly the last packet sent is not being received by the server. Which returns the error 54, connection reset/network is busy. SQL*Net assumes the server is down and closes the connection.

  3. #3
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    ORA-12571 : TNS packet writer failure0 error

    and second try i have this message error ORA-03114: not connected to ORACLE.


    ==If u are Trying to connect it from client machine , make sure that u have posted all the correct entries in NET 8 configuration assistant.Host name , oracle_Sid, port , protocol.

    ==Check whether the oracle instance is started and listener is started.

    == Check the Oracle_SID which u are trying to connect.If there are many instances running on the same machine.


    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

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