• RELEVANCY SCORE 5.83

    DB:5.83:Ora-12571 Error,Plz Explain. 1s





    Hi !

    Plz, define/explain

    ORA-12571: TNS: Packet Writer Failure.

    Thanks..

    Regards!

    DB:5.83:Ora-12571 Error,Plz Explain. 1s

    Check out this site -

    http://www.cryer.co.uk/brian/oracle/ORA12571.htm

    Google gives plenty of hits for this error that are quite useful. If you still don't find the problem, try giving a little more detail about when/where you get this error, along with what version of Oracle you are using.

    Hope it helps,

    A

  • RELEVANCY SCORE 5.72

    DB:5.72:Ora-12571-Tns: Packet Writer Failure 8f





    Hi All,

    am using oracle 6i and facing this problem when am connecting Forms to Database..

    Error Encounterd:ORA-12571-TNS: PACKET WRITER FAILURE.

    Plz help.

    Regards,
    Neha

  • RELEVANCY SCORE 5.72

    DB:5.72:Ora-12571: Tns: Packet Writer Failure c3





    I've seen there is another thread in this forum regarding
    "ORA-12571: TNS:packet writer failure"
    caused by ODP.NET. But it seems a dead thread. So I post this new topic.

    During normal utilization of database (without shutdown and restart of DB instance) from ASP.NET pages of web application, it happens (sometimes, it is not deterministic) that execution of
    Oracle.DataAccess.Client.OracleDataAdapter.Fill (that executes Oracle.DataAccess.Client.OracleCommand.ExecuteReader)
    raises
    [OracleException: ORA-12571: TNS: packet writer failure]

    The version of ODP.NET I'm using is 9.2.0.2.102. Is there a known bug that affects ODP.NET and causes ORA-12571?

    Thank to everyone that could help me

    DB:5.72:Ora-12571: Tns: Packet Writer Failure c3

    Found that thread:

    ***
    ODP.NET 920401 introduced the concept of validating a connection before giving it to an application. Of course, it is expensive and should be used wisely. An excerpt from the Readme:

    ODP.NET has introduced a new connection string attribute "validate connection" that should be set to true in order to validate connections coming out of the pool. By default, this property is set to false.

    Note that validation causes a round trip to the database for each connection coming out of the pool, which is very expensive in terms of performance.
    Therefore, this attribute should be used only if absolutely necessary.
    ***

  • RELEVANCY SCORE 5.17

    DB:5.17:Packet Writer Failure 1c


    Hi,

    I am experiencing the following error on a Oracle client PC:
    ORA-12571 : TNS Packet Writer Failure. The client PC cannot access any Oracle database, even by using Sql.
    The networking environment seems to be 100 % OK.
    Analysing the listener trace on the server did not help, nor did re-installing the Oracle client.

    Any idea about the problem ?

    Many thanks

  • RELEVANCY SCORE 4.96

    DB:4.96:Ora-12571 Error When Dts Run sk


    Hi,When DTS is run in scheduled time it fails with following error at step 3 after fetching certain records from Oracle giving below error, After failure when manually run from same client it executes successfully.Error MessageExecuted as user: \sqlclust. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:35:19 AM Error: 2013-10-23 01:03:13.75 Code: 0xC0202009 Source: DFT_ PKG_CALL_WRAP_FS OLE_SRC_Call_Wrap_FS [1293] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "ORA-12571: TNS:packet writer failure ". End Error Error: 2013-10-23 01:03:13.75 Code: 0xC0047038 Source: DFT_ TEST_CALL_WRAP_FS SSIS.Pipeline Description: SSIS Error Code DTS_E_MAINOUTPUTFAILED. The MainOutput method on component "OLE_SRC_Call_Wrap_FS" (1293) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:35:19 AM Finished: 1:04:30 AM Elapsed: 1751.7 seconds. The package execution failed. The step failed.Regards

    DB:4.96:Ora-12571 Error When Dts Run sk

    Hi,When DTS is run in scheduled time it fails with following error at step 3 after fetching certain records from Oracle giving below error, After failure when manually run from same client it executes successfully.Error MessageExecuted as user: \sqlclust. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:35:19 AM Error: 2013-10-23 01:03:13.75 Code: 0xC0202009 Source: DFT_ PKG_CALL_WRAP_FS OLE_SRC_Call_Wrap_FS [1293] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "ORA-12571: TNS:packet writer failure ". End Error Error: 2013-10-23 01:03:13.75 Code: 0xC0047038 Source: DFT_ TEST_CALL_WRAP_FS SSIS.Pipeline Description: SSIS Error Code DTS_E_MAINOUTPUTFAILED. The MainOutput method on component "OLE_SRC_Call_Wrap_FS" (1293) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:35:19 AM Finished: 1:04:30 AM Elapsed: 1751.7 seconds. The package execution failed. The step failed.Regards

  • RELEVANCY SCORE 4.79

    DB:4.79:Linux Error: 113: No Route To Host f9


    After completeing 3.1 in the installation guide I jump down to chapter 4, but I can't get the web interface to work.
    It doesn't matter how I access the URL, I've tried both http://localhost:8080/htmldb and http://realhostname:8080/htmldb/ with same result, no data at all, the connection is closed directly.
    I've checked listener.log and found this:

    02-NOV-2005 01:01:02 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=10.8.0.22)(PORT=2556)) * handoff * http * 12518
    TNS-12518: TNS:listener could not hand off client connection
    TNS-12571: TNS:packet writer failure
    TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error
    Linux Error: 113: No route to host
    02-NOV-2005 01:01:23 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=33183)) * handoff * http * 12518
    TNS-12518: TNS:listener could not hand off client connection
    TNS-12571: TNS:packet writer failure
    TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error
    Linux Error: 113: No route to host
    02-NOV-2005 01:02:54 * service_update * XE * 0
    02-NOV-2005 01:03:01 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=X.Y.Z.W)(PORT=33509)) * handoff * http * 12518
    TNS-12518: TNS:listener could not hand off client connection
    TNS-12571: TNS:packet writer failure
    TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error
    Linux Error: 113: No route to host

    DB:4.79:Linux Error: 113: No Route To Host f9

    We could configure shared server - the dispatchers run on fixed ports (if you set it up that way).

  • RELEVANCY SCORE 4.63

    DB:4.63:Import Problem ff


    Hi,

    While I am importing the oracle dump I got the below error :

    IMP-00058 : ORACLE error 12571 encountered
    ORA-12571 : TNS:packet writer failure
    IMP-00058 : ORACLE error 3114 encountered
    ORA-03114 : not connected to ORACLE
    IMP-00000 : Import terminated unsuccessfully

    Please find the import command which I executed from the DOS prompt :

    imp system/system123@testdb file=prod1.DMP buffer=64000000 commit=y fromuser=(user1) touser=(user1)

    OS Version : Win XP
    DB Version : 9.2.0.1.0

    Please help me in this regard.

    A.Mohammed Rafi.

    DB:4.63:Import Problem ff

    I shutdown the database, restarted the server and I tried with the option specified by you but still the same error encounters.

    Any other solutions ????

  • RELEVANCY SCORE 4.60

    DB:4.60:Tns-12571:Tns Packet Writer Failure 8x


    Hello Oracle Gurus,

    Our Oracle 9i database is hosted somewhere else and is behind the firewall. When accessing this database through TOAD, even after 2 minutes of inactivity, we get the "TNS-12571: TNS Packet writer failure" and we have to reconnect to the database again. This occurs in all of the client machines. The Oracle 9i database's firewall is open for the ip address from which we are using TOAD/SQL*Plus.

    Is there any configuration that needs to be changed on the Oracle Client or server side to solve this issue? I appreciate your help.

    Thanks,
    Saku

    DB:4.60:Tns-12571:Tns Packet Writer Failure 8x

    Hi,

    you can set sqlnet_expire_time option in sqlnet.ora file on the database server and set the time less than 2 mins. This to identify if the problem is because of some firewall configuration or other network related issue which causes the onnection to die.

    this parameter should keep all the client connection alive but results in extra trafic.

  • RELEVANCY SCORE 4.55

    DB:4.55:Ora-12571: Tns:Packet Writer Failure 3f


    Hai All,

    When I connect to a Oracle 7 database in the SCO-unix machine...I get ORA-12571: TNS:packet writer failure. How to connect to Oracle 7 as sys user or system...?

    Please help

    Shiju

    DB:4.55:Ora-12571: Tns:Packet Writer Failure 3f

    From memory this was often due to environment variables not being set correctly.

    Make sure the following are all correctly set:

    ORACLE_SID
    ORACLE_HOME
    LD_LIBRARY_PATH/SHLIB_PATH/LIBPATH (whichever SCO uses)

    make sure you use svrmgrl rather than sqlplus and use connect internal rather than connect as sys or system.

    Harry

  • RELEVANCY SCORE 4.55

    DB:4.55:Packet Writer Failure 38


    I have installed Oracle 8i (v8.1.7) and Forms Runtime 6i on XP Professional in a local machine. SQL*Plus connect the database and TNSPING its OK, but when run the program with the forms I receive the message "ORA-12571: TNS:packet writer failure".

    Thanks Regards,
    Nei

    DB:4.55:Packet Writer Failure 38

    Try removing your McAfee 7 (or other) virusscanner/firewall software.

  • RELEVANCY SCORE 4.39

    DB:4.39:Tns-12571 ak


    I get the 12571 TNS:packet writer failure when I try to connect to the database.

    Any Ideas??

    DB:4.39:Tns-12571 ak

    Which communation protocol you are using????

  • RELEVANCY SCORE 4.36

    DB:4.36:Listener Stopping 99


    Dear all

    Can you plaese adviseon same..

    TNS-12518: TNS:listener could not hand off client connection
    TNS-12571: TNS:packet writer failure
    TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error
    Linux Error: 104: Connection reset by peer
    27-JAN-2008 05:47:08 * service_update * crmdev * 0

    Regards

    DB:4.36:Listener Stopping 99

    Hi dear ,

    Please check this also :

    http://www.dbforums.com/t998569.html

    Best Regards
    Faheem latif
    Senior Database Architect
    Genie Technologies (Pvt.) Ltd.

  • RELEVANCY SCORE 4.29

    DB:4.29:Oracle 8 &Amp; Mcafee Firewall a3


    I can't get a valid connection to ORACLE.
    Error message: TNS-12571: TNS: Packet writer failure.

    McAfee Firewall is installed on my notebook
    ORACLE Server is installed on my notebook too.
    I'm trying to connect from SQL Plus (installed on my notebook too).

    Can Oracle and McAfee Firewall coexist?

    DB:4.29:Oracle 8 &Amp; Mcafee Firewall a3

    I'm facing this issue too. Can anyone provide solution?

  • RELEVANCY SCORE 4.22

    DB:4.22:Ora-12571 Tns: Packet Writer Filure ps


    Hi Yogi,
    tHANK YOU FOR YOUR REPLY.
    I have reinstalled Oracle 8i again..
    Starting Oracle DBA studio I am getting folowing error:
    ORA 12571 tns: PACKET WRITER FALIURE
    PLEASE ADVISE..
    THANK YOU in advance..
    Rajiv

    DB:4.22:Ora-12571 Tns: Packet Writer Filure ps

    Hi Yogi,
    tHANK YOU FOR YOUR REPLY.
    I have reinstalled Oracle 8i again..
    Starting Oracle DBA studio I am getting folowing error:
    ORA 12571 tns: PACKET WRITER FALIURE
    PLEASE ADVISE..
    THANK YOU in advance..
    Rajiv

  • RELEVANCY SCORE 4.19

    DB:4.19:Running Dba Studio c9



    Hi..

    I have a problem running DBA Studio.
    I just installed oracle client (8i) and made name service using net8 assistant.

    When I try to connect database using DBA Studio, the error occurrs.

    ----------------------------------------
    Ora-12571 TNS:packet writer failure.
    ----------------------------------------

    And, I cannot connect database using ODBC.
    When I try to connect db with ODBC the error occurrs.

    --------------------------------
    Ora-12541: TNS: no lisnter.
    --------------------------------

    I don't know why.
    I can connect database using SQL*Plus and use DML.

    Please, help me..

    DB:4.19:Running Dba Studio c9

    Did you connect to any other versions of Oracle from this same machine? I've noticed that if connecting to
    multiple versions of oracle, or if using multiple oracle
    products (forms, dba studio, reports) for multiple versions on the same pc, the tnsname.ora file that is used by
    a product may be different than you expect.

    Make sure the tnsnames.ora file that dba studio is using
    has the correct entries for the database you are trying to connect to.

    Tim

  • RELEVANCY SCORE 4.19

    DB:4.19:Intermittent Ora-12571: Tns:Packet Writer Failure 1d


    OS: Windows Server 2003
    We have 2 servers load balanced and IIS running on them. We have a Web application running on them. Intermittently we get ORA-12571: TNS:Packet writer Failure Parameter Name: Update Database() error at the login page.

    At times it goes away when we try to login the next moment and some times it stays there for 30 - 40 mins.

    Can anybody shed light on this.

    Thanks
    Madhu K.

    DB:4.19:Intermittent Ora-12571: Tns:Packet Writer Failure 1d

    I heard about ORA-12571 errors occuring with certain editions of McAfee virus scan programs.
    Could you disable the Norton software and see if you still continue to get errors?

  • RELEVANCY SCORE 4.19

    DB:4.19:"Ora-12571: Tns: Packet Writer Failure" fc


    I am trying to create a new database instance on Oracle 9.2 server. Get this error message while database creation. Two other database instances that are already created have no such problems. Is this problem related to network performance? Can I change any parameters to get rid of this problem? Please help!

    Thank you.

    DB:4.19:"Ora-12571: Tns: Packet Writer Failure" fc

    The listener service is started ? Are you creating it with the dbca ?

    Joel Prez
    http://www.oracle.com/technology/experts

  • RELEVANCY SCORE 4.16

    DB:4.16:Ora-12571: Tns Packet Writter Failure. z7


    Dear memebers,
    AoA,

    i want to connect a database 10g server from a client computer. i installed the developer 6i and make the following changes in tnsnames.ora.

    ORACLE = (DESCRIPTION =

    (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip address of the server)(PORT = 1521))

    )(CONNECT_DATA =(SERVICE_NAME = XE)

    )

    )

    but when i try to connect it give the following error:

    ora-12571: TNS packet writter failure.

    What's the problem?

    Regards:

    Muhammad Nadeem

    DB:4.16:Ora-12571: Tns Packet Writter Failure. z7

    Dear memebers,
    AoA,

    i want to connect a database 10g server from a client computer. i installed the developer 6i and make the following changes in tnsnames.ora.

    ORACLE = (DESCRIPTION =

    (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip address of the server)(PORT = 1521))

    )(CONNECT_DATA =(SERVICE_NAME = XE)

    )

    )

    but when i try to connect it give the following error:

    ora-12571: TNS packet writter failure.

    What's the problem?

    Regards:

    Muhammad Nadeem

  • RELEVANCY SCORE 4.14

    DB:4.14:Tns:Packet Writer Failure. p3


    Hello,
    While creating Database through Oracle Database Configurator Assitance, I get ORA-12571:TNS:Packet writer Failure.

    What could be the reason ?
    Is there any Setup related issue?

    Thanx in advance,

    Pritam.

    DB:4.14:Tns:Packet Writer Failure. p3

    Hello,
    While creating Database through Oracle Database Configurator Assitance, I get ORA-12571:TNS:Packet writer Failure.

    What could be the reason ?
    Is there any Setup related issue?

    Thanx in advance,

    Pritam.

  • RELEVANCY SCORE 4.14

    DB:4.14:Ora-12571: Tns:Packet Writer Failure While Calling Procedure From Vc++ kf


    hi all,
    i am writing stored procedures and calling these from vc++. I have one stored procedure in that all
    in and out perameters are numeric. When i am calling these procedure i am able to get the values properly. But in another procedure one in perameter is varchar and one out perameter is varchar. When i am calling these procedure from vc++ the error i am getting is "ORA-12571: TNS:packet writer failure". I test my vc++ code on different computers but its giving the same errors. I think ora-12571 error is when i can't communicate with oracle. But other stored procedures(in and out perameters are numbers) and sql statements are running properly. Only these stored procedure which has in and out perameters as varchar is giving me the above said problem. My out perameter in this procedure strtax is of type varchar and the length 100. Is it the problem. Please suggest me how to over come this problem.
    thanks in advance,
    with regards
    vali.

    DB:4.14:Ora-12571: Tns:Packet Writer Failure While Calling Procedure From Vc++ kf

    hi all,
    i am writing stored procedures and calling these from vc++. I have one stored procedure in that all
    in and out perameters are numeric. When i am calling these procedure i am able to get the values properly. But in another procedure one in perameter is varchar and one out perameter is varchar. When i am calling these procedure from vc++ the error i am getting is "ORA-12571: TNS:packet writer failure". I test my vc++ code on different computers but its giving the same errors. I think ora-12571 error is when i can't communicate with oracle. But other stored procedures(in and out perameters are numbers) and sql statements are running properly. Only these stored procedure which has in and out perameters as varchar is giving me the above said problem. My out perameter in this procedure strtax is of type varchar and the length 100. Is it the problem. Please suggest me how to over come this problem.
    thanks in advance,
    with regards
    vali.

  • RELEVANCY SCORE 4.13

    DB:4.13:Ora-12571: Tns:Packet Writer Failure Error In .Net Application 7d


    Hello
     
    I am facing below mentioned error while executing the Oracle stored procedure through .Net application developed in framework 1.1. If I execute the same stored procedure through sql plus I do not get the error.
     
    The error is ORA-12571: TNSacket writer failure
     
    I have carried out the below checks but still could not found the actual reason for the error 
    1) TNS entries  in TNSNAMES.ora are correct
    2) TNSPING works fine
    3) PING to database server works fine
     
    Could anyone please provide the solution for the above issue?
     
    Thanks in advance for help
     
    Regards
    Hemant
     

    DB:4.13:Ora-12571: Tns:Packet Writer Failure Error In .Net Application 7d

    Something in your network may have changed try the link below for known causes of this error.
     
    http://www.dba-oracle.com/t_ora_12571_tns_packet_writer_failure.htm
     

  • RELEVANCY SCORE 4.12

    DB:4.12:Can't Create 8i Database kk


    I have just installed Oracle 8i Enterprise on a Windows 2000 machine using all defaults for a typical installation. At the end of the installation, Net8 is successfully configured and then I follow the prompts for the creation of a database. It errors out during the Database Creation Process when "Initializing Database" with an ORA-12571: TNS: packet writer failure.

    Subsequent attempts to create a new database independently of the installation procedure generate the same error.

    I've tried downloading a new install zip file and installing again, with the same results.

    I'm stuck and would appreciate any assistance.

    Thanks.

    DB:4.12:Can't Create 8i Database kk

    I have just installed Oracle 8i Enterprise on a Windows 2000 machine using all defaults for a typical installation. At the end of the installation, Net8 is successfully configured and then I follow the prompts for the creation of a database. It errors out during the Database Creation Process when "Initializing Database" with an ORA-12571: TNS: packet writer failure.

    Subsequent attempts to create a new database independently of the installation procedure generate the same error.

    I've tried downloading a new install zip file and installing again, with the same results.

    I'm stuck and would appreciate any assistance.

    Thanks.

  • RELEVANCY SCORE 4.11

    DB:4.11:Virtualcenter Won't Restart - Ora-12571 Tns Packet Writer Failure c1



    I have a problem with virtualcenter. I needed to reboot the server and now the virtualserver service refuses to start.

    When I read the virtualcenter log file, I get the following;-

    [2011-03-04 16:29:03.488 'App' 5608 error] ODBC error: (08S01) - [Oracle][ODBC][Ora]ORA-12571: TNS:packet writer failure

    [2011-03-04 16:29:03.488 'App' 5608 error] Failed to intialize VMware VirtualCenter. Shutting down...

    If I test the connection under ODBC settings, I get exactly the same error [jpg attached]

    has anyone seen this before?

    DB:4.11:Virtualcenter Won't Restart - Ora-12571 Tns Packet Writer Failure c1


    Are you running in archive mode? If so, you might want to look at controlling how long your retention policy is.

  • RELEVANCY SCORE 4.08

    DB:4.08:Tns-12571: Tns:Packet Writer Failure 1j


    Hi

    I am using Reports 6i in client/server environment. In one workstation (HP notebook with Windows XP) we receive TNS-12571: TNS:packet writer failure when trying to connect to database. We test this against different Oracle database versions (8i, 9i, 10g) on two different network environments - the result is the same. On the same computer we have installed 10g client and it connect successfully to the databases.
    Have someone experience with such problem?

    10x

    DB:4.08:Tns-12571: Tns:Packet Writer Failure 1j

    It could be that you timeout setting in your network for the idle time.

    make, you dont have such.

    jaffar

  • RELEVANCY SCORE 4.08

    DB:4.08:Error Ora-12571 Tns:Packet Writer Failure 33


        

    DB:4.08:Error Ora-12571 Tns:Packet Writer Failure 33

    Hi,I do not see which Oracle Client version you use.Could you make sure that you installed the latest patch for Oracle Client?RegardsRyszard Gawron [MSFT]
    „This posting is provided AS IS with no warranties, and confers no rights.”

  • RELEVANCY SCORE 4.07

    DB:4.07:Tns-12571 Tns: Packet Writer Failure dk


    Hi guys
    I m running oracle client on WIN-XP and when i execute TNSPING80 prod I got the error.
    How i can solve my prob

    DB:4.07:Tns-12571 Tns: Packet Writer Failure dk

    Hi guys
    I m running oracle client on WIN-XP and when i execute TNSPING80 prod I got the error.
    How i can solve my prob

  • RELEVANCY SCORE 4.04

    DB:4.04:Oracle 9i Install Prob. kk


    Hi to all

    i have a problem with oracle 9i.

    previously it show error while i try to connect to database.finally i uninstalled oracle,clear reg keys,removed folder.

    restart the system and trying to install .but at the end of the installation it shows error:
    "ORA-12571 TNS: packet writer failure"

    how to solve this???and what is the problem???is there any problem with setup files???pls give the solution.

    DB:4.04:Oracle 9i Install Prob. kk

    i'm trying 2 reinstall .i'l let u know after this.....

  • RELEVANCY SCORE 3.88

    DB:3.88:Tns-12571: Tns:Packet Writer Failure ???? 1d


    Hi All,

    I have Problem with Connection used TCP/IP..

    This is log connection from file sqlnet.log :

    ***********************************************************************
    Fatal NI connect error 12571, connecting to:
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=donlee)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD)(CID=(PROGRAM=C:\Program Files\Quest Software\TOAD\TOAD.exe)(HOST=DONLEE)(USER=dodon))))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 - Production
    Time: 25-APR-05 10:58:25
    Tracing not turned on.
    Tns error struct:
    nr err code: 0
    ns main err code: 12571
    TNS-12571: TNS:packet writer failure
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

    And this is from TNSNAMES.ORA :
    PROD =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = donlee)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = PROD)
    )
    )

    and this from LISTENER.ORA:
    # C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:C:\Oracle\Ora81\network\admin\listener.ora
    # Generated by Oracle Net8 Assistant

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = donlee)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = PROD)
    (ORACLE_HOME = C:\Oracle\Ora81)
    (SID_NAME = PROD)
    )
    )

    ..................................

    Please help me about this.

    Many Thanks
    Dodon
    Leading8

    DB:3.88:Tns-12571: Tns:Packet Writer Failure ???? 1d

    Hi All,

    I have Problem with Connection used TCP/IP..

    This is log connection from file sqlnet.log :

    ***********************************************************************
    Fatal NI connect error 12571, connecting to:
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=donlee)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD)(CID=(PROGRAM=C:\Program Files\Quest Software\TOAD\TOAD.exe)(HOST=DONLEE)(USER=dodon))))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 - Production
    Time: 25-APR-05 10:58:25
    Tracing not turned on.
    Tns error struct:
    nr err code: 0
    ns main err code: 12571
    TNS-12571: TNS:packet writer failure
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

    And this is from TNSNAMES.ORA :
    PROD =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = donlee)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = PROD)
    )
    )

    and this from LISTENER.ORA:
    # C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:C:\Oracle\Ora81\network\admin\listener.ora
    # Generated by Oracle Net8 Assistant

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = donlee)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = PROD)
    (ORACLE_HOME = C:\Oracle\Ora81)
    (SID_NAME = PROD)
    )
    )

    ..................................

    Please help me about this.

    Many Thanks
    Dodon
    Leading8

  • RELEVANCY SCORE 3.86

    DB:3.86:Problem During Database Cache Configuration For Oracle9ias 31


    I am experiencing the problem .
    When I start database cache configuration it proceeds upto 16% then it messages

    Configuring the Cache

    Unable to start NT service.
    reason : ora-12571 packet writer error;

    For your information I have checked all pre-requisition.

    What can I do ?

    Please help me

    Thanks

    BASHAR

    DB:3.86:Problem During Database Cache Configuration For Oracle9ias 31

    The DB Cache has been discontinued. This forum is for the Web Cache. Please repost your question on one of the DB forums.

  • RELEVANCY SCORE 3.84

    DB:3.84:Oracle On Windows Xp 37


    I installed Oralce 8.1.7 and 9.0.1 on Windows XP, and was successful, but when I create new database (using database configuration assistant), it failed, always have error, like ora-03113 TNS:End of file on Communication Channel, ora-12571: TNS: Packet Writer Failure, ora-12560: TNS: Protocol Adapter Error, or TNS-12154:TNS:Could Not Resolve Database Name. Could somebody can help me to solve this problem, I have no idea about this!
    Thanks!
    Mars Liu

    DB:3.84:Oracle On Windows Xp 37

    You need XP pro.
    the setup.exe didn't work on mine, so I just navigated to the autorun file.

  • RELEVANCY SCORE 3.84

    DB:3.84:Ora-12571: Tns:Packet Writer Failure zm


    Hi,
    I have this error all night between 08 pm and 06am.
    It's impossible to connect at the database for a short duration but many times.

    The listener is up, in the alert.log no error.

    Thanks for your help

    DB:3.84:Ora-12571: Tns:Packet Writer Failure zm

    IS it happening daily

    If not

    I think your Db server network is unplugged

  • RELEVANCY SCORE 3.84

    DB:3.84:Ora-12571 Tns Packet Writer Failure --Urgent Help Required 3x



    I'm facing ORA-12571 TNS PACKET WRITER FAILURE error

    Platform is windows 2000/ tomcat / appache server / oracle 8.1.7

    This is not frequently happening. When the load increases, I'm facing this error? What type of parameters should I concentrate.

    DB is running on MTS.

    It is urgent.

    Could anyone throw some light on it?

    DB:3.84:Ora-12571 Tns Packet Writer Failure --Urgent Help Required 3x

    This question probably best belongs on the General database forum.

  • RELEVANCY SCORE 3.84

    DB:3.84:Ora-12571: Tns:Packet Writer Failure (Fwsm) zk



    Hi,

    We are currently facing user login error mentioned in the Oracle client log below.

    Topology: WebService (FWSM-DMZ)- Oracle Database (FWSM-INSIDE)

    The webservice fails to make full SQLNet connection to the database. But on subsequent attempt it goes through. I can recreate the error by doing 'clear local-host (on all source/destination IPs)' and doing user login again via web portal. SQLNet inspection was earlier disabled on FWSM. Later I enabled SQLNet inspection but still the same error. Most of the discussions related to ORA-12571 points to enabling fix-up/inspection of Oracle 1521 port.

    I ran a capture on FWSM while below mentioned error occured, but I couldn't notice any non-SQLNet (other than 1521) communication initiated to the database. The error seems to be network related though.

    Have you experienced this error ? What would you suggest ?

    Oracle.DataAccess.Client.OracleException ORA-12571: TNS:packet writer failure at Datel.Eform.DataAccess.Portal.UserMgt.ValidateUserDA.ValidateUserLogin

    DB:3.84:Ora-12571: Tns:Packet Writer Failure (Fwsm) zk


    After further checking, I can see that presence/absence of sqlnet inspection has no effect on this.

    However, something to do with connection table state.

    If I clear local-host 'database server' and try login via web portal, the ORA-12571 exception takes place and on 'sh conn' a new connection is seen with status 'UBOI'. When I try login again, the connection goes through. So, due to the presence of earlier connection entry with UBOI, all subsequent logins work successfully. This scenario is consistent.

    Any hints?

  • RELEVANCY SCORE 3.83

    DB:3.83:Tns-12571 9j


    I am using Oracle 8.1.5.0.0 on win NT 4. The size of the database is approx.6GB with a free space of approx. 1.9 GB (NOW)on that disk and the same is running fine from past 2 years.

    The free space came to 107 kb when i got the following error
    was reported:

    ora-12571 tns packet writer failure
    -----------------------------------

    After which the following activities have been done

    From the control panel- services

    step 1:
    started oracle service
    step 2:
    started listener service

    From dos prompt
    step 1:
    svrmgrl
    step 2:
    connect internal
    step 3:
    startup

    Result:
    1. Database is mounted and opened normally
    but
    any subsequent statement leads to
    ora-12571 tns packet writer failure
    followed by ora-03114 not connected to oracle.

    Can any body pl...help?
    Thanx in advance.
    instance is forced to shutdown
    and the following error message is displayed.

    DB:3.83:Tns-12571 9j

    Hi All,
    ORA-12571 is a network error. Whenever network is heavily loaded ORACLE throws this error. This is a bug in win NT 4. Check which service pack are you using.
    This bug is been succesfully corrected by MICROSOFT and service pack has been released. Try to get service pack 6a. This service pack is released after service pack 6. This service pack will get from MICROSOFT website.

    I was also getting this error but everything calm.
    I recommended this to my SYS ADMIN and network guy done accordingly.

    I think it will definately solve your problem. For any query can contact me on goel_sumeet@yahoo.com.

    Friendly yours
    Sumeet Goel.

  • RELEVANCY SCORE 3.82

    DB:3.82:Ora-12571 : Tns:Packet Writer Failure jc


    urgent request

    i ahve a database10G R2 i'm already install it and configration services
    it's work fine and i can log on to database SQL

    and i have oracle developer6I not accepted connect to database
    and back this message ORA-12571 : TNS:Packet writer failure
    manual and wizard configration

    any body can help me to solve this problem

    thanks in advance for all

    DB:3.82:Ora-12571 : Tns:Packet Writer Failure jc

    I have the same error. I have three Oracle homes on an XP SP2 machine. I can connect via any tool in the 9i or 10g homes, but all tools in the Orant home (ADI, Discoverer 4.x) fail with Ora-12571.

    I am able to tnsping, but no sqlnet connection is allowed.

    I have changed the sqlnet.ora file from nts to none, run winsock fix and lsp fix. still not working

  • RELEVANCY SCORE 3.81

    DB:3.81:9i Installation Error-Ora:12571 1m


    I am installing oracle 9i on windows 2000 professional.
    While configuring database creation and configuration tools it gives following error
    ora-12571 TNS: Packet Writer failure.
    After that i cant connect to any instance of oracle in sql* plus also.
    Can Any one help me to resolve it

    DB:3.81:9i Installation Error-Ora:12571 1m

    I'm facing the same problem with Win XP Professional...
    Anybody can suggest us something to try ?

  • RELEVANCY SCORE 3.69

    DB:3.69:Packet Writer Failure 99


    Hi,

    I am experiencing the following error on a Oracle client PC:
    ORA-12571 : TNS Packet Writer Failure. The client PC cannot access any Oracle database, even by using Sql.
    The networking environment seems to be 100 % OK.
    Analysing the listener trace on the server did not help, nor did re-installing the Oracle client.

    Any idea about the problem ?

    Many thanks
    Christian

    DB:3.69:Packet Writer Failure 99

    Hi Christian,

    Could you identify that issue?
    I have the same problem, but without any network connection. (stand alone server as testarea)

    reagards
    Holm

  • RELEVANCY SCORE 3.69

    DB:3.69:Tns-12571 Error From Reports6i kp


    Hi

    I am using Reports 6i in client/server environment. In one workstation (HP notebook with Windows XP) we receive TNS-12571: TNS:packet writer failure when trying to connect to database. We test this against different Oracle database versions (8i, 9i, 10g) on two different network environments - the result is the same. On the same computer we have installed 10g client and it connect successfully to the databases.
    Have someone experience with such problem?

    10x

    DB:3.69:Tns-12571 Error From Reports6i kp

    Hi

    I am using Reports 6i in client/server environment. In one workstation (HP notebook with Windows XP) we receive TNS-12571: TNS:packet writer failure when trying to connect to database. We test this against different Oracle database versions (8i, 9i, 10g) on two different network environments - the result is the same. On the same computer we have installed 10g client and it connect successfully to the databases.
    Have someone experience with such problem?

    10x

  • RELEVANCY SCORE 3.69

    DB:3.69:Ora-12571: Tns:Packet Writer Failure 3a


    Sqldeveloper : win xp
    Version : 2.1.0.63

    Oracle db: 10.2.0.4
    OS : solaris

    Issue : I am trying compile a plsql package which is of 54KB. when I am trying to compile to get the errors. I am getting

    CREATE OR REPLACE PACKAGE BODY PACK_POR0575
    *
    ERROR at line 1:
    ORA-12571: TNS:packet writer failure

    Even I am trying to execute from sqlplus client from the xp machine.

    SQL @ c:\anir\pbpor0575.sql
    1120 /
    CREATE OR REPLACE PACKAGE BODY PACK_POR0575
    *
    ERROR at line 1:
    ORA-12571: TNS:packet writer failure

    However When I tried to run the same on the server, It was working fine. How to resolve this what could be the reason ? is there any size limit ?

    if you have already faced such issue pl give the steps how to resolve this.

    thanks in advance

    DB:3.69:Ora-12571: Tns:Packet Writer Failure 3a

    As it isn't isolated to the tool, you'd get more response in the Database - General forum.

    Regards,
    K.

  • RELEVANCY SCORE 3.67

    DB:3.67:Tns Packet Writer Failure c1


    When I try to install Oracle 9.2.0.1.0 on windows 2000 advance serever i am getting an error message "ORA-12571 TNS:packet writer failure". This is hapening while configuration the database. How can i slow this.

    DB:3.67:Tns Packet Writer Failure c1

    Check for TNSListener services in services and ensure that is continousally running.
    Check for Oracle database is running or not.
    Check for oracle related services in services box.All services realted to oracle must be start.

    Nikhil
    Vadodara

  • RELEVANCY SCORE 3.62

    DB:3.62:Fail To Connect Db From Form Builder mc


    Hi All,

    I am now taking the Developer Course Forms 6i. When I try to connect to the DB in
    Form Builder, the following error occurs and I fail to connect to the DB.

    ORA-12571: TNS: Packet Writer Fail

    I can connect to the DB before and really don't know what has happened.
    Could anyone here tell me the problem and solve the problem?

    Thanks in advance.

    Joey

    null

  • RELEVANCY SCORE 3.60

    DB:3.60:Ora-12571: Tns:Packet Writer Failure. 9c


    Hello,
    I have this following regualar error between my primary and DR server, the error is:
    ORA-12571: TNS:packet writer failure.
    I turn the sqlnet trace and i found the following error:

    [01-FEB-2010 10:40:25:406] nspsend: plen=1463, type=6
    [01-FEB-2010 10:40:25:406] nttwr: entry
    [01-FEB-2010 10:40:25:437] ntt2err: entry
    [01-FEB-2010 10:40:25:437] ntt2err: soc 9728 error - operation=6, ntresnt[0]=530, ntresnt[1]=53, ntresnt[2]=0
    [01-FEB-2010 10:40:25:437] ntt2err: exit
    [01-FEB-2010 10:40:25:437] nttwr: exit
    [01-FEB-2010 10:40:25:437] nspsend: 0 bytes to transport
    [01-FEB-2010 10:40:25:437] nspsend: transport write error
    [01-FEB-2010 10:40:25:437] nspsend: error exit
    [01-FEB-2010 10:40:25:437] nserror: entry
    [01-FEB-2010 10:40:25:437] nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=530, nt[1]=53, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
    [01-FEB-2010 10:40:25:437] nsdofls: exit (-1)
    [01-FEB-2010 10:40:25:437] nsdo: nsctxrnk=0
    [01-FEB-2010 10:40:25:437] nsdo: error exit
    [01-FEB-2010 10:40:25:437] nioqsn: send failed: bl = 6747454, nicbl = 10485760
    [01-FEB-2010 10:40:25:437] nioqper: error from nioqsn
    [01-FEB-2010 10:40:25:437] nioqper: ns main err code: 12571
    *[01-FEB-2010 10:40:25:437] nioqper: ns (2) err code: 12560*
    *[01-FEB-2010 10:40:25:437] nioqper: nt main err code: 530*
    *[01-FEB-2010 10:40:25:437] nioqper: nt (2) err code: 53*
    *[01-FEB-2010 10:40:25:437] nioqper: nt OS err code: 0*
    *[01-FEB-2010 10:40:25:437] nioqer: entry*
    [01-FEB-2010 10:40:25:437] nioqer: incoming err = 12150
    [01-FEB-2010 10:40:25:437] niomapnserror: entry
    [01-FEB-2010 10:40:25:437] niqme: entry
    [*01-FEB-2010 10:40:25:437] niqme: reporting NS-12571 error as ORA-12571*
    [01-FEB-2010 10:40:25:437] niqme: exit
    [01-FEB-2010 10:40:25:437] niomapnserror: exit
    [01-FEB-2010 10:40:25:437] nioqce: entry
    [01-FEB-2010 10:40:25:437] nioqce: exit
    [01-FEB-2010 10:40:25:437] nioqer: returning err = 12571
    [01-FEB-2010 10:40:25:437] nioqer: exit
    [01-FEB-2010 10:40:25:437] nioqsn: returning error: 12571
    [01-FEB-2010 10:40:25:437] nioqsn: exit
    [01-FEB-2010 10:40:25:437] nioqrs: entry
    [01-FEB-2010 10:40:25:437] nioqrs: state = interrupted (1)
    [01-FEB-2010 10:40:25:437] nscontrol: entry
    [01-FEB-2010 10:40:25:437] nscontrol: cmd=1, lcl=0x0
    [01-FEB-2010 10:40:25:437] nscontrol: normal exit
    [01-FEB-2010 10:40:25:437] nioqsm: entry
    [01-FEB-2010 10:40:25:437] nioqsm: Sending break packet (1)...
    [01-FEB-2010 10:40:25:437] nsdo: entry
    [01-FEB-2010 10:40:25:437] nsdo: cid=0, opcode=67, bl=1, what=17, uflgs=0x100, cflgs=0x3
    [01-FEB-2010 10:40:25:437] nsdo: rank=64, nsctxrnk=0
    [01-FEB-2010 10:40:25:437] nsdo: nsctx: state=8, flg=0x400d, mvd=0
    [01-FEB-2010 10:40:25:437] nsdo: gtn=127, gtc=127, ptn=10, ptc=1463
    [01-FEB-2010 10:40:25:437] nsdofls: entry
    [01-FEB-2010 10:40:25:437] nsdofls: DATA flags: 0x0
    [01-FEB-2010 10:40:25:437] nsdofls: normal exit
    [01-FEB-2010 10:40:25:437] nsdo: sending NSPTMK packet
    [01-FEB-2010 10:40:25:437] nspsend: entry
    [01-FEB-2010 10:40:25:437] nspsend: plen=11, type=12
    [01-FEB-2010 10:40:25:437] nttwr: entry
    [01-FEB-2010 10:40:25:437] ntt2err: entry
    [01-FEB-2010 10:40:25:437] ntt2err: soc 9728 error - operation=6, ntresnt[0]=530, ntresnt[1]=53, ntresnt[2]=0
    [01-FEB-2010 10:40:25:437] ntt2err: exit
    [01-FEB-2010 10:40:25:437] nttwr: exit
    [01-FEB-2010 10:40:25:437] nspsend: 0 bytes to transport
    [01-FEB-2010 10:40:25:437] nspsend: transport write error
    [01-FEB-2010 10:40:25:437] nspsend: error exit
    [01-FEB-2010 10:40:25:437] nsdo: error sending NSPTMK packet
    [01-FEB-2010 10:40:25:437] nserror: entry
    [01-FEB-2010 10:40:25:437] nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=530, nt[1]=53, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
    [01-FEB-2010 10:40:25:437] nsdo: nsctxrnk=0
    [01-FEB-2010 10:40:25:437] nsdo: error exit
    [01-FEB-2010 10:40:25:437] nioqsm: send-break: failed to send break...
    [01-FEB-2010 10:40:25:437] nioqper: error from send-marker
    [01-FEB-2010 10:40:25:437] nioqper: ns main err code: 12571
    [01-FEB-2010 10:40:25:437] nioqper: ns (2) err code: 12560
    [01-FEB-2010 10:40:25:437] nioqper: nt main err code: 530
    [01-FEB-2010 10:40:25:437] nioqper: nt (2) err code: 53
    [01-FEB-2010 10:40:25:437] nioqper: nt OS err code: 0
    [01-FEB-2010 10:40:25:437] nioqsm: exit
    [01-FEB-2010 10:40:25:437] nioqer: entry
    [01-FEB-2010 10:40:25:437] nioqer: incoming err = 12152
    [01-FEB-2010 10:40:25:437] niomapnserror: entry
    [01-FEB-2010 10:40:25:437] niqme: entry
    [01-FEB-2010 10:40:25:437] niqme: reporting NS-12571 error as ORA-12571
    [01-FEB-2010 10:40:25:437] niqme: exit
    [01-FEB-2010 10:40:25:437] niomapnserror: exit
    [01-FEB-2010 10:40:25:437] nioqce: entry
    [01-FEB-2010 10:40:25:437] nioqce: exit
    [01-FEB-2010 10:40:25:437] nioqer: returning err = 12571
    [01-FEB-2010 10:40:25:437] nioqer: exit
    [01-FEB-2010 10:40:25:437] nioqrs: nioqrs: Couldn't send break. returning 12571
    [01-FEB-2010 10:40:25:437] nioqrs: exit
    [01-FEB-2010 10:40:25:437] nioqds: entry
    [01-FEB-2010 10:40:25:437] nioqds: disconnecting...
    [01-FEB-2010 10:40:25:437] nsclose: entry
    [01-FEB-2010 10:40:25:437] nstimarmed: entry
    [01-FEB-2010 10:40:25:437] nstimarmed: no timer allocated
    [01-FEB-2010 10:40:25:437] nstimarmed: normal exit
    [01-FEB-2010 10:40:25:437] nttctl: entry

    I think the interesting part is the one in bold, however i dont know what the hell does mean?
    Any help to avoid this error please?

    OS is windows 2003
    Oracle is 10.2.0.4

    DB:3.60:Ora-12571: Tns:Packet Writer Failure. 9c

    Thank you so much,
    I saw this error when i was running some scripts but i didnt honestly think it is so serious.
    I will update it when i have some answer.

  • RELEVANCY SCORE 3.60

    DB:3.60:Tns : Packet Writer Failure fa


    Hi,

    I have a problem,
    When I try to connect to the database (Oracle8.0.5) at the SQL*PLUS Client I am getting following error message:
    ORA-12571: TNS packet writer failure.

    I ping ip address n it didn't have any errors but when I tnsping it have a same error "TNS packet writer failure".

    I'm sure that no problem at my tnsname.ora n sqlnet.ora

    For information, I have another client don't have this error n run very well whereas have a same network, tnsname n sqlnet.

    Anyone can give me an idea? i'm really need ur help.

    Thanks in advance,

    DB:3.60:Tns : Packet Writer Failure fa

    It could be problem on the database side. Did you try from a different client machine to see if it's just your machine?

    You could do a loopback test on the database machine to see if it's working okay.

    BTW, this is the Forms forum. There might be a better forum for this kind of question.

    Regards,
    Robin Zimmermann
    Forms Product Managment

  • RELEVANCY SCORE 3.54

    DB:3.54:Ora-12571: Tns Packet Writer Failure sc


    Hi everybody,

    Can someone help me to solve this problem: When I try to connect to Oracle DB ver 8.0.5, I receive the ORA-12571 error message.

    In the error documentation, they advise me to contact the Worldwide support.

    Thanks.

    DB:3.54:Ora-12571: Tns Packet Writer Failure sc

    Hi Perez,

    On the server side, I'm using Oracle 8.0.5 version running on Uniware 7.1 as OS
    On the client side, I'm using Oracle 8.05 for NT running on W2K as OS (Operating system).

    Note: Other users do not have the same problem as mine.

    Thanks.

  • RELEVANCY SCORE 3.54

    DB:3.54:Error: Cannot Delete User 78


    I want to delete a user, but nothing do.
    User isn't deleted.When i try this,also an error message appearing,
    'ORA-12571: TNS:packet writer failure'.
    So I must restart the computer. My OS is NT 4.0 SP 4.

    DB:3.54:Error: Cannot Delete User 78

    I want to delete a user, but nothing do.
    User isn't deleted.When i try this,also an error message appearing,
    'ORA-12571: TNS:packet writer failure'.
    So I must restart the computer. My OS is NT 4.0 SP 4.

  • RELEVANCY SCORE 3.54

    DB:3.54:Tns 12571 px


    Hi,

    While trying to connect sql from a client installation on XP HOME o/s laptom i am getting TNS 12571 tns packet write failure error.

    The connection was working fine until some tried the serial network connection between two laptops.

    I am unable to delete the network connection 1934 created during this attempt.

    Its a developer client installation which I reinstalled to solve this problem but it still presist.

    Connection on all the rest machines have no problem its just this one only.

    Any one any suggestion to solve this problem.

    Thanking You

    DB:3.54:Tns 12571 px

    Yes, I did tried the all these option, but no use.

  • RELEVANCY SCORE 3.52

    DB:3.52:Ora-12547 Tns Lost Contact From Mssql Openquery 19


    I have a 9.2.0.1 database running on windows 2003 server. I created a linked server on another mssql 2012 using 11g 64bit client. I run a job on the mssql server using openquery connect to oracle for checking the connection status every 2 minutes. Then, I found the openquery gets "ora-12547 tns lost contact" error iintermittently. The error occurs few times a day. The query is just to return sysdate "select * from openquery(orc, 'select sysdate from dual')". And some others openquery may get ora-12571 tnd packet writer failure.Can any export instruct me how to resolve this issue?

    DB:3.52:Ora-12547 Tns Lost Contact From Mssql Openquery 19

    I have a 9.2.0.1 database running on windows 2003 server. I created a linked server on another mssql 2012 using 11g 64bit client. I run a job on the mssql server using openquery connect to oracle for checking the connection status every 2 minutes. Then, I found the openquery gets "ora-12547 tns lost contact" error iintermittently. The error occurs few times a day. The query is just to return sysdate "select * from openquery(orc, 'select sysdate from dual')". And some others openquery may get ora-12571 tnd packet writer failure.Can any export instruct me how to resolve this issue?

  • RELEVANCY SCORE 3.49

    DB:3.49:Re: Ora-12571 Tns Packet Writer Failure 3k


    :( any other way aside from this one?or reason may be, why im having this error?

    DB:3.49:Re: Ora-12571 Tns Packet Writer Failure 3k

    Aloha!

    Thanks all for the time and effort give to my issue. I solved if by creating a new Listener with a different port and deleted the the old one. after which i edited the newly created Listener, change the port to the normal 1521 port, and everything works well.

    Once again thank you very much.

    Regards,
    Hades

  • RELEVANCY SCORE 3.49

    DB:3.49:Ora-12571, -01041, -01092 Error Messages 8ipe 8.1.5 99


    I bought a PE licence Oracle 8i 8.1.5 for WinNT. After I installed the database and created some tables, I experienced some problems: I run some SQL queries with SQL*Plus. After a couple of minutes the database became inaccessible: First I got
    Error ORA-12571: TNS:packet writer failure. When I tried to run the same SQL again, I received ORA-01041: Interner Fehler: hostdef-Erweiterung existiert nicht (now it's German: internal error: hostdef-extension doesn't exist). After shutting down SQL*Plus and restarting it, I received ORA-01092: ORACLE instance terminated. Disconnection forced.
    It happens all the time. It'd no problem with the SQL, because the same SQL worked properly before (it was just a select * from table;).
    Who can help?
    I'm not sure, whether this is the right discussion forum, but didn't find a better one.

    Best regards,

    Dirk

    DB:3.49:Ora-12571, -01041, -01092 Error Messages 8ipe 8.1.5 99

    I bought a PE licence Oracle 8i 8.1.5 for WinNT. After I installed the database and created some tables, I experienced some problems: I run some SQL queries with SQL*Plus. After a couple of minutes the database became inaccessible: First I got
    Error ORA-12571: TNS:packet writer failure. When I tried to run the same SQL again, I received ORA-01041: Interner Fehler: hostdef-Erweiterung existiert nicht (now it's German: internal error: hostdef-extension doesn't exist). After shutting down SQL*Plus and restarting it, I received ORA-01092: ORACLE instance terminated. Disconnection forced.
    It happens all the time. It'd no problem with the SQL, because the same SQL worked properly before (it was just a select * from table;).
    Who can help?
    I'm not sure, whether this is the right discussion forum, but didn't find a better one.

    Best regards,

    Dirk

  • RELEVANCY SCORE 3.48

    DB:3.48:Ora-12571 : Tns Packet Writer Failer sd


    Hello, First, I'm french so my english isn't very good.

    I try to update Oracle 8.1.7 database installed on Linux by using ORAOLEDB.Oracle provider ADO in VB Application.
    In some case, I have the error in the subject of mail.

    The difference on update work or update fail change with the number of columns updated.
    These columns are not specifics : varchar2(255).

    I don't see where is the problem.
    Thnak You for all idea.

    DB:3.48:Ora-12571 : Tns Packet Writer Failer sd

    Hello, First, I'm french so my english isn't very good.

    I try to update Oracle 8.1.7 database installed on Linux by using ORAOLEDB.Oracle provider ADO in VB Application.
    In some case, I have the error in the subject of mail.

    The difference on update work or update fail change with the number of columns updated.
    These columns are not specifics : varchar2(255).

    I don't see where is the problem.
    Thnak You for all idea.

  • RELEVANCY SCORE 3.47

    DB:3.47:Ora-12571: Tns:Packet Writer Failure sp


    --
    Dear all,
    this may have been mentioned, but the site only seems to show
    recent postings... My local machine is RedHat 5.2, the remote
    machine is Solaris 2.5.1 running oracle 7.1.6.2.0 (I installed
    an old "try before buy" CD for this demo...)

    If I try to connect to it using sql*plus then I get a packet
    writer failure :-(

    % TWO_TASK=firstdb sqlplus system/XXXXX

    SQL*Plus: Release 8.0.5.0.0 - Production on Sat Nov 21 14:22:25
    1998

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    ERROR:
    ORA-12571: TNS:packet writer failure

    Enter user-name:

    I've tried relinking sqlplus without libclntsh but the error
    remains. I get a different error if I use full syntax..

    % sqlplus www_user/XXXXX@firstdb

    SQL*Plus: Release 8.0.5.0.0 - Production on Sat Nov 21 14:34:21
    1998

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    ERROR:
    ORA-01034: ORACLE not available

    The database is up...

    But I can connect OK with svrmgrl, showing the tnsnames is OK.

    % TWO_TASK=firstdb svrmgrl

    Oracle Server Manager Release 3.0.5.0.0 - Production

    (c) Copyright 1997, Oracle Corporation. All Rights Reserved.

    Oracle7 Server Release 7.1.6.2.0 - Production Release
    With the distributed, replication and parallel query options
    PL/SQL Release 2.1.6.2.0 - Production

    SVRMGR connect system/XXXXX
    Connected.
    SVRMGR select * from v$database;
    NAME CREATED LOG_MODE CHECKPOINT ARCHIVE_CH
    --------- -------------------- ------------ ---------- ----------
    FIRSTDB 11/19/98 15:27:39 NOARCHIVELOG 6983 6918
    1 row selected.
    SVRMGR

    Any ideas? Feel free to mail me directly, and I'll try and
    summarise the discussions, if you think this is best.

    Thanks!

    Rgds
    Stephen
    null

    DB:3.47:Ora-12571: Tns:Packet Writer Failure sp

    What worked for me (in a slightly different environment) was to comment out the SQLNET.AUTH_SERVICES line in the sqlnet.ora file.

    This fix was originally found in: http://technet.oracle.com:89/ubb/Forum1/HTML/002993.html

    BLOCKQUOTEfont size="1" face="Verdana, Arial"quote:/fontHROriginally posted by Stephen Harris (sweh@mpn.com):
    --
    Dear all,
    this may have been mentioned, but the site only seems to show
    recent postings... My local machine is RedHat 5.2, the remote
    machine is Solaris 2.5.1 running oracle 7.1.6.2.0 (I installed
    an old "try before buy" CD for this demo...)

    If I try to connect to it using sql*plus then I get a packet
    writer failure :-(

    % TWO_TASK=firstdb sqlplus system/XXXXX

    SQL*Plus: Release 8.0.5.0.0 - Production on Sat Nov 21 14:22:25
    1998

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    ERROR:
    ORA-12571: TNS:packet writer failure

    Enter user-name:

    I've tried relinking sqlplus without libclntsh but the error
    remains. I get a different error if I use full syntax..

    % sqlplus www_user/XXXXX@firstdb

    SQL*Plus: Release 8.0.5.0.0 - Production on Sat Nov 21 14:34:21
    1998

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    ERROR:
    ORA-01034: ORACLE not available

    The database is up...

    But I can connect OK with svrmgrl, showing the tnsnames is OK.

    % TWO_TASK=firstdb svrmgrl

    Oracle Server Manager Release 3.0.5.0.0 - Production

    (c) Copyright 1997, Oracle Corporation. All Rights Reserved.

    Oracle7 Server Release 7.1.6.2.0 - Production Release
    With the distributed, replication and parallel query options
    PL/SQL Release 2.1.6.2.0 - Production

    SVRMGR connect system/XXXXX
    Connected.
    SVRMGR select * from v$database;
    NAME CREATED LOG_MODE CHECKPOINT ARCHIVE_CH
    --------- HR/BLOCKQUOTE

    null

  • RELEVANCY SCORE 3.46

    DB:3.46:Ora-12571 aa


    Hi,
    I am getting ORA-12571 TNS packet writer failure.
    what could be the reason ?
    Thanks,
    Radhika.

    DB:3.46:Ora-12571 aa

    What is your operating system? Could you post your 'listener.ora', 'tnsnames.ora' and 'sqlnet.ora' files?

  • RELEVANCY SCORE 3.46

    DB:3.46:Ora-12571 Tns Packed Write Failure 91


    I have a problem when I install Oracle 8i client in all workstation. I'm try connect to server through of sqplplus or any programs that use oracle and have this error "ORA-12571 TNS Packed Write failure". I'm install oracle client in DELL Optiplex GX620.

    Thanks for advance....

    Daniel

    DB:3.46:Ora-12571 Tns Packed Write Failure 91

    I found the problem. All Workstation had "PANDA" Antivirus, I unistalled this program and the problem disappeared.

    Thanks to all.... I hope that my experience will be useful for you

    Daniel

  • RELEVANCY SCORE 3.45

    DB:3.45:Creating Database Error Ora12571 k7


    I am installing oracle 9i on windows 2000 professional.
    While configuring database creation and configuration tools it gives following error
    ora-12571 TNS: Packet Writer failure.
    Can Any one help me to resolve it
    thx

    DB:3.45:Creating Database Error Ora12571 k7

    I am installing oracle 9i on windows 2000 professional.
    While configuring database creation and configuration tools it gives following error
    ora-12571 TNS: Packet Writer failure.
    Can Any one help me to resolve it
    thx

  • RELEVANCY SCORE 3.44

    DB:3.44:Ora-12571: Tns:Packet Writer Failure a1


    I am running a Filenet application that uses Oracle 805 and I am getting this error. First of all, does anyone know what it means, and second, how can I fix it? My usual fix did not work. Thanks

    DB:3.44:Ora-12571: Tns:Packet Writer Failure a1

    Try enabling SQL*Net tracing and see if anything jumps out there.

    Justin
    Distributed Database Consulting, Inc.
    http://www.ddbcinc.com/askDDBC

  • RELEVANCY SCORE 3.42

    DB:3.42:Ora-12571: Tns: Packet Writer Failure? ms


    We have got a Database 10g server on hardware server 10g client on two client pc's on the same network.

    when I want to test connection to Database on client pc A with net manager, I receive the error
    "ORA-12571: TNS: packet writer failure?"

    when I want to test connection to Database on client pc B with net manager, I receive the error
    "Access to this protocol (SQL Net) or site restricted at this time?"

    could you help me?
    regards
    Seyavoush

    DB:3.42:Ora-12571: Tns: Packet Writer Failure? ms

    Yes, I'm sure, 10g database is running on server, I checked it from localhost:5500/em and SQL/Plus and running a query from a web application,
    ....

  • RELEVANCY SCORE 3.41

    DB:3.41:Ora-12571: Tns:Packet Writer Failure cs


    Sqldeveloper : win xp
    Version : 2.1.0.63

    Oracle db: 10.2.0.4
    OS : solaris

    Issue : I am trying compile a plsql package which is of 54KB. when I am trying to compile to get the errors. I am getting

    CREATE OR REPLACE PACKAGE BODY PACK_POR0575
    *
    ERROR at line 1:
    ORA-12571: TNS:packet writer failure

    Even I am trying to execute from sqlplus client from the xp machine.

    SQL @ c:\anir\pbpor0575.sql
    1120 /
    CREATE OR REPLACE PACKAGE BODY PACK_POR0575
    *
    ERROR at line 1:
    ORA-12571: TNS:packet writer failure

    However When I tried to run the same on the server, It was working fine. How to resolve this what could be the reason ? is there any size limit ?

    if you have already faced such issue pl give the steps how to resolve this.

    thanks in advance

  • RELEVANCY SCORE 3.41

    DB:3.41:Ora-12571: Tns:Packet Writer Failure ps


    hi everybody
    i am using oracle 8i and report 6i
    all user accessing server. server is running properly
    but on of them user getting problem as ORA-12571: TNS:packet writer failure
    i reinstall report runtime on this user's machine but problem still there
    can anybody help me what is prob.
    need ur help
    with thanx

    DB:3.41:Ora-12571: Tns:Packet Writer Failure ps

    User is unable to access the database. Check user access in SQL*Plus on that machine. Run Net Manager on machine to create the link to the database.
    HTH!!

  • RELEVANCY SCORE 3.39

    DB:3.39:Ora-12571: Tns:Packet Writer Failure ca


    We perform a cold backup (shutdown the instance, backup files to tape, then restart the instance) every weekend. Every Monday morning the first .NET application that uses ODP produces an "ORA-12571: TNS:packet writer failure" error. When the same application executes again (or any other ODP application), the error does not appear.

    We are using version 9.2.0.2.102 of ODP. Is this a known issue and is there a fix for it?

    DB:3.39:Ora-12571: Tns:Packet Writer Failure ca

    You can call ClearPool or ClearAllPools on the connection object, which will recycle your pool. Most admins call this after they bounce the DB.

    The other solution is to use RAC with Fast Connection Failover by setting HA Events = true in the connection pool. You must have RAC to use this attribute.

  • RELEVANCY SCORE 3.37

    DB:3.37:Nt 4.0 Sp6 Workstation; Dca Failure On Installation; Please Help. az


    Hi folks, I'm on NT 4.0 SP6 and I'm trying to install the Personal Edition of Oracle 9i with General Purpose database and the Database Configuration Assistant displays error "ORA-12571: TNS PACKET WRITER FAILURE".

    I've read a lot here in the installation forum; I've tried installing from the /install/win32/setup.exe, I've
    tried different database types, running the DCA standalone after the install, and I still get this error.
    Later I tried the unistall procedures and still can't get a successful installation with database. I've had a post out here for a week and I haven't gotten any response.

    I beleive my system specs are adequate, ie. disc space, memory, cpu, etc...;

    Also, in the beginning of the install it tells me that I should have MTS (Microsoft Transaction Server) installed. Is this true? Do I really need MTS for a 'personal edition', non-networked version of 9i?

    Can anyone help me solve this problem?

    Additionally:
    I saw someone respond that Personal Edition was only for
    Windows 98. I don't beleive that this is true. I know folks that have it installed on XP and 2000, as well as 98.

    There seem to be a lot of problems with DCA posted in the installation forum. Why doesn't Oracle fix it so it works right?

    Many thanks for this forum.
    - G. Redding

    DB:3.37:Nt 4.0 Sp6 Workstation; Dca Failure On Installation; Please Help. az

    Hi folks, I'm on NT 4.0 SP6 and I'm trying to install the Personal Edition of Oracle 9i with General Purpose database and the Database Configuration Assistant displays error "ORA-12571: TNS PACKET WRITER FAILURE".

    I've read a lot here in the installation forum; I've tried installing from the /install/win32/setup.exe, I've
    tried different database types, running the DCA standalone after the install, and I still get this error.
    Later I tried the unistall procedures and still can't get a successful installation with database. I've had a post out here for a week and I haven't gotten any response.

    I beleive my system specs are adequate, ie. disc space, memory, cpu, etc...;

    Also, in the beginning of the install it tells me that I should have MTS (Microsoft Transaction Server) installed. Is this true? Do I really need MTS for a 'personal edition', non-networked version of 9i?

    Can anyone help me solve this problem?

    Additionally:
    I saw someone respond that Personal Edition was only for
    Windows 98. I don't beleive that this is true. I know folks that have it installed on XP and 2000, as well as 98.

    There seem to be a lot of problems with DCA posted in the installation forum. Why doesn't Oracle fix it so it works right?

    Many thanks for this forum.
    - G. Redding

  • RELEVANCY SCORE 3.37

    DB:3.37:Packet Writer Failure After De-Installation z8


    Yesterday I've installed Oracle 9i release 2 on my Windows 2000 pc. Everything went fine. Then I've installed OWB. Still everything was ok. Then I've installed JDeveloper and the BI Beans. After then, I was not able anymore to start the dB instance. So I've removed everything again, cleaned-up the registry and the file system, and re-installed Oracle 9i, but now I'm not even able to install an instance. I do get the error: TNS-12571 TNS:packet writer failure. And some of the time I've get an "End of communication channel" error (which is anyway one of my most favorites ;-) ) I've even tried to install an 8.1.7. instance but still no success!!The error remains!!!!! What do I have to do now? Format my disc? Buy a new computer? H E L P?

    thank you

    robert

    rkonzelmann@yahoo.de

    DB:3.37:Packet Writer Failure After De-Installation z8

    Thank you for your recommendations. But unfortunatly I've allready done these steps.

    cheers
    Robert

  • RELEVANCY SCORE 3.37

    DB:3.37:Help - Newbie - Getting "Ora-12571: Tns: Packet Writer Failure" Error 9k


    Hi all,

    Not sure where to post this, so trying for the general forum to start...

    I have also searched and read all the forums for help on this already as well the Oracle documentation and anything I could find from several on-line searches, etc.

    I have Oracle 8i Enterprise Edition and Oracle Forms 6i installed on Win2K. Everything worked fine when it was just Oracle 8i running, ie: connecting to the database in SQLPlus Worksheet, but when I try and connect to the database in the datablock wizard in forms I get the ORA-12571: TNS: packet writer failure error!

    Don't tell me to re-install, I've done that like 6 times already. I've check the tnsnames.ora files and tried that fix already. I don't know what else to try short of fdisk and redoing everything from scratch again, but I don't have time for that as this machine is used daily for other tasks.

    Any help or suggestions are appreciated!!!

    Thx in advance!
    Michelle.

    PS: Note to Oracle support staff if you are listening (pardon the pun). Your one line of help for ORA-12571 in the existing support files is rather similar to the Hitchhikers Guide to the Galaxy's info for Earth... After seeing how many people have posted about this problem and how few resources or real answers there are out there, you might want to consider updating the info on this error, because is deserves something more than "mostly harmless"!

    DB:3.37:Help - Newbie - Getting "Ora-12571: Tns: Packet Writer Failure" Error 9k

    Hi all,

    Not sure where to post this, so trying for the general forum to start...

    I have also searched and read all the forums for help on this already as well the Oracle documentation and anything I could find from several on-line searches, etc.

    I have Oracle 8i Enterprise Edition and Oracle Forms 6i installed on Win2K. Everything worked fine when it was just Oracle 8i running, ie: connecting to the database in SQLPlus Worksheet, but when I try and connect to the database in the datablock wizard in forms I get the ORA-12571: TNS: packet writer failure error!

    Don't tell me to re-install, I've done that like 6 times already. I've check the tnsnames.ora files and tried that fix already. I don't know what else to try short of fdisk and redoing everything from scratch again, but I don't have time for that as this machine is used daily for other tasks.

    Any help or suggestions are appreciated!!!

    Thx in advance!
    Michelle.

    PS: Note to Oracle support staff if you are listening (pardon the pun). Your one line of help for ORA-12571 in the existing support files is rather similar to the Hitchhikers Guide to the Galaxy's info for Earth... After seeing how many people have posted about this problem and how few resources or real answers there are out there, you might want to consider updating the info on this error, because is deserves something more than "mostly harmless"!

  • RELEVANCY SCORE 3.37

    DB:3.37:9ias, 8i Db On One Linux Box 9d


    I have the following error with the Database Cache Assistant
    Adding users to the cache failed
    Reason: WTE-03503 Error updating list of users : Failed to import users to cache node

    OCI error - ORA-12571: TNS : packet writer failure

    Processing Failed ( It was at 96% )

    null

    DB:3.37:9ias, 8i Db On One Linux Box 9d

    I have the following error with the Database Cache Assistant
    Adding users to the cache failed
    Reason: WTE-03503 Error updating list of users : Failed to import users to cache node

    OCI error - ORA-12571: TNS : packet writer failure

    Processing Failed ( It was at 96% )

    null

  • RELEVANCY SCORE 3.36

    DB:3.36:Connection Error Between Tuexdo And Oracle, Ora-12571:Tns:Packet Writer Failure jz



    When i launch the tmboot and during all the day i can call services without problems
    (Tuxedo 7.1.1 Oracle 8.1.7) but after one night the first call of the day don't
    work, and i get this Oracle Error :
    ORA-12571: TNS:packet writer failure
    I launch the tmsutdown and the tmboot, and it works again, anybody knows this
    problem?
    Please Help Me!
    Thank you very much.

    DB:3.36:Connection Error Between Tuexdo And Oracle, Ora-12571:Tns:Packet Writer Failure jz

    You lost your connection to the instance. Could be a network problem,
    intentional restart of the database, etc. Restarting the servers reconnects
    to the database. You may want to look at another message thread in this
    group on this issue. Has a couple of ideas of how to deal with it. Look for
    "Restart Oracle 8 - Tux 7.1 connections".

    "sorcer" sorcer1@hotmail.com wrote in message
    news:3c68d8f5$1@newsgroups.bea.com...

    When i launch the tmboot and during all the day i can call serviceswithout problems
    (Tuxedo 7.1.1 Oracle 8.1.7) but after one night the first call of theday don't
    work, and i get this Oracle Error :
    ORA-12571: TNS:packet writer failure
    I launch the tmsutdown and the tmboot, and it works again, anybody knowsthis
    problem?
    Please Help Me!
    Thank you very much.

  • RELEVANCY SCORE 3.36

    DB:3.36:Ora-12571: Tns:Packet Writer Failure zf



    Hi,

    I developed an application in .net with oracle client, but it throws this error:

    work on my PC but not on the server, does anyone know who will be? :_|.

    Thanks
    ###################################
    +{color:#ff0000}*ORA-12571: TNS:packet writer failure*+
    +{color}+

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: {color:#ff6600}System.Data.OracleClient{color}.OracleException: ORA-12571: TNS:packet writer failure

    Source Error:

    codeAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below./code
    Stack Trace:

    code{noformat}[OracleException (0x80131938): ORA-12571: TNS:packet writer failure
    ]
    System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) +203
    System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor rowidDescriptor, ArrayList resultParameterOrdinals) +1021
    System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList resultParameterOrdinals) +25
    System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior) +142
    .
    .
    .

    {noformat}/code

    DB:3.36:Ora-12571: Tns:Packet Writer Failure zf

    To resolve the problem just take off the attribute Type="String"

    SelectParameters
    asp:ControlParameter PropertyName="Text" Type="String" Name="COD_REPORTE" ControlID="txtCodReporte"/asp:ControlParameter
    /SelectParameters

  • RELEVANCY SCORE 3.35

    DB:3.35:Oracle On Windows Xp jj


    I installed Oralce 8.1.7 and 9.0.1 on Windows XP, and was successful, but when I create new database (using database configuration assistant), it failed, always have error, like ora-03113 TNS:End of file on Communication Channel, ora-12571: TNS: Packet Writer Failure, ora-12560: TNS: Protocol Adapter Error, or TNS-12154:TNS:Could Not Resolve Database Name. Could somebody can help me to solve this problem, I have no idea about this!
    Thanks!
    Mars Liu

    DB:3.35:Oracle On Windows Xp jj

    Oracle is not supported on WinXP prior to 9.x, except for a special client installation. The special client installation requires a special installer, and not all client products are supported. Details are available on metalink.oracle.com.

  • RELEVANCY SCORE 3.34

    DB:3.34:Ora-12571 Tns : Packet Writter Failure d3


    HI everybody

    I'm a DBA ORACLE 8i
    I installed ORacle 8.1.6 in differents ORacle Home
    I previously installed Discoverer, then I installed ORacle Enterprise Manager 8.1.6.
    The installer configures the listener and tnsnames.
    I use the Net 8 assistant to configure both archives but when I try to test my Names Service, the assistants shows me: Connecting...ORA-12541: TNS:no listener
    The test did not succeed.

    I don't think the problem is Names Service configuration

    Questions:
    Is the listener.ora which is damage o incorrect?
    Is the service Oracletnslistner the real problem?
    Is the database dedicated mode which is causing problems?
    I red the log listener in subdirectory log and I see this information:
    TNS-12571: TNS:packet writer failure
    TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 53: Unknown error
    TNS-12500: TNS:listener failed to start a dedicated server process
    TNS-12571: TNS:packet writer failure
    TNS-12560: TNS:protocol adapter error
    ___________
    NOte: I have Oracle in Windows 2000 platform and SP 4. I was using this platform some days ago and I havt this serious problems.

    THANK YOU VERY MUCH

    David Martinez
    sirdavis@hotmail.com

    DB:3.34:Ora-12571 Tns : Packet Writter Failure d3

    Are you actually USING Oracle Names or just TNSNAMES or host naming ? If you haven't set up Oracle Names [ it is not the default ] then it will not work.

  • RELEVANCY SCORE 3.30

    DB:3.30:Urgent - Ora 12571 Tns: Packet Writer Faliure - Windows Xp ka


    Hi,
    Can anyone help me ?? I have installed Oracle 8i under Windows XP and I am getting the above error. While connecting thru JDeveloper It is giving Network Adapter error.
    Reply Appriciable.
    Thanks in Advance.
    Rajiv

    DB:3.30:Urgent - Ora 12571 Tns: Packet Writer Faliure - Windows Xp ka

    Hi,
    Can anyone help me ?? I have installed Oracle 8i under Windows XP and I am getting the above error. While connecting thru JDeveloper It is giving Network Adapter error.
    Reply Appriciable.
    Thanks in Advance.
    Rajiv

  • RELEVANCY SCORE 3.30

    DB:3.30:Ora 012571 Tns Packet Writer Failure ... ??? d7


    I have installed the Designer 6i and when I attempt to login to the designer application, I am stopped by the error ORA 012571 TNS Packet Writer Failure.

    I have no idea what is causing this error, and therefore can't use the product.

    Looking for any/all help

    Darrell K.

    DB:3.30:Ora 012571 Tns Packet Writer Failure ... ??? d7

    This is from documentation:
    TNS-12571 TNS:packet writer failure

    Cause: An error occurred during a data send. This message is not normally visible to the user.

    Action: For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Customer Support

    Maybe this will be a little help for you.

    Helena

  • RELEVANCY SCORE 3.29

    DB:3.29:Can't Populate Blob... cf


    I'm using VB6, Oracle 8.1.6, The Oracle 8.1.6.2 OLE DB driver and ADO 2.5. I can populate all other fields in the table, but I can only put nulls in the BLOB. This occurs using OraOLEDB.Oracle as the provider.
    I get error: ORA-12571 TNS: Packet Writer Failure.

    But, if I go into Access 97 and link the Oracle table, then open it as an Access recordset, I have no problem writing text data to BLOB. Gotta be a driver problem.

    DB:3.29:Can't Populate Blob... cf

    Since you're using the Oracle OLE DB provider, I'd suggest that you post this question to the OLE DB forum.

    Note that I recently posted code that walks through BLOB and CLOB stuff to this forum-- I believe it contains both ODBC and OLE DB paths...

    Justin Cave
    ODBC Development

  • RELEVANCY SCORE 3.28

    DB:3.28:Your Help Needed, Regarding Fatal Error In Two-Task Server: Error = 12571 9a


    Hellow Sir,
    Please tell me about error 12571. What causes it occur how much hazardous it can proved to me.
    Some part of trace in UDUMP, I am enclosing

    *** 2002.05.30.18.09.34.545
    *** SESSION ID:(55.643) 2002.05.30.18.09.34.515
    FATAL ERROR IN TWO-TASK SERVER: error = 12571
    *** 2002.05.30.18.09.34.545
    ksedmp: internal or fatal error
    Current SQL statement for this session:
    select GRAND_TOTAL,EXAM_GRAND_MARK,RESULT,DIVISION from RA_009_trresults02 where center_code=:1 and roll_number=:2
    ----- Call Stack Trace -----
    and all the data block information followed , about locks, cursors held, library cache etc
    END OF PROCESS STATE
    ----------------------------------------------------------------------------------
    When I gone through the error message documentation, It says
    TNS-12571 TNS:packet writer failure

    Cause: An error occurred during a data send. This message is not normally visible to the user.

    In addition, this message could occur when any of the following SQL*Plus commands have been issued:

    SHUTDOWN ABORT

    SHUTDOWN IMMEDIATE

    SHUTDOWN TRANSACTIONAL

    Action: For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Support Services.

    BUT NO SUCH OPTION IS BEEN TRIED. CAN YOU PLEASE TELL ME WHAT OTHER CAUSES CAN BE, WHICH CAN FORCE IT TO OCCUR.

    Thankyou
    Sumeet

    DB:3.28:Your Help Needed, Regarding Fatal Error In Two-Task Server: Error = 12571 9a

    Hellow Sir,
    Please tell me about error 12571. What causes it occur how much hazardous it can proved to me.
    Some part of trace in UDUMP, I am enclosing

    *** 2002.05.30.18.09.34.545
    *** SESSION ID:(55.643) 2002.05.30.18.09.34.515
    FATAL ERROR IN TWO-TASK SERVER: error = 12571
    *** 2002.05.30.18.09.34.545
    ksedmp: internal or fatal error
    Current SQL statement for this session:
    select GRAND_TOTAL,EXAM_GRAND_MARK,RESULT,DIVISION from RA_009_trresults02 where center_code=:1 and roll_number=:2
    ----- Call Stack Trace -----
    and all the data block information followed , about locks, cursors held, library cache etc
    END OF PROCESS STATE
    ----------------------------------------------------------------------------------
    When I gone through the error message documentation, It says
    TNS-12571 TNS:packet writer failure

    Cause: An error occurred during a data send. This message is not normally visible to the user.

    In addition, this message could occur when any of the following SQL*Plus commands have been issued:

    SHUTDOWN ABORT

    SHUTDOWN IMMEDIATE

    SHUTDOWN TRANSACTIONAL

    Action: For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Support Services.

    BUT NO SUCH OPTION IS BEEN TRIED. CAN YOU PLEASE TELL ME WHAT OTHER CAUSES CAN BE, WHICH CAN FORCE IT TO OCCUR.

    Thankyou
    Sumeet

  • RELEVANCY SCORE 3.27

    DB:3.27:Ora 12571 Tns Packet Writer Failure kj


    hi all,
    i am facing the error ora 12571 tns packet writer failure while login into TOAD.

    can someone plz help me out provide the solution to this.

    thanks

    D

    DB:3.27:Ora 12571 Tns Packet Writer Failure kj

    hi,
    thanks for reply,
    I wanna let u know that this is my personal lappy i have installed apps dump on it in Linux connect it through VM player in Window environment. I have recently purchased a new Antivirus K7 installed it on my Lappy. i wanna know does this impact your application or Dbase Bcoz the application is running fine after starting the services in linux.
    The only thing is that i am not able access the database through TOAD or SQL*Plus. the same error i am facing in both.

    So
    shud i uninstall the antivirus on this And this is the only solution to it ?
    If yes, then how do i fix it again when i'll reinstall it Bcoz i need Antivirus as well.

    kindly suggest.

    thanks
    D

  • RELEVANCY SCORE 3.26

    DB:3.26:Packet Failures - Ora-12571 And Tns-12637 d1


    Hello there -

    I've received several packet type errors for a Remedy application running Oracle 11g. Two of the errors are as follows - ORA-12571: TNS:PACKET WRITER FAILURE and TNS-12637: Packet receive failed. Apparently the DB seems to come down for a few moments and than come back up again. Anyone have any ideas on solutions?

    DB:3.26:Packet Failures - Ora-12571 And Tns-12637 d1

    Anyone have any ideas on solutions?I see Oracle as victim; not culprit.

    bcm@bcm-laptop:~$ oerr ora 12571
    12571, 00000, "TNS:packet 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.
    bcm@bcm-laptop:~$ oerr ora 12637
    12637, 00000, "Packet receive failed"
    // *Cause: A process was unable to receive a packet from another process.
    // Possible causes are:
    // 1. The other process was terminated.
    // 2. The machine on which the other process is running went down.
    // 3. Some other communications error occurred.
    // *Action: If the cause is not obvious, contact Oracle Customer Support.

  • RELEVANCY SCORE 3.25

    DB:3.25:Getting Ora-12571 When Exec Sql At :Conname Rollback Work Release 39


    I am using Pro*C/C++ 9.0.1.1.1 on W2K (VC++ 6).
    I wrote a DLL in which I call

    EXEC SQL CONNECT :username IDENTIFIED BY :password
    AT :conname USING :dbname;

    inside DllMain( ) under case DLL_PROCESS_ATTACH. And I call

    EXEC SQL AT :conname ROLLBACK WORK RELEASE;

    in the same DllMain( ) under case DLL_PROCESS_DETACH.

    Everything works fine and I can do my stuff with the database, except by the
    end when I terminate the program I get ORA-12571 TNS:packet writer failure.
    It happens at the ROLLBACK RELEASE call. It also seems related to the AT
    option since when I tried connect to the default database without using AT,
    there is no error.

    What did I do wrong? I'd appreciate your help.

    Jianying

    DB:3.25:Getting Ora-12571 When Exec Sql At :Conname Rollback Work Release 39

    I am using Pro*C/C++ 9.0.1.1.1 on W2K (VC++ 6).
    I wrote a DLL in which I call

    EXEC SQL CONNECT :username IDENTIFIED BY :password
    AT :conname USING :dbname;

    inside DllMain( ) under case DLL_PROCESS_ATTACH. And I call

    EXEC SQL AT :conname ROLLBACK WORK RELEASE;

    in the same DllMain( ) under case DLL_PROCESS_DETACH.

    Everything works fine and I can do my stuff with the database, except by the
    end when I terminate the program I get ORA-12571 TNS:packet writer failure.
    It happens at the ROLLBACK RELEASE call. It also seems related to the AT
    option since when I tried connect to the default database without using AT,
    there is no error.

    What did I do wrong? I'd appreciate your help.

    Jianying

  • RELEVANCY SCORE 3.24

    DB:3.24:Migrating Sql To Oracle Utilizing Import Export Wizard Problems jk


    Hello,

    I am exporting data from a SQL database to an Oracle DB. Everything was going goog until I tried to export this one table and the import/export wizard just hung for a while then spit out the error below.

    ORA-12571: TNS: packet writer failure.

    I have googled it, but nothing matches this scenario. I am thinking is wrong with the table but i have investigated that as well and it looks fine. Can anyone helpme find this needle in the hay stack especially when I have exported other tables with no problem.

    I am using SQL 2008 import/export wizard
    Oracle 11g

    I am using the .NET Framework Data Provider for Oracle

    Thank You in advance

    Lee

    DB:3.24:Migrating Sql To Oracle Utilizing Import Export Wizard Problems jk

    Hi Lee,
    If you are using .NET Framework to connect to SQL*Server it would be better to follow up in this forum -

    Forum: ODP.NET

    ODP.NET

    where they will have more experience of the product and shoudl be able to help with errors when using it.

    Regards,
    Mike

  • RELEVANCY SCORE 3.23

    DB:3.23:9ias, 8i Db On One Mandrake Linux Box 88


    I have the following error with the Database Cache Assistant
    Adding users to the cache failed
    Reason: WTE-03503 Error updating list of users : Failed to import users to cache node
    OCI error - ORA-12571: TNS : packet writer failure

    Processing Failed ( It was at 96% )
    null

    DB:3.23:9ias, 8i Db On One Mandrake Linux Box 88

    I have the following error with the Database Cache Assistant
    Adding users to the cache failed
    Reason: WTE-03503 Error updating list of users : Failed to import users to cache node
    OCI error - ORA-12571: TNS : packet writer failure

    Processing Failed ( It was at 96% )
    null

  • RELEVANCY SCORE 3.22

    DB:3.22:Listener Very Slow When Listener.Log File Reach 4g Size 7x


    client can't connect to instance,and has some error:
    ----------------------------------------------
    TNS-12560: TNS: Protocol adapter error
    TNS-00530: Protocol adapter error
    64-bit Windows Error: 53: Unknown error
    TNS-12518: TNS: listener could not hand off client connection
    TNS-12571: TNS: packet writer failure
    TNS-12560: TNS: Protocol adapter error
    TNS-00530: Protocol adapter error
    64-bit Windows Error: 54: Unknown error

    I restart the listener,but it is very slow to startup completely.
    I found that the listener.log file is 4G size,when i remove this log file and restart listener,the listener is normal.

    If the log file has a 4G limited by oracle?

    VERSION:
    -------------------------------------------------------------------
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    PL/SQL Release 11.2.0.1.0 - Production
    CORE11.2.0.1.0Production
    TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
    NLSRTL Version 11.2.0.1.0 - Production

  • RELEVANCY SCORE 3.21

    DB:3.21:Ora-12571: Tns:Packet Writer Failure kd


    Dear All,

    I am using oracle 10g on window server 2003 and asp.net as front-end framework 3.5 on window xp.

    i am facing a problem , my connect break from client and they received message "Time out" and from backend on server machine received message "ORA-12571: TNS:packet writer failure".

    Any help , how can i overcome this problem.

    Thanks

    DB:3.21:Ora-12571: Tns:Packet Writer Failure kd

    Unfortunately there's a whole bunch of possible reasons, check on MOS:

    ORA-12151 or ORA-12571 Errors Connecting to Database on Windows [ID 71921.1]

    If this does not help call Oracle support.

    Werner

  • RELEVANCY SCORE 3.20

    DB:3.20:Database Connection Error 18



    hi all...
    i have installed oracle 9i db on win-2k.
    i created one database using oracle
    database configuration assistant.
    when i try to connect to database using
    sqlplus with userid-system, it gives me error -
    ORA-12571: TNS:packet writer failure
    what this cud mean?
    i try to connect with foll. string -
    connect system/manager@nitin
    where nitin is SID for the database.
    if i use db global name in place of SID, then
    err msg is - 'could not resolve service name'.
    pl. throw some light on this.

    thanking in anticipation
    Nitin

    DB:3.20:Database Connection Error 18


    thanx Deepak Justin for yr replies.
    i'll try with the ORACLE_SID env var thing.
    Justin, system/manager allows me to connect
    to default database which is created during install
    time. But i created one db instance using
    database configuration assistant. i'm not able to
    connect to this new database using system/manager.
    i am in a jumbled state cos of this service name/listener/naming method/global database name labyrinth.i'll have to create listeener and servie name
    from the scratch i guess.
    thanx for yr inputs again.

  • RELEVANCY SCORE 3.19

    DB:3.19:Tns Packet Writer Failed kk


    alert log of primary databse ( physical standby environment)

    Mon Apr 26 04:53:09 2010
    ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (12571)
    ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
    Mon Apr 26 04:53:09 2010
    Errors in file c:\oracle\product\10.2.0\admin\prod\bdump\prodmp_arc0_3240.trc:
    ORA-12571: TNS:packet writer failure

    FAL[server, ARC0]: Error 12571 creating remote archivelog file 'TRAXSP'
    FAL[server, ARC0]: FAL archive failed, see trace file.
    Mon Apr 26 04:53:09 2010
    Errors in file c:\oracle\product\10.2.0\admin\prod\bdump\prodmp_arc0_3240.trc:
    ORA-16055: FAL request rejected

    ARCH: FAL archive failed. Archiver continuing

    alert log of standby databse :

    Mon Apr 26 04:53:16 2010
    Media Recovery Log E:\TRAX\ORAARCHIVE\standby\standby_ARC397331_694072247.1
    Media Recovery Waiting for thread 1 sequence 397332
    Error 12154 received logging on to the standby
    FAL[client, MRP0]: Error 12154 connecting to prod for fetching gap sequence
    Mon Apr 26 04:53:22 2010
    Errors in file c:\oracle\product\10.2.0\admin\standby\bdump\standby_mrp0_2992.trc:
    ORA-12154: TNS:could not resolve the connect identifier specified

    Mon Apr 26 04:53:23 2010
    RFS[148]: Possible network disconnect with primary database
    Redo Shipping Client Connected as PUBLIC

    Now, gap sequence is happening at regular interval of times.

    How to solve this gap sequence issue...........

    for better clarification: log shipping is happening properly at sometimes.. around 10 , 20, etc.. files were not shipped to standby location.

    so how to overcome this problem........

    can anyone..... come forword to help me out on.... this......... (plz keep in mind this production not test environment)...

    DB:3.19:Tns Packet Writer Failed kk

    Hi, I see alert.log of both database and think there is a problem on standby side

    "FAL[client, MRP0]: Error 12154 connecting to prod for fetching gap sequence
    Mon Apr 26 04:53:22 2010
    Errors in file c:\oracle\product\10.2.0\admin\standby\bdump\standby_mrp0_2992.trc:
    ORA-12154: TNS:could not resolve the connect identifier specified"

    This error indicated that oracle process can not connect from standby side to production (primary) side.
    Resolve this problem.Are you change most rescently tnsnames.ora or sqlnet.ora file from standby host?

  • RELEVANCY SCORE 3.19

    DB:3.19:Ora-12571: Tns:Packet Writer Failure - Occurs Only The First Time pf


    Hi

    We are using Oracle 9i database for an ASP.NET 2.0 application . ODP.NET (9.2.0.401) is used to connect to the Oracle DB.

    The application is load balanced between two web servers. Web servers are Windows 2003 servers with SP2 , IIS V 6.0

    I get the following error when i access the application using the load balanced url for the first time.

    I get this ORA-12571: TNS:packet writer failure error only for the first time when i access the application using the url. It works fine if i access the SAME url after that.

    An error has occurred in page http://Loadbalancedurl/AppName/Main.aspx
    Exception of type 'System.Web.HttpUnhandledException' was thrown.
    at System.Web.UI.Page.HandleError(Exception e)
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    at System.Web.UI.Page.ProcessRequest()
    at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
    at System.Web.UI.Page.ProcessRequest(HttpContext context)
    at ASP.main_mainscrn_aspx.ProcessRequest(HttpContext context)
    at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean completedSynchronously)
    Oracle.DataAccess.Client.OracleException ORA-12571: TNS:packet writer failure at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
    at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
    at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)

    How to solve TNS:packet writer failure that occurs while connecting to Oracle DB?

    Thanks
    Ashok

    DB:3.19:Ora-12571: Tns:Packet Writer Failure - Occurs Only The First Time pf

    Hi

    We recently changed our load balancer to a new load balancer. we get this error only after the load balancer change.

    When the error occurs, I could see ORA-12571 error message only in the application error log. The listener.log has only the following message about TNS 12502. It does not have any message about ORA -12571.

    TNS-12502: TNS:listener received no CONNECT_DATA from client
    12-MAR-2010 12:23:26 * (CONNECT_DATA=(SERVICE_NAME=AppName)(CID=(PROGRAM=c:\wind ows\system32\inetsrv\w3wp.exe)(HOST=WEB02)(USER=NETWORK?SERVICE))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.x.x.x.x)(PORT=2202)) * establish * AppName * 0
    12-MAR-2010 12:23:26 * (CONNECT_DATA=(SERVICE_NAME=AppName)(CID=(PROGRAM=c:\wind ows\system32\inetsrv\w3wp.exe)(HOST=WEB02)(USER=NETWORK?SERVICE))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.x.x.x.x)(PORT=2203)) * establish * AppName * 0
    12-MAR-2010 12:23:26 * (CONNECT_DATA=(SERVICE_NAME=AppName)(CID=(PROGRAM=c:\wind ows\system32\inetsrv\w3wp.exe)(HOST=WEB02)(USER=NETWORK?SERVICE))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.x.x.x.x)(PORT=2204)) * establish * AppName * 0
    12-MAR-2010 12:24:09 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client

    Thanks
    Ashok

  • RELEVANCY SCORE 3.19

    DB:3.19:Ora-12571 Tns:Packet Write Failure 8p


    Hi all
    I installed Oracle 10g database, and after that Oracle 6i FORMS
    Then suddenly I began getting error Ora-12571
    I uninstalled 10g database, then uninstalled FORMS and installed forms once more, but there still error
    What may be the reason and how can I solve it?
    Thanks...

    DB:3.19:Ora-12571 Tns:Packet Write Failure 8p

    Is this on Windows (please include always OS information in postings)? If yes is a virus scanner installed, especially McAfee?
    Another possible issue, which characterset? There's a problem with developer 6i and unicode charactersets.

    Werner

  • RELEVANCY SCORE 3.18

    DB:3.18:Ora-12571 Error When Using Merge Command In Toad 13


    I am using TOAD connecting with Oracle 10i. I use MERGE command and get the error: ORA-12571: TNS:packet writer failure. I tried this command in the SQL Editor and it works. But when I move the same statement to a store procedure and compile it, I get the above eror. Anybody knows about this?

    DB:3.18:Ora-12571 Error When Using Merge Command In Toad 13

    There is no Oracle 10i.

    Do your version of TOAD and Oracle client installation support MERGE?

    Typically in large companies it isn't anyone's job to synchronise the desktop software with the database server until a lot of people complain.

  • RELEVANCY SCORE 3.17

    DB:3.17:Dataguard m7


    Hi,

    I have a Oracle 10g R2 10.2.0.1.0 enterprise edition database on Windows 2003 R2 - 64 bit Server, with physical dataguard configured.
    While going through alert log today morning I found followinng error on my primary database:

    LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (12571)
    LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
    Wed Nov 10 00:24:05 2010
    Errors in file c:\oracle\product\10.2.0\admin\mpwr01\bdump\mpwr02_lgwr_3536.trc:
    ORA-12571: TNS:packet writer failure
    LGWR: Network asynch I/O wait error 12571 log 3 service 'mpwr01'
    Wed Nov 10 00:24:05 2010
    Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
    LGWR: Failed to archive log 3 thread 1 sequence 103608 (12571)
    Wed Nov 10 00:24:05 2010
    Errors in file c:\oracle\product\10.2.0\admin\mpwr01\bdump\mpwr02_lgwr_3536.trc:
    ORA-01041: internal error. hostdef extension doesn't exist
    LGWR: Error 1041 closing archivelog file 'mpwr01'
    LGWR: Error 1041 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'mpwr01'
    Thread 1 advanced to log sequence 103609

    This error was there till 12:42 AM and then got resolved by itself.

    I checked for the gaps in the morning.. but there were no gaps as well.

    What may be the possible causes for the error?

    Thanks
    Vinita

    DB:3.17:Dataguard m7

    Hi,

    LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandonedthe specified log_archive_dest_2 was unreachable during that period, check the trace files further.

    1) response time to the hostdatabase

    tnsping mpwr01

    ORA-01041: internal error. hostdef extension doesn't exist*Bug 4690705 - Repeated ORA-1041 from heartbeat ping [ID 4690705.8]*

    Thanks

  • RELEVANCY SCORE 3.17

    DB:3.17:Ora-12154: Tns Could Not Resolve Service Name??? ma


    i install oracle form6i and 8i on winxp sp2 (first i install 6i on default home on the folder c:\orant and then install oracle 8i on the same diractry with different home that is ora8i in diractry c:\orant\ora8i) i can connect to oracle 8i from sqlplus
    but icann't connect from forms builder it give me the error ORA-12154: TNS could not resolve service name.
    this is the content of TNSNAMES.ora in the diratry C:\orant\NET80\ADMIN -- this for forms 6i
    ORA8I.WORLD =
    (DESCRIPTION =
    (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = grp-it-zein)(Port = 1521))
    (CONNECT_DATA = (SID = ORA8I))
    )
    and this is the content of TNSNAMES.ora in the diratry C:\orant\ora8i\network\ADMIN -- this for oracle 8i
    ORA8I.ALFOUADMKMA.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = grp-it-zein)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ORA8I)
    )
    )
    my computer connect to the domain ALFOUADMKMA.COM but i install oracle 8i and developer in the same machine.
    note:
    when i test the alias ORA8I in the diratry C:\orant\NET80\ADMIN from net8 easy config it give me the error
    ORA-12571: TNS Packet writer failure
    we use panda antivirus in our network if that have relation with the problem.
    please i need help
    thanks in advance.

  • RELEVANCY SCORE 3.15

    DB:3.15:Packet Writer Failure z7


    my PC using NT 4.0 Operating System if iconnect to the Oracle Database server using NT too, i get error:
    packet writer failure
    so if i connect from another client no problem, sucesfully
    please give the solution?
    e-mail: harlen_jabat@yahoo.com

    i waiting for your help
    thanks

    DB:3.15:Packet Writer Failure z7

    my PC using NT 4.0 Operating System if iconnect to the Oracle Database server using NT too, i get error:
    packet writer failure
    so if i connect from another client no problem, sucesfully
    please give the solution?
    e-mail: harlen_jabat@yahoo.com

    i waiting for your help
    thanks

  • RELEVANCY SCORE 3.11

    DB:3.11:Ora-12571: Tns:Packet Writer Failure c1


    hi all,

    i don't know what happened to my sql 8.0 that is being used with developer 6i, it suddenly stopped connectinng to server that is oracle9i. it throughs the error:

    ORA-12571: TNS:packet writer failure

    at the same time i have installed Oracle9i DS wich is working fine and connecting to the server database. I have formated my system and then reinstalled all the software again but the problem still persist.

    Please somebody do help me...

    Zahid Kareem.
    zahidkarim@hotmail.com

    DB:3.11:Ora-12571: Tns:Packet Writer Failure c1

    I discovered that the antivirus McAfee go in conflict with Oracle Client, before installation of McAfee all works, and afther disintallation of McAfee all works again. (My OS is Windows XP sp2)

    Bye

  • RELEVANCY SCORE 3.10

    DB:3.10:Ora-12571: Tns:Packet Writer Failure 7m


    --
    I've installed O8.0.5 on Suse 6.0, and I think I've gone
    through all of the install procedures. I've set up a dba
    group, and have made oracle as the db user.
    When I run svrmgrl, I get this error: ORA-12571: TNS:packet
    writer failure and I cannot connect to the Database.
    A DB-Instance was created during Installation name ORCL.
    Dbstart works fine and TNS Listener starts without errors too.
    At Installation I got a link error form Intelligent Agent, could
    this be the reason or did I forget to start a process?

    Thanks in advance!
    null

    DB:3.10:Ora-12571: Tns:Packet Writer Failure 7m

    What worked for me (in a slightly different environment was to comment out the SQLNET.AUTH_SERVICES line in the sqlnet.ora file.

    This fix was originally found in http://technet.oracle.com:89/ubb/Forum1/HTML/002993.html

    BLOCKQUOTEfont size="1" face="Verdana, Arial"quote:/fontHROriginally posted by rudolf (rd@mm.systemberatung.de):
    --
    I've installed O8.0.5 on Suse 6.0, and I think I've gone
    through all of the install procedures. I've set up a dba
    group, and have made oracle as the db user.
    When I run svrmgrl, I get this error: ORA-12571: TNS:packet
    writer failure and I cannot connect to the Database.
    A DB-Instance was created during Installation name ORCL.
    Dbstart works fine and TNS Listener starts without errors too.
    At Installation I got a link error form Intelligent Agent, could
    this be the reason or did I forget to start a process?

    Thanks in advance!HR/BLOCKQUOTE

    null

  • RELEVANCY SCORE 3.08

    DB:3.08:Designer6i On Windows 2000 - Ora-12571: Tns Write Packet Failure c7


    On Windows 2000 Advanced Server, I installed:
    1. Oracle8i 8.1.7 in OEE home
    2. Designer6i in ORANT home
    3. Developer6i Forms Reports in ORANT home

    I also have a remote database Oracle8i EE 8.1.6 running on Linux.

    When I try to connect to my remote or my local database using SQL*Plus 8.1.7 everything is OK.

    The problem is when I try to connect using SQL*Plus 8.0.6 or any tools from Designer6i or Forms6i I get the error:

    ORA-12571: TNS:packet writer failure.

    The config files tnsnames.ora and sqlnet.ora are the same on both oracle homes.

    Any clues would be appreciated. Cheers.

    null

    DB:3.08:Designer6i On Windows 2000 - Ora-12571: Tns Write Packet Failure c7

    I am using Windows 2000 Professional
    My pc is not working within a domain.
    I installed both Oracle 8i 8.1.7 Designer 6i Release 4.2 on the same machine with success.
    Both Sqlnet.Ora and Tnsnames.Ora are identical.
    Command Hostname is working proprely.
    Command Tnsping SID is working proprely in a Command (DOS) window.
    I create everything in the DB (roles, repos owner user and tablespaces) with success using sqlplus 8.1.7.0.0 coming with Oracle 8.1.7.
    When I am using sqlplus Release 8.0.6.0.0 or Designer or Repository Administration Utility I receive also the
    following message:

    ERROR:
    ORA-12571: TNS:packet writer failure

    It's a nightmare!

    Thanks for your help and advice.

  • RELEVANCY SCORE 3.07

    DB:3.07:Oracle 9i Install Prob. k3


    Hi to all

    i have a problem with oracle 9i.

    previously it show error while i try to connect to database.finally i uninstalled oracle,clear reg keys,removed folder.

    restart the system and trying to install .but at the end of the installation it shows error:
    "ora-12571 tns packet writer failure"

    how to solve this???and what is the problem???is there any problem with setup files???pls give the solution.

    DB:3.07:Oracle 9i Install Prob. k3

    Hi,

    As I already said: You should try the [Database-General | http://forums.oracle.com/forums/forum.jspa?forumID=61start=0 ] forum for this kind of questions.
    You'll get some help in no time there.

    Don't forget: this is the SQL and PL/SQL forum

  • RELEVANCY SCORE 3.07

    DB:3.07:Ora-12571: Tns: Packet Writer Failure With Asp .Net 4.0 sa


    Hello everyone! I really need urgent help here!
    I have an ASP .NET Web Application (4.0) and when someone makes an insert or update operation in any page, the Oracle Client returns this message:

    Oracle.DataAccess.Client.OracleException ORA-12571: Packet writer failure

    The real issue is that this error doesn't show eveytime, it only shows when the user opens the page, wait some minutes and makes the operation. When the user opens the page and immediatly makes the operation, everithing goes well.

    I have tried everything: reistall the client, try with the Web site in another server, disabling the antivirus in the server and specifying the database server in TSNAMES.ORA file. Nothing works! The error keeps displaying eventually!

    What else can I do?

    Thanks in advance!

    Edited by: user1079748 on Jul 7, 2010 9:55 AM

    Edited by: user1079748 on Jul 7, 2010 9:56 AM

    DB:3.07:Ora-12571: Tns: Packet Writer Failure With Asp .Net 4.0 sa

    change the sqlnet.ora file as
    SQLNET.AUTHENTICATION_SERVICES = (NONE)

  • RELEVANCY SCORE 3.06

    DB:3.06:Tns: Packet Writer Failure 1a


    I am attempting to get a RH Linux 6.0 machine to see our Oracle 7.3.4 server, running on a remote Solaris machine. I got Oracle 8.0.5, which I was assured would work. I fought with it for a while, and finally I think I've got it installed properly. TNSPING says OK when I point it at our database. The problem is that when I try to use sqlplus (or perl DBD, which is my ultimate goal), it give me:

    ORA-12571: TNS: packet writer failure

    I am certain that the server is running smoothly, so this is definitely a problem on the Linux machine. Does anybody know what I'm doing wrong? Thank you very much.

    DC

    DB:3.06:Tns: Packet Writer Failure 1a

    Never mind. After hunting through the old messages in this forum, I found the answer: add the line

    DISABLE_OOB=ON

    to the sqlnet.ora file.

  • RELEVANCY SCORE 3.06

    DB:3.06:'Ora-12571: Tns:Packet Writer Failure' Error While Calling Procedure From Vc++ 3a


    hi all,
    i am writing stored procedures and calling these from vc++. I have one stored procedure in that all
    in and out perameters are numeric. When i am calling these procedure i am able to get the values properly. But in another procedure one in perameter is varchar and one out perameter is varchar. When i am calling these procedure from vc++ the error i am getting is "ORA-12571: TNS:packet writer failure". I test my vc++ code on different computers but its giving the same errors. I think ora-12571 error is when i can't communicate with oracle. But other stored procedures(in and out perameters are numbers) and sql statements are running properly. Only these stored procedure which has in and out perameters as varchar is giving me the above said problem. My out perameter in this procedure strtax is of type varchar and the length 100. Is it the problem. Please suggest me how to over come this problem.
    thanks in advance,
    with regards
    vali.

    DB:3.06:'Ora-12571: Tns:Packet Writer Failure' Error While Calling Procedure From Vc++ 3a

    hi all,
    i am writing stored procedures and calling these from vc++. I have one stored procedure in that all
    in and out perameters are numeric. When i am calling these procedure i am able to get the values properly. But in another procedure one in perameter is varchar and one out perameter is varchar. When i am calling these procedure from vc++ the error i am getting is "ORA-12571: TNS:packet writer failure". I test my vc++ code on different computers but its giving the same errors. I think ora-12571 error is when i can't communicate with oracle. But other stored procedures(in and out perameters are numbers) and sql statements are running properly. Only these stored procedure which has in and out perameters as varchar is giving me the above said problem. My out perameter in this procedure strtax is of type varchar and the length 100. Is it the problem. Please suggest me how to over come this problem.
    thanks in advance,
    with regards
    vali.

  • RELEVANCY SCORE 3.05

    DB:3.05:Tns:Packet Writer Failure After Unplug And Plugging a9


    I'm using ODP.NET connection for Oracle database.

    I always check my status(open/close) of connection before writing or reading into database.
    I tested my application by unplugging and plugging network cable and tried refreshing it. But it throws me an error saying "ORA-12571: TNS:packet writer failure". When I debugged, still my app connection status is in open only.

    Please help me.

    -Vasanth TT

    DB:3.05:Tns:Packet Writer Failure After Unplug And Plugging a9

    Hi,

    Status only tells you whether Close has been called, it doesnt round trip to confirm your connection is still good.
    If you want all connections to be checked on con.Open, you could set "validate connection=true" in your connect string, but theres a performance impact as all con.open's will round trip.

    Hope it helps,
    Greg

  • RELEVANCY SCORE 3.05

    DB:3.05:Ora-12571 'Tns Packet Writer Failure' as


    Hi,
    How to resolve the following error? I get this when I connect to oracle through TOAD. I am using oracle client version 8.0.5.0.0 and the database version is 9.2.0.7.0.

    12571, 00000, "TNS:packet 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.

    Your help is much appreciated.

    Thanks,
    Devaraj

    DB:3.05:Ora-12571 'Tns Packet Writer Failure' as

    Error description shows, this error is very generic. Since 8.0.5 is very unstable and desupported you should upgrade. Check your TOAD documention for compatibility between sqlnet and TOAD.

    Werner

  • RELEVANCY SCORE 3.03

    DB:3.03:Ora-12571: Tns: Packet Writer Failure m7


    Oracle client(8.1.6) is installed on my box (windows 2000 workstation). tnsnames.ora is also configured correctly. The Oracle 8.1.6 db is installed on a solaris box. The db instance is also configured, up and runniing.
    But when i try to login via my oracle client, it gives the above mentioned error.
    The tnsnames.ora file is ok, since my coleagues using the same setup are able to connect from their boxes.
    I am able to ping the database, but tnsping does not work.
    Any help on pinpointing the cause wd be appreciated..Thanks...

    DB:3.03:Ora-12571: Tns: Packet Writer Failure m7

    try to change NLS_LANG parameter in registry
    it should match with database character set.

    (if conection values are correct)

    or

    use IP address in the place of hostname.

    Regards,

  • RELEVANCY SCORE 3.01

    DB:3.01:9i On Nt 4.0 Sp6 Dca Error Ora-12571 Creating And Starting Oracle Instance 1a


    Hi folks, I'm on NT 4.0 SP6 and I'm trying to install the Personal Edition of Oracle 9i with General Purpose database and the Database Configuration Assistant displays error "ORA-12571: TNS PACKET WRITER FAILURE".

    I've read a lot here in the installation forum; I've tried installing from the /install/win32/setup.exe, I've
    tried different database types, running the DCA standalone after the install, and I still get this error.

    I beleive my system specs are adequate, ie. disc space, memory, cpu, etc...;

    Also, in the beginning of the install it tells me that I should have MTS (Microsoft Transaction Server) installed. Is this true? Do I really need MTS for a 'personal edition', non-networked version of 9i?

    Can anyone help me solve this problem?

    Additionally:
    I saw someone respond that Personal Edition was only for
    Windows 98. I don't beleive that this is true. I know folks that have it installed on XP and 2000, as well as 98.

    There seems to be a lot of problems with DCA posted in the installation forum. Why doesn't Oracle fix it so it works right?

    Many thanks for this forum.
    - G. Redding

    DB:3.01:9i On Nt 4.0 Sp6 Dca Error Ora-12571 Creating And Starting Oracle Instance 1a

    This forum is not monitored by Oracle support or product teams and so Oracle product and technology related questions will not be answered. We recommend that you post this thread to the Oracle Technology Network (OTN) Products Database Database - General forum.

  • RELEVANCY SCORE 3.01

    DB:3.01:Packet Writer Failure xf


    What will cause a TNS-packet writer failure error? I have a
    sniffer trace that shows the error, but no idea why. Need help

    DB:3.01:Packet Writer Failure xf

    What will cause a TNS-packet writer failure error? I have a
    sniffer trace that shows the error, but no idea why. Need help

  • RELEVANCY SCORE 3.01

    DB:3.01:Ora-12571: Tns:Packet Writer Failure 1c


    Hi,

    I would like to seek help regarding the error ORA-12571: TNS:packet writer failure.

    When I intall Oracle Form 6 in my PC all my apps including SQL*Plus have the same error ORA-12571: TNS:packet writer failure.

    Any advise or help from anyone on this forum will be much appreciated.

    Thanks.

    DB:3.01:Ora-12571: Tns:Packet Writer Failure 1c

    Hi,

    This is usually due to an improper sqlnet.ora setting. Here are some possible causes and remedies:

    - Loose network cables. This error has been observed when there was a loose cable connection to the SCSI disk array (on an Oracle Parallel Server system). Related errors were also subsequently noted in the NT event log.
    - IP address conflict (Oracle 9.0.1).
    - Authentication services. One solution is to edit the sqlnet.ora file and change the line:

    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    to
    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    Try this solution.
    btw. on internet is too many articles reg this error.

    Regards,
    Tom
    http://oracledba.cz

  • RELEVANCY SCORE 3.00

    DB:3.00:Pppoe Error Debug 7f



    When I begin debug pppoe error this messeges return:

    7206_MORAH_BRAS#

    Nov 7 00:35:43.570 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:46.222 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:46.666 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:53.038 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:53.090 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:53.286 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:54.663 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:36:04.807 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:36:06.743 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:36:07.623 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:36:09.215 CET: PPPoE 12571: Bad Packet Length - dropping packet

    What's this, and how can I abort this problem?

    DB:3.00:Pppoe Error Debug 7f


    When I begin debug pppoe error this messeges return:

    7206_MORAH_BRAS#

    Nov 7 00:35:43.570 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:46.222 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:46.666 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:53.038 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:53.090 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:53.286 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:35:54.663 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:36:04.807 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:36:06.743 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:36:07.623 CET: PPPoE 12571: Bad Packet Length - dropping packet

    Nov 7 00:36:09.215 CET: PPPoE 12571: Bad Packet Length - dropping packet

    What's this, and how can I abort this problem?

  • RELEVANCY SCORE 3.00

    DB:3.00:Ora-12571 Tns Packet Writer Failure In Oracle8i 8s


    hi everybody
    i have ora-12571 tns packet writer failure in oracle8i problem when i run form form menu
    can anybody help me how can i solv.this problem
    with thanx

    DB:3.00:Ora-12571 Tns Packet Writer Failure In Oracle8i 8s

    This is a DB connection error. Please check that you can connect to the database (in SQLPlus). If you are using an App Server make sure that this machine can access the DB, not the client machine.
    HTH!

  • RELEVANCY SCORE 3.00

    DB:3.00:Ora 12571 Tns: Packet Writer Failure 87


    Hello everybody,

    In my home PC with OS Win2k, I have installed Oracle 8i Personnel Edition Developer 6i, Both the installations seems to be perfect. But when I connect SQLPlus from Developer side I get error (ORA 12571 TNS: Packet writer failure), As I don't have any network at my home and database and Developer 6i are on the same machine, but I tried too much to uninstall and reinstall the Oracle but useless.

    But when I try from Oracle 8i SQLPlus it is working fine, only problem is with Developer 6i SQLPlus side.

    I installed Oracle 9i Personnel Edition but having the same problem.

    Please guide me.... Thanks

    DB:3.00:Ora 12571 Tns: Packet Writer Failure 87

    Hello Sameer,

    I don't have any internet software, except Internet explorer.

    Thanks