• RELEVANCY SCORE 6.02

    DB:6.02:Re: Ora 12571 s8




    Did you see any errors/information in listener.log and alert.log?

    DB:6.02:Re: Ora 12571 s8

    This is network related problem and there are can be several reasons.I think you can refer
    *Troubleshooting ORA - 3135 Connection Lost Contact [ID 787354.1]*

  • RELEVANCY SCORE 5.44

    DB:5.44:Ora-12571 aa




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

    DB:5.44:Ora-12571 aa

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

  • RELEVANCY SCORE 5.44

    DB:5.44:Ora-12571: Tns:Packet Writer Failure 1x




    Hello

    While compiling my procedure i am encountering the below error. Please advice.

    Facing the below error: ORA-12571: TNS:packet writer failure

    Entry in sql.net file
    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    #NAMES.DIRECTORY_PATH= (TNSNAMES)

    #sqlnet.expire_time = 5Also tried with
    SQLNET.AUTHENTICATION_SERVICES= (NONE)Thanks.
    AJR

    DB:5.44:Ora-12571: Tns:Packet Writer Failure 1x

    ORA-12571: 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.

  • RELEVANCY SCORE 5.43

    DB:5.43: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:5.43: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 5.26

    DB:5.26:12571 Tns Packet Writer Failure When Compiling Large Source Code sd


    Hi gurus,
    When we try to compile a large function from windows client (Toad or sqlplus) in a database (Oracle 11g) installed on a Red Hat server, we receive the following
    ORA-12571.
    When we try to compile the same function from sqlplus in the server, we haven't any problem,even from other Linux server in the same network.

    Tracing sqlnet on windows client machine we can see this:
    ....................................................................
    ....................................................................
    +[05-SEP-2012 15:28:54:642] nspsend: 46 20 78 69 64 5F 61 63 |F.xid_ac|+
    +[05-SEP-2012 15:28:54:642] nspsend: 63 69 6F |cio |+
    +[05-SEP-2012 15:28:54:642] nspsend: 2011 bytes to transport+
    +[05-SEP-2012 15:28:54:642] nspsend: normal exit+
    +[05-SEP-2012 15:28:54:642] nsdofls: exit (0)+
    +[05-SEP-2012 15:28:54:642] nsdo: nsctxrnk=0+
    +[05-SEP-2012 15:28:54:642] nsdo: normal exit+
    +[05-SEP-2012 15:28:54:642] nioqsn: exit+
    +[05-SEP-2012 15:28:54:642] nioqsn: entry+
    +[05-SEP-2012 15:28:54:642] nsdo: entry+
    +[05-SEP-2012 15:28:54:642] nsdo: cid=0, opcode=84, bl=0, what=1, uflgs=0x0, cflgs=0x3+
    +[05-SEP-2012 15:28:54:642] nsdo: rank=64, nsctxrnk=0+
    +[05-SEP-2012 15:28:54:642] nsdo: nsctx: state=8, flg=0x400d, mvd=0+
    +[05-SEP-2012 15:28:54:642] nsdo: gtn=127, gtc=127, ptn=10, ptc=2011+
    +[05-SEP-2012 15:28:54:642] nsdofls: entry+
    +[05-SEP-2012 15:28:54:642] nsdofls: DATA flags: 0x0+
    +[05-SEP-2012 15:28:54:642] nsdofls: sending NSPTDA packet+
    +[05-SEP-2012 15:28:54:642] nspsend: entry+
    +[05-SEP-2012 15:28:54:642] nspsend: plen=2011, type=6+
    +[05-SEP-2012 15:28:54:642] nttwr: entry+
    +[05-SEP-2012 15:28:54:642] ntt2err: entry+
    +[05-SEP-2012 15:28:54:642] ntt2err: soc 424 error - operation=6, ntresnt[0]=530, ntresnt[1]=54, ntresnt[2]=0+
    +[05-SEP-2012 15:28:54:642] ntt2err: exit+
    +[05-SEP-2012 15:28:54:642] nttwr: exit+
    +[05-SEP-2012 15:28:54:642] nspsend: 0 bytes to transport+
    +[05-SEP-2012 15:28:54:642] nspsend: transport write error+
    +[05-SEP-2012 15:28:54:642] nspsend: error exit+
    +[05-SEP-2012 15:28:54:642] nserror: entry+
    +[05-SEP-2012 15:28:54:642] nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=530, nt[1]=54, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0+
    +[05-SEP-2012 15:28:54:642] nsdofls: exit (-1)+
    +[05-SEP-2012 15:28:54:643] nsdo: nsctxrnk=0+
    +[05-SEP-2012 15:28:54:643] nsdo: error exit+
    +[05-SEP-2012 15:28:54:643] nioqsn: send failed: bl = 184, nicbl = 255+
    +[05-SEP-2012 15:28:54:643] nioqper: error from nioqsn+
    +[05-SEP-2012 15:28:54:643] nioqper: ns main err code: 12571+
    +[05-SEP-2012 15:28:54:643] nioqper: ns (2) err code: 12560+
    +[05-SEP-2012 15:28:54:643] nioqper: nt main err code: 530+
    +[05-SEP-2012 15:28:54:643] nioqper: nt (2) err code: 54+
    +[05-SEP-2012 15:28:54:643] nioqper: nt OS err code: 0+
    +[05-SEP-2012 15:28:54:643] nioqer: entry+
    +[05-SEP-2012 15:28:54:643] nioqer: incoming err = 12150+
    +[05-SEP-2012 15:28:54:643] niomapnserror: entry+
    +[05-SEP-2012 15:28:54:643] niqme: entry+
    +[05-SEP-2012 15:28:54:643] niqme: reporting NS-12571 error as ORA-12571+
    +[05-SEP-2012 15:28:54:643] niqme: exit+
    +[05-SEP-2012 15:28:54:643] niomapnserror: exit+
    +[05-SEP-2012 15:28:54:643] nioqce: entry+
    +[05-SEP-2012 15:28:54:643] nioqce: exit+
    +[05-SEP-2012 15:28:54:643] nioqer: returning err = 12571+
    +[05-SEP-2012 15:28:54:643] nioqer: exit+
    +[05-SEP-2012 15:28:54:643] nioqsn: returning error: 12571+
    +[05-SEP-2012 15:28:54:643] nioqsn: exit+
    +[05-SEP-2012 15:28:54:643] nioqrs: entry+
    +[05-SEP-2012 15:28:54:643] nioqrs: state = interrupted (1)+
    +[05-SEP-2012 15:28:54:643] nioqsm: entry+
    +[05-SEP-2012 15:28:54:643] nioqsm: Sending break packet (1)...+
    +[05-SEP-2012 15:28:54:643] nsdo: entry+
    +[05-SEP-2012 15:28:54:643] nsdo: cid=0, opcode=67, bl=1, what=17, uflgs=0x100, cflgs=0x3+
    +[05-SEP-2012 15:28:54:643] nsdo: rank=64, nsctxrnk=0+
    +[05-SEP-2012 15:28:54:643] nsdo: nsctx: state=8, flg=0x400d, mvd=0+
    +[05-SEP-2012 15:28:54:643] nsdo: gtn=127, gtc=127, ptn=10, ptc=2011+
    +[05-SEP-2012 15:28:54:643] nsdofls: entry+
    +[05-SEP-2012 15:28:54:643] nsdofls: DATA flags: 0x0+
    +[05-SEP-2012 15:28:54:643] nsdofls: normal exit+
    +[05-SEP-2012 15:28:54:643] nsdo: sending NSPTMK packet+
    +[05-SEP-2012 15:28:54:643] nspsend: entry+
    +[05-SEP-2012 15:28:54:643] nspsend: plen=11, type=12+
    +[05-SEP-2012 15:28:54:643] nttwr: entry+
    +[05-SEP-2012 15:28:54:643] ntt2err: entry+
    +[05-SEP-2012 15:28:54:643] ntt2err: soc 424 error - operation=6, ntresnt[0]=530, ntresnt[1]=54, ntresnt[2]=0+
    +[05-SEP-2012 15:28:54:643] ntt2err: exit+
    +[05-SEP-2012 15:28:54:643] nttwr: exit+
    +[05-SEP-2012 15:28:54:643] nspsend: 0 bytes to transport+
    +[05-SEP-2012 15:28:54:643] nspsend: transport write error+
    +[05-SEP-2012 15:28:54:643] nspsend: error exit+
    +[05-SEP-2012 15:28:54:643] nsdo: error sending NSPTMK packet+
    +[05-SEP-2012 15:28:54:643] nserror: entry+
    +[05-SEP-2012 15:28:54:643] nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=530, nt[1]=54, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0+
    +[05-SEP-2012 15:28:54:643] nsdo: nsctxrnk=0+
    +[05-SEP-2012 15:28:54:643] nsdo: error exit+
    +[05-SEP-2012 15:28:54:643] nioqsm: send-break: failed to send break...+
    +[05-SEP-2012 15:28:54:643] nioqper: error from send-marker+
    +[05-SEP-2012 15:28:54:643] nioqper: ns main err code: 12571+
    +[05-SEP-2012 15:28:54:643] nioqper: ns (2) err code: 12560+
    +[05-SEP-2012 15:28:54:643] nioqper: nt main err code: 530+
    +[05-SEP-2012 15:28:54:643] nioqper: nt (2) err code: 54+
    +[05-SEP-2012 15:28:54:643] nioqper: nt OS err code: 0+
    +[05-SEP-2012 15:28:54:643] nioqsm: exit+
    +[05-SEP-2012 15:28:54:643] nioqer: entry+
    +[05-SEP-2012 15:28:54:643] nioqer: incoming err = 12152+
    +[05-SEP-2012 15:28:54:643] niomapnserror: entry+
    +[05-SEP-2012 15:28:54:643] niqme: entry+
    +[05-SEP-2012 15:28:54:643] niqme: reporting NS-12571 error as ORA-12571+
    +[05-SEP-2012 15:28:54:643] niqme: exit+
    +[05-SEP-2012 15:28:54:643] niomapnserror: exit+
    +[05-SEP-2012 15:28:54:643] nioqce: entry+
    +[05-SEP-2012 15:28:54:643] nioqce: exit+
    +[05-SEP-2012 15:28:54:643] nioqer: returning err = 12571+
    +[05-SEP-2012 15:28:54:643] nioqer: exit+
    +[05-SEP-2012 15:28:54:643] nioqrs: nioqrs: Couldn't send break. returning 12571+
    +[05-SEP-2012 15:28:54:643] nioqrs: exit+
    +[05-SEP-2012 15:28:54:643] nioqds: entry+
    +[05-SEP-2012 15:28:54:643] nioqds: disconnecting...+
    +[05-SEP-2012 15:28:54:644] nsclose: entry+
    +[05-SEP-2012 15:28:54:644] nstimarmed: entry+
    ....................................................................
    ....................................................................

    We haven't got any problem compiling any other function or source code from windows client. This is the largest function database.

    Could be a problem related to firewall configuration???

    Any help would be appreciated.

    Thanks in advance.

    DB:5.26:12571 Tns Packet Writer Failure When Compiling Large Source Code sd

    Please anyone can give us some advice?
    We haven't found any solution.

    Thank you !!!!

  • RELEVANCY SCORE 4.93

    DB:4.93: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:4.93:Ora-12571: Tns: Packet Writer Failure With Asp .Net 4.0 sa

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

  • RELEVANCY SCORE 4.85

    DB:4.85:Tns:Packet Writer Failure mp


    --
    Hello,
    the following error occurs, when i start sqlplus
    My system: Linux Suse 2.0.35

    Anybody any idea?

    ora@neptun:/oracle/product/8.0.5 sqlplus

    SQL*Plus: Release 8.0.5.0.0 - Production on Tue Dec 15 1:57:29
    1998

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

    Enter user-name: ora
    Enter password:
    ERROR:
    ORA-12571: TNS:packet writer failure

    -Jochen
    null

    DB:4.85:Tns:Packet Writer Failure mp

    --
    I got thr same error running svrmgrl.
    The environment wasnt set. From $ORACLE_HOME type: . ./.env
    This shoud do the trick. Put this statement in your .profile.

    Hope I was helpful.

    Regards

    Jochen Grashorn (guest) wrote:
    : Hello,
    : the following error occurs, when i start sqlplus
    : My system: Linux Suse 2.0.35
    : Anybody any idea?
    : ora@neptun:/oracle/product/8.0.5 sqlplus
    : SQL*Plus: Release 8.0.5.0.0 - Production on Tue Dec 15 1:57:29
    : 1998
    : (c) Copyright 1998 Oracle Corporation. All rights reserved.
    : Enter user-name: ora
    : Enter password:
    : ERROR:
    : ORA-12571: TNS:packet writer failure
    : -Jochen
    null

  • RELEVANCY SCORE 4.85

    DB:4.85: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.85: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.79

    DB:4.79:Rep-0501 And Ora-12571 m7


    One of the developers here has Oracle8i and Oracle9i client installed on his laptop. He then installed Forms 6i. He can connect to the db using the command prompt and TOAD, but get the above mentioned errors when trying to use Forms? Any ideas? Thanks.

    DB:4.79:Rep-0501 And Ora-12571 m7

    Ok. I'll try that out. I just read somewhere that the Oracle_Home for Forms should be the same as the Oracle_Home for client!?

  • RELEVANCY SCORE 4.75

    DB:4.75:At9 Dish Coordinates p3


    For zip code 12571

  • RELEVANCY SCORE 4.39

    DB:4.39: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.39: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.26

    DB:4.26:Openning 6i Forms xm


    Hi All,

    Can you help me?

    I am openning Forms 6i and I am getting an Oracle error: ORA-12571 Oracle writer error.
    I don't know what that is or how to fixed does any know what I could do?

    Thanks,
    Mike

    DB:4.26:Openning 6i Forms xm

    Hi All,

    Can you help me?

    I am openning Forms 6i and I am getting an Oracle error: ORA-12571 Oracle writer error.
    I don't know what that is or how to fixed does any know what I could do?

    Thanks,
    Mike

  • RELEVANCY SCORE 4.26

    DB:4.26: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.26: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.26

    DB:4.26:Ora-12571 9.2 On Xppro 7s


    Hi,

    Just getting around to doing a brand new install of 9.2.0.1.0 onto XP Pro.

    Doing an Enterprise version install and installing a copy of the general database, but during the db install I get the ORA-12571: TNS packet writer failure, and the db install fails.

    Any clues as to how to overcome this.

    TIA
    Bryan

    DB:4.26:Ora-12571 9.2 On Xppro 7s

    Hi,

    Just getting around to doing a brand new install of 9.2.0.1.0 onto XP Pro.

    Doing an Enterprise version install and installing a copy of the general database, but during the db install I get the ORA-12571: TNS packet writer failure, and the db install fails.

    Any clues as to how to overcome this.

    TIA
    Bryan

  • RELEVANCY SCORE 4.26

    DB:4.26: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:4.26: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 4.26

    DB:4.26: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 4.26

    DB:4.26:Ora-12571 Tns : Packet Writter Failure 3j


    Hi all,
    When I try to connect the DBA Studio (in the WIN 2000 SP 3), client of Oracle , the error message is
    "ORA-12571 : TNS : Packet writer failure."

    But in the TNSNAME.ORA file is working fine. meaning SQL*Plus and other Oracle client can connect.

    Only the GUI application(like DBA Studio,enterprise manager) are giving this error.

    How can I solve this ploblem?

    Thanks.

    DB:4.26:Ora-12571 Tns : Packet Writter Failure 3j

    yes I few more tnsnames.ora file other directory for other version and application.

    For this same version HOME directory, only one file is there.
    so, SQL*Plus is connecting by using this file , but not for GUI applications.(DBA studio,Enterprise manager)

  • RELEVANCY SCORE 4.26

    DB:4.26: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:4.26: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 4.26

    DB:4.26: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:4.26: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 4.05

    DB:4.05:Question About My Log 3x


    This showed up but I'm curious what the problem is as everything seems to be functioning normal.

    Sat Feb 16 01:18:07 2008

    Errors in file C:\oracle\ora10g\dumps\bdump\db_lns1_2760.trc:

    ORA-12571: TNS:packet writer failure

    Sat Feb 16 01:18:07 2008

    LGWR: I/O error 12571 archiving log 2 to 'prod'

    Sat Feb 16 06:15:16 2008

    Thread 1 advanced to log sequence 33462

    Current log# 1 seq# 33462 mem# 0: C:\ORACLE\ORA10G\REDO\ORADB01.LOG

    Current log# 1 seq# 33462 mem# 1: C:\ORACLE\ORA10G\REDO\ORADB02.LOG

    Sat Feb 16 06:15:17 2008

    LNS: Failed to archive log 2 thread 1 sequence 33461 (12571)

    Sat Feb 16 06:15:17 2008

    Errors in file c:\oracle\ora10g\dumps\bdump\db_lns1_2760.trc:

    ORA-01041: internal error. hostdef extension doesn't exist

    LGWR: Error 1041 closing archivelog file 'prod'

    LNS: Standby redo logfile selected for thread 1 sequence 33462 for destination LOG_ARCHIVE_DEST_2

    Sat Feb 16 06:15:19 2008

    FAL[server]: Fail to queue the whole FAL gap

    DB:4.05:Question About My Log 3x

    yes the database is running. Standby server is replicating and applying the files.

  • RELEVANCY SCORE 3.99

    DB:3.99:Ora-12571?! Makes No Sense kk


    --
    I everything has been working fine for months now. I then
    decided to change the default character set in the database to
    UTF8. The server is a Oracle8i running on Solaris. After I
    changed the database I get a:

    Warning: Unable to connect to ORACLE (Error while trying to
    retrieve text for error ORA-12571) in db_oracle.inc on
    line 37

    When trying to connect with PHP on the client Linux boxes. I
    can connect from Perl and sqlplus on all computers after the
    change to UTF8 but not PHP. PHP is just using the standard
    libs. The only thing I'm doing strange is by passing TNSnames
    and putting the entire connect strings on the connect function.
    Is there any environment parameters I have to add since I changed
    to UTF8???

    Jeff
    null

    DB:3.99:Ora-12571?! Makes No Sense kk

    --
    I everything has been working fine for months now. I then
    decided to change the default character set in the database to
    UTF8. The server is a Oracle8i running on Solaris. After I
    changed the database I get a:

    Warning: Unable to connect to ORACLE (Error while trying to
    retrieve text for error ORA-12571) in db_oracle.inc on
    line 37

    When trying to connect with PHP on the client Linux boxes. I
    can connect from Perl and sqlplus on all computers after the
    change to UTF8 but not PHP. PHP is just using the standard
    libs. The only thing I'm doing strange is by passing TNSnames
    and putting the entire connect strings on the connect function.
    Is there any environment parameters I have to add since I changed
    to UTF8???

    Jeff
    null

  • RELEVANCY SCORE 3.99

    DB:3.99:Oracle Odbc Error Interpretation xd



    I am receiving the following error message

    [Oracle][ODBC][Ora]ORA-12571: TNS:packet writer failure
    ],[-2147467259]

    when executing a SELECT statement via Microsoft ADO connection from Visual C++

    Can someone please tell me how to lookup an Oracle error message for a detailed explaination ?

    Thank you

    DB:3.99:Oracle Odbc Error Interpretation xd

    http://tahiti.oracle.com has all of Oracle's documentation online, including the error reference.

    Justin

  • RELEVANCY SCORE 3.97

    DB:3.97: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:3.97: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 3.97

    DB:3.97:Problem Installing P.O. 8i (8.1.6) dz


    I installed forms and reports 6i on the default home and personal oracle 8i release 2(8.1.6) on different oracle home. During installation it give error message ora-012638 credential retrieval error at 95% of database creation.
    If deinstall all and again installed the product gives error message ora-03113,ora-12571 at different installaion time.
    How to install P.O. 8i in windows 2000,with forms 6i.
    Hope some one had already installed and solved the problem.
    Want help....
    null

    DB:3.97:Problem Installing P.O. 8i (8.1.6) dz

    It is a common error for installation may be for PO ar may be for server version.At the time of installationyou check the sid and configure sid for both home .you can have single listerner and congfigure for both sid.
    other is if d2k will work ,data base would not work or vice sersa.

    make different home and first install po8 than developer.

  • RELEVANCY SCORE 3.97

    DB:3.97:Ora-12571 ds


    My programming just do some opertion of selecting and updating frequently.When the programme ran for 7-10days there occured ORA-12571 error first followed by several ORA-01041 errors.

    Please help me! Very urgent...

    DB:3.97:Ora-12571 ds

    ORA-12571 indicates a broken connection between the Oracle client and the server. This could be (as Justin points out) due to a temporary network glitch or due to the death of a server process. In either case, the client side marks the connection as broken and in this case has cleaned up the assosciated data structures. Further operations return ORA-1041 as as result.
    The only option at this point is to reestablish the connection to the server from your application or restart the application. Check any kind of memory leak, handle leak, etc. especially when you have a long running process.

  • RELEVANCY SCORE 3.97

    DB:3.97:Ora-12571 ac


    I get a ORA-12571 during database configuration when trying to install 9i on Windows 2000.

    This happened on my first attempt to instll and then again after wiping Oracle from the machine.

    DB:3.97:Ora-12571 ac

    You may have a problem with Windows Native Authentication Adapter (NTS), especially if you are running Windows 2000 Server. To check this, search sqlnet.ora file for the line
    sqlnet.authentication_services = (NTS) and comment it out.
    Then try again.

  • RELEVANCY SCORE 3.97

    DB:3.97: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.97: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.97

    DB:3.97:Oracle 8i Database: Fatal Error In Two-Task Server mc


    Hi,

    We've been using Portal 3.0.7.6.2 since it was available. We've just upgraded to Oracle Database 8.1.6.3 (to resolve Apache GPF crashing problems) and have now noticed that our database server process terminates with a fatal error when we try to administer users, though in particular, adding users to existing groups. Error message as follows:

    *** SESSION ID:(8.8) 2001-01-16 16:43:16.140
    FATAL ERROR IN TWO-TASK SERVER: error = 12571
    *** 2001-01-16 16:43:16.156
    ksedmp: internal or fatal error
    ORA-12571: TNS:packet writer failure
    ORA-06512: at line 18

    The only way to recover is to terminate the instance's service and restart. This happens every time we add more than 2 users to a group.

    Any help would be appreciated.

    Gary

    DB:3.97:Oracle 8i Database: Fatal Error In Two-Task Server mc

    Hi,

    We've been using Portal 3.0.7.6.2 since it was available. We've just upgraded to Oracle Database 8.1.6.3 (to resolve Apache GPF crashing problems) and have now noticed that our database server process terminates with a fatal error when we try to administer users, though in particular, adding users to existing groups. Error message as follows:

    *** SESSION ID:(8.8) 2001-01-16 16:43:16.140
    FATAL ERROR IN TWO-TASK SERVER: error = 12571
    *** 2001-01-16 16:43:16.156
    ksedmp: internal or fatal error
    ORA-12571: TNS:packet writer failure
    ORA-06512: at line 18

    The only way to recover is to terminate the instance's service and restart. This happens every time we add more than 2 users to a group.

    Any help would be appreciated.

    Gary

  • RELEVANCY SCORE 3.97

    DB:3.97: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.97: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.97

    DB:3.97: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.97: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.97

    DB:3.97:Can't Connect To Database aj


    when I open forms and login, I enter my username, password and SID. The connection fails and I get: ORA-12571: TNS:packet writer failure.
    I've reinstalled Forms - has no effect on this. ????

    john welte

    DB:3.97:Can't Connect To Database aj

    Hy,
    are you sure that you've entered the correct sid? In order for forms to use the same sid as your oracle you have one program in the folder of forms named "Net Easy Config". Run that program and ensure that the sid that it is used for forms is the same as the one that oracle uses.
    Hope this helps you,
    Miha

  • RELEVANCY SCORE 3.97

    DB:3.97: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.97: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.97

    DB:3.97:Random Ora-12571: Tns:Packet Writer Failure Errors 8z


    Hi there!

    At least a few times a day i get ORA-12571: TNS:packet writer failure errors, my sqlnet.log looks like:

    VERSION INFORMATION:
    TNS for Linux: Version 10.2.0.4.0 - Production
    TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.4.0 - Production
    Time: 12-OCT-2009 22:57:50
    Tracing not turned on.
    Tns error struct:
    ns main err code: 12571
    TNS-12571: TNS:packet writer failure
    ns secondary err code: 12560
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 9

    My OCCI client multithread via pthreads and build against 10.2.0.4 client and my database is 9.2.0.8

    I've check my environment, specifically firewalls, and confirmed they arn't closing sockets, or dropping out of state packets etc..

    I had through it was I build my environment without the THREADED_MUTEX, but since changing this it still happens (prehaps less often)..

    On occasion my app will core dump, no doubt relating to code not handing this error properly.

    I havent anything relavent from google/metalink on this error..

    Any help would be much appreciated!

    Cheers

    James

    DB:3.97:Random Ora-12571: Tns:Packet Writer Failure Errors 8z

    Hi James,
    Experiencing an identical error - sporadically - did you get anywhere on this ?
    Running 10.2.0.4 on RHEL5
    Thanks

  • RELEVANCY SCORE 3.96

    DB:3.96: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.96: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.87

    DB:3.87: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.87: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.86

    DB:3.86: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.86: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.72

    DB:3.72:Ora - 12571 Tns: Packet Writer Failure 3z


    I am getting this error "ORA - 12571 TNS: Packet writer failure" when i am trying to connect from ORACLE FORMS.

    I could able to connect to TOAD and workflow

    Please help -- URGENT

    Thanks in advance

    DB:3.72:Ora - 12571 Tns: Packet Writer Failure 3z

    I am getting this error in my sqlnet.ora

    D:\oracle\orant\FORMS60
    Host and user is marked XXXX wantedly.

    Fatal NI connect error 12571, connecting to:
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXXXXXX)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=dev1)(CID=(PROGRAM=D:\oracle\orant\BIN\ifbld60.EXE)(HOST=A0210W002008085)(USER=xxxxx))))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.0.6.0.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.0.6.0.0 - Production
    Time: 24-MAY-07 11:12:23
    Tracing not turned on.
    Tns error struct:
    nr err code: 12206
    TNS-12206: TNS:received a TNS error during navigation
    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

    Message was edited by:
    satishkumart

  • RELEVANCY SCORE 3.72

    DB:3.72: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.72: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.71

    DB:3.71:Problem On Installing Oracle Net8 On Xp jp


    Hi there,

    I got the following error when I tried to install Net8 on XP, I can ping to the host and can't see any network problem, any clue on this?

    ORA-12571: TNS: packet write failure

    Thanks for any response.

    DB:3.71:Problem On Installing Oracle Net8 On Xp jp

    Hmmm... not exactly on topic for SCM.

    Anyway, make sure you're not blocking any IP with ZoneAlarm or the XP level firewall software. Verify you've got a good TNSNAMES.ORA and SQLNET.ORA file.

    goodluck
    ANdrew

  • RELEVANCY SCORE 3.71

    DB:3.71: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:3.71: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 3.67

    DB:3.67:Ora-12571 And Ora-03113 Errors. 3a


    Hello,

    I've been trying to install Oracle 8i on a Windows 2000 Pro workstation that is a member of a Windows 2000 domain. All my work is local to the workstation that the Oracle DB is installed on. My first attempt was successful until I shutdown the computer and then I lost the ability to connect to the database again. Then I started getting these ORA-12571 and ORA-03113 errors. I tried to reinstall and it didn't work. I went on the Boson Forum but did not find a solution to the problem.

    I was wondering if there is a patch that addresses this issue and where could I download it from? Is there a general download area of patches for the Oracle 8i database somewhere?

    Thank you kindly,
    Arie Rechtschaffer.

    DB:3.67:Ora-12571 And Ora-03113 Errors. 3a

    This can have many causes. I found one at Metalink that can be your problem:
    Problem Description
    -------------------
    SQLPlus 8.0.x client connections fail with the following error:
    ORA-12571 'TNS:packet writer failure'
    Solution Description
    --------------------
    The problem lies in the tnsnames.ora file. Oracle Net8 can raise this
    error when there is a parenthesis mismatch in the tnsnames.ora file.

    For example:

    oef =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = tcp.world)
    (PROTOCOL = TCP)
    (Host = 97.25.134.298)
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SID = oef)
    ) ====== Note the missing parenthesis
    boela =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = tcp.world)
    (PROTOCOL = TCP)
    (Host = 97.25.134.299)
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SID = boela)
    )
    )
    ) =========== Note the incorrect inclusion of the missing parenthesis

    The above example shows incorrect syntax. Correcting the parenthesis mismatch should
    resolve the ORA-12571 error.

    If this is not your problem, let us know to find something else.

  • RELEVANCY SCORE 3.67

    DB:3.67: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.67:Ora 12571 Tns: Packet Writer Failure 87

    Hello Sameer,

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

    Thanks

  • RELEVANCY SCORE 3.67

    DB:3.67:Error Ora 12571 Creating Database sz


    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.67:Error Ora 12571 Creating Database sz

    you can get better idea from discription
    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.

  • RELEVANCY SCORE 3.67

    DB:3.67:Unable To Start Obiee Scheduler z3


    Hi All,For some reason when we deploy the RPD , BI Scheduler is unable to START.Error which is in nqsscheduler.log :[2013-06-20T02:15:55.000-04:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: ] [tid: 103e3860] [68008] Scheduler Error: [[^MCurrent Table: S_NQ_JOB.[nQSError: 17001] Oracle Error code: 12571, message: ORA-12571: TNS:packet writer failure at OCI call OCIServerAttach.Current Table: S_NQ_JOB_PARAM.[nQSError: 17001] Oracle Error code: 12571, message: ORA-12571: TNS:packet writer failure at OCI call OCIServerAttach.Current Table: S_NQ_INSTANCE.[nQSError: 17001] Oracle Error code: 12571, message: ORA-12571: TNS:packet writer failure at OCI call OCIServerAttach.Current Table: S_NQ_ERR_MSG.[nQSError: 17001] Oracle Error code: 12571, message: ORA-12571: TNS:packet writer failure at OCI call OCIServerAttach.. Errors were encountered while initializing Scheduler's backend database, check database configuration.Kind Regards,Mohan

    DB:3.67:Unable To Start Obiee Scheduler z3

    Thank you so much for your quick reply.Its an Database issue. I have asked DB team to check the Listener status.Many Thanks.

  • RELEVANCY SCORE 3.65

    DB:3.65:Ora-12571 Error mp


    hello

    we are getting above error connecting to remote sites since last week.

    this was working fine one month ago

    we have our system on winn 2000 service pack 3 oracle9i installed on it .

    any suggestions

    thanx

    DB:3.65:Ora-12571 Error mp

    Hi,

    I advise you to read metalink note 156483.1 - ORA-12571 when running SVRMGRL or SQL*Plus locally on Windows Server.

    Solution :
    Edit the Server's sqlnet.ora file (located in the Oracle_Home\Network\Admin directory or where the TNS_ADMIN Environment variable is set)and remove/comment out the following line:
    sqlnet.authentication_services = (NTS)

    Nicolas.

  • RELEVANCY SCORE 3.65

    DB:3.65:Ora-12571 Tns Packet Writer Failure Error ds


    We are using Oracle 9i Ver 9.2 on Windows platform.
    Yesterday on a client running on Windows 2000 Professional, this error came: "ORA-12571 TNS packet writer failure." I looked for the solution on net found n numbers of different responses. Some one says its a spyware, someone says Oracle server has blocked this particular IP address, just restart the server it will be OK, some one says, remove the TCP/IP protocol from the client again reinstall the protocols. My problem was solved, by removing the spy.
    But I want to ask, whats the real meaning of this problem what shud be the proper action to resolve this.

    DB:3.65:Ora-12571 Tns Packet Writer Failure Error ds

    We are using Oracle 9i Ver 9.2 on Windows platform.
    Yesterday on a client running on Windows 2000 Professional, this error came: "ORA-12571 TNS packet writer failure." I looked for the solution on net found n numbers of different responses. Some one says its a spyware, someone says Oracle server has blocked this particular IP address, just restart the server it will be OK, some one says, remove the TCP/IP protocol from the client again reinstall the protocols. My problem was solved, by removing the spy.
    But I want to ask, whats the real meaning of this problem what shud be the proper action to resolve this.

  • RELEVANCY SCORE 3.65

    DB:3.65: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.65: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.62

    DB:3.62: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.62: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.57

    DB:3.57:Tns-12571 Packet Write Failure 7f


    Hi All,
    I have installed Forms 6i on a Windows XP client and while trying to connect to the database (9i on Windows 2000) it gives me "TNS-12571 : write packet error". We have already installed some 30 pcs with the same configuration. Pls guide ...?

    TIA

    DB:3.57:Tns-12571 Packet Write Failure 7f

    Hi All,
    I have installed Forms 6i on a Windows XP client and while trying to connect to the database (9i on Windows 2000) it gives me "TNS-12571 : write packet error". We have already installed some 30 pcs with the same configuration. Pls guide ...?

    TIA

  • RELEVANCY SCORE 3.57

    DB:3.57: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.57: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.57

    DB:3.57: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.57: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.57

    DB:3.57:Re: 12571 - Ora-12571: Tns:Packet Writer Failure Failed Sql Stmt p1


    sir basically i am installing peoplesoft HRMS step by step given into manual, many steps are install correctly but when i am come on datamover database creation wizard that run every thing run perfectly in at the end i face this 12571 - ORA-12571: TNS:packet writer failure error. I read few article they define me about this error, the cause of this error is antivirus block it.But i am asking you, that i re-run data mover or go ahead for next step.Please any one tell me.thanksSamiullah

    DB:3.57:Re: 12571 - Ora-12571: Tns:Packet Writer Failure Failed Sql Stmt p1

    Thanks Every body : My Problem Solved, i just delete the database and re install it with listener and other prerequisites, it run successfully.Thanks Samiullah

  • RELEVANCY SCORE 3.57

    DB:3.57: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.57: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.57

    DB:3.57:Ora-12571: Tns: Fehler Beim Paket-Schreiber cp


    Hi,

    I've installed version 92 on winXP professional. While installation the Databas Configuration Assistant prompted the error "ORA-12571: TNS: Fehler beim Paket-Schreiber" an aborted. After installation I tried to install a database by Databas Configuration Assistant again - same error happens.

    I also tried installation on W2K server - same error happens.

    Does anybody know a solution for this problem?

    regards
    Sven

    DB:3.57:Ora-12571: Tns: Fehler Beim Paket-Schreiber cp

    Yes

    Net Services Administrator's Guide Contents / Search / Index / PDF
    Net Services Reference Guide Contents / Search / Index / PDF
    http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage

    Joel Prez

  • RELEVANCY SCORE 3.57

    DB:3.57:Packet Writer Failure 3d


    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:3.57:Packet Writer Failure 3d

    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

  • RELEVANCY SCORE 3.57

    DB:3.57: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.57: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.57

    DB:3.57: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.57: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.57

    DB:3.57: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.57: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.57

    DB:3.57: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.57: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.57

    DB:3.57:Tns-12571 pf


    Hi,
    I have the following situation:
    I am using Oracle 8.1.7.4.0 with Developer 6i
    On my client PC I have 2 Oracle Homes (HOME1 and HOME2).
    The TNSNAMES.ORA and SQLNET.ORA files for the two homes are identical(copy paste)
    If I try to connect to the DB using Sqlplus of HOME1/BIN the connection is succesfull. But, if I try to connect to the DB using Sqlplus found in HOME2/BIN the connection fails and I receive the ORA-12571 error (TNS:Packet write failure). In both cases I am using the same connection info (logon, password connection string).
    This problem appeared today on only one machine that was working proberly till yesterday.

    Does any of you has ideas? Any help/suggestion would be appreciated.

    Thanks in Advance

    Ioanna

    DB:3.57:Tns-12571 pf

    Hi,
    I have the following situation:
    I am using Oracle 8.1.7.4.0 with Developer 6i
    On my client PC I have 2 Oracle Homes (HOME1 and HOME2).
    The TNSNAMES.ORA and SQLNET.ORA files for the two homes are identical(copy paste)
    If I try to connect to the DB using Sqlplus of HOME1/BIN the connection is succesfull. But, if I try to connect to the DB using Sqlplus found in HOME2/BIN the connection fails and I receive the ORA-12571 error (TNS:Packet write failure). In both cases I am using the same connection info (logon, password connection string).
    This problem appeared today on only one machine that was working proberly till yesterday.

    Does any of you has ideas? Any help/suggestion would be appreciated.

    Thanks in Advance

    Ioanna

  • RELEVANCY SCORE 3.57

    DB:3.57: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.57: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.57

    DB:3.57: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.57: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.57

    DB:3.57:Re: Oracle Db Problem 8d


    Here are the different error message I see the error log:

    (1) ORA03328.TRC
    *** 2005-11-01 09:47:25.125
    *** SESSION ID:(7.5) 2005-11-01 09:47:25.015
    FATAL ERROR IN TWO-TASK SERVER: error = 12571
    *** 2005-11-01 09:47:25.156

    (2) demodbALRT
    Fri Nov 11 19:46:48 2005
    Errors in file E:\oracle\admin\demodb\bdump\demodbCKPT.TRC:
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: 'E:\ORACLE\ORADATA\DEMODB\CONTROL03.CTL'
    ORA-27072: skgfdisp: I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.

    (3) demodbALRT
    Wed Nov 02 16:54:19 2005
    Errors in file E:\oracle\admin\demodb\udump\ORA03484.TRC:
    ORA-12571: TNS:packet writer failure

    Also I am running oracle is running on Windows 2000.

    Thanks,
    Ravi

    DB:3.57:Re: Oracle Db Problem 8d

    Hi Ravi

    Metalink note 304625.999 discuss a similar issue. Few possibilities that were discussed include

    1. The OS account responsible for starting Oracle Service not having proper privileges.
    2. Some Antivirus software causing this.
    3. Some Third Party Backup Tool.

    Wish I could help you more but I can't. Someone will take over from here.

    Rgds
    Adnan

  • RELEVANCY SCORE 3.57

    DB:3.57:Real-Time Replication Problem pc


    I has an advanced repliaction problem. two site with real-time replication.
    When one master site crashed. Can't run DML at the other site. the errors are
    ORA-12571
    ORA-02063
    ORA-02068

    How to run DML on the site with no interrupt.

    DB:3.57:Real-Time Replication Problem pc

    There are two listener : listener listener1

    C:\lsnrctl service

    LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 17-FEB-2006 09:10:32

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bnb1058)(PORT=1522)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "mdb3" has 1 instance(s).
    Instance "mdb3", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    The command completed successfully

    C:\lsnrctl service listener1

    LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 17-FEB-2006 09:12:12

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bnb1058)(PORT=1521)))
    Services Summary...
    Service "mdb4" has 1 instance(s).
    Instance "mdb4", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    The command completed successfully

    I do a test following the step:
    1. stop the site: mdb3's listener:
    lsnrctl stop
    2. tnsping mdb3
    C:\tnsping mdb3
    TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 17-FEB-2006 09:39:37
    Copyright (c) 1997 Oracle Corporation. All rights reserved.

    Used parameter files:
    d:\oracle\ora92\network\admin\sqlnet.ora

    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (FAILOVER = on) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bnb1058)(PORT = 1522)
    )) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mdb3) (FAILOVER_MODE = (BACKUP = MDB4) (TYPE = select) (METHOD = prec
    onnect) (RETRIES = 2) (DELAY = 1))))
    TNS-12535: TNS:operation timed out
    3. using sqlplus
    C:\sqlplus /nolog

    SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 17 09:41:15 2006

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    SQL conn repadmin/repadmin@mdb3
    ERROR:
    ORA-12535: TNS:operation timed out

    Should not it failover to the mdb4? I dunno what's wrong with it.

  • RELEVANCY SCORE 3.57

    DB:3.57: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:3.57:Packet Writer Failure 38

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

  • RELEVANCY SCORE 3.57

    DB:3.57: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.57:Ora-12571 Tns Packet Writer Failure --Urgent Help Required 3x

    This question probably best belongs on the General database forum.

  • RELEVANCY SCORE 3.57

    DB:3.57: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.57: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.53

    DB:3.53: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.53: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.51

    DB:3.51:Ora 12571 Tns Packet Writer Failure ac


    Event Type:Error
    Event Source:FileNet Content Engine
    Event Category:(1)
    Event ID:12
    Date:10/27/2010
    Time:5:57:39 PM (3:57:39 PM MST)
    User:xxxxx
    Computer:xxxxx
    Description:
    The description for Event ID ( 12 ) in Source ( FileNet Content Engine ) cannot be found.
    The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer.
    You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details.
    The following information is part of the event: PID=9776, TID=580, Fnk_CatService.exe hr=80040e14 database.cpp[1284] ($Revision: 1.90 $): ,
    ORA-12571: TNS:packet writer failure
    Error code: 0x80040e14Source: OraOLEDB

    Apperciate your feedback

  • RELEVANCY SCORE 3.51

    DB:3.51:Oracle 9i Installation On Windows2000 Gives Ora-12571tns:Packet Write Failure cd


    I am installing oracle 9i personal edition release 2 through
    technet.oracle.com.
    I get ORA-12571 TNS Packet Writer Failure when I create database
    This error appears during Database configuration assistant step.

    Please suggest.

  • RELEVANCY SCORE 3.49

    DB:3.49:Configuration Of Oracle9ias Services xd


    I am experiencing problem during configuration of database cache.
    After starting it proceeds upto 16% and then process fails.

    First time the message was
    UNABLE to start NT Services
    Reason : insufficient previlege.

    Now it messages

    Unable to start NT Services
    Reason : ora-12571 packet writer failure

    What's solution ?
    Please help me how cam I complete the configuration ?

    Bashar

    DB:3.49:Configuration Of Oracle9ias Services xd

    The Database Cache is no longer part of iAS. Please repost your question on one of the Database forums.

  • RELEVANCY SCORE 3.49

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


    Hi !

    Plz, define/explain

    ORA-12571: TNS: Packet Writer Failure.

    Thanks..

    Regards!

    DB:3.49: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 3.45

    DB:3.45: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.45: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.45

    DB:3.45:Fatal Error In Two-Task Server: Error = 12571 az


    Hi,
    Oracle 8i / Windows 2000 DB is runing in Archive log mode.
    alrert log file contains ora02172.trc file which contains

    'FATAL ERROR IN TWO-TASK SERVER: error = 12571'

    what is the corrective action.

    alertlog file

  • RELEVANCY SCORE 3.39

    DB:3.39: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.39: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.38

    DB:3.38: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.38: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.38

    DB:3.38:Ctxsrv Error p7


    I'm trying to start the ctxsrv with

    ctxsrv -u ctxsys/ctxsys

    but as a response i get:
    OCO server startup
    Initialized CORE
    Server failure DRG-11100: file not found [Error while trying to retrieve text for error ORA-12571
    file not found [fail to authenticate}
    shutting down

    What is wrong with that?

    null

    DB:3.38:Ctxsrv Error p7

    Alain,
    Looks like intermedia Text is not installed correctly. Please take a look at http://technet.oracle.com:89/ubb/Forum36/HTML/000661.html You may also want to look at http://technet.oracle.com:89/cgi-bin/postings.cgi?action=replyforum=iFSnumber=36topic=000922.cgi for a better way of keeping indexes up-to-date.

    Thank You
    Brian

  • RELEVANCY SCORE 3.38

    DB:3.38:Rep-1401 And Ora-12571 mm


    Dear All,Oracle fusion middleware version (pfrd) : 11.1.1.4OS : Windows 2008 X 64, 2 CPU and 8 GB RAMWhen we run a huge report we are encountering REP-1401 and intermittently with accompaning error ORA-12571, but when the same report ran for one month report it is working fine. REP-1401: A fatal PL/SQL error occurred in program unit cf_anct_docsformula.Since the report is running fine for 1 month period, we concluded that this issue is not a report error or formula columns used and narrowed it to some configuration or ORACLE bug.We have increased the JVM heap and tired but we couldnt able to get the report. Also we tried searching in oracle support but no hits.Please let me know if any one had encountered this issue.Regards,Anand.

    DB:3.38:Rep-1401 And Ora-12571 mm

    Error ORA-12571 is related to TNS:packet writer failure and error occurred during a data send. For further investigation, you need to turn on tracing to collect the logs.

  • RELEVANCY SCORE 3.38

    DB:3.38: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.38: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.38

    DB:3.38: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.38: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.38

    DB:3.38: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:3.38: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 3.38

    DB:3.38:Ora-01041 zz


    Hi,

    I have 2 databases ( A and B ) installed both 8.1.7.

    When i connect to it thru sqlplus everything works fine. I can see all tables and user etc.

    But when i connect thru TOAD to A also no problems. When i connect to B i cannot see any objects or users. And sometimes i get an error ORA-01041 Hostdef extention.... sometimes together with ORA-12571.

    When i connect from another machine to this database B(also via TOAD)then everything works as expected.

    Does anybody have a clue where to look for this problem?

    Regards,

    Joshua

    DB:3.38:Ora-01041 zz

    Problem solved after reinstalling patch 8.1.7.4.

    Still i can't see the reason of this error.

  • RELEVANCY SCORE 3.38

    DB:3.38:Weird Error_Log Entries And Apache Crashing c8


    Hi, I've got a 3.0.9.8.1 install on NT4 SP6 against a 8.1.7.1.1 EE db.

    After a couple of hours use I received a 503 time out error whilst creating a QBE Report. Bouncing Apache and db brought it back up and running and the report seemed ok.

    Taking a look in the error_log file I noticed these entries. Can anyone shed any life on what is happening here?

    Sorry for the long error log entry....

    ORA-06512: at "PORTAL30.WWSBR_IMT_SERVICES", line 364
    ORA-06512: a..
    [Mon Aug 06 17:00:07 2001] [warn] mod_plsql: Stale Connection due to Oracle error 20100
    [Mon Aug 06 17:00:07 2001] [error] mod_plsql: /pls/portal30/PORTAL30.wwsbr_imt_services.GenericView ORA-20100
    ORA-20100:
    ORA-06512: at "PORTAL30.WWSBR_STDERR", line 437
    ORA-06512: at "PORTAL30.WWV_SEARCHDB", line 31
    ORA-00903: invalid table name
    ORA-06512: at "PORTAL30.WWSBR_IMT_SERVICES", line 145
    ORA-20100:
    ORA-20100:
    ORA-06512: at "PORTAL30.WWSBR_STDERR", line 437
    ORA-06512: at "PORTAL30.WWV_SEARCHDB", line 31
    ORA-20000: interMedia Text error:
    DRG-50857: oracle error in dretbase
    ORA-00600: internal error code, arguments: [], [], []..
    [Mon Aug 06 17:00:35 2001] [warn] mod_plsql: /pls/portal30/PORTAL30.wwsbr_ui_bulkaction.search_wrapper had to be described for execution. Refer to the PL/SQL GateWay documentation on how to avoid this
    [Mon Aug 06 17:01:30 2001] [warn] mod_plsql: /pls/portal30/PORTAL30.wwexp_api_engine.action had to be described for execution. Refer to the PL/SQL GateWay documentation on how to avoid this
    [Mon Aug 06 17:01:56 2001] [warn] mod_plsql: /pls/portal30/PORTAL30.wwexp_render.show_tree had to be described for execution. Refer to the PL/SQL GateWay documentation on how to avoid this
    [Mon Aug 06 17:11:07 2001] [warn] mod_plsql: /pls/portal30/PORTAL30.wwexp_api_engine.action had to be described for execution. Refer to the PL/SQL GateWay documentation on how to avoid this
    [Mon Aug 06 17:11:38 2001] [warn] mod_plsql: /pls/portal30/PORTAL30.wwapp_app_explorer.access_form had to be described for execution. Refer to the PL/SQL GateWay documentation on how to avoid this
    [Mon Aug 06 17:11:40 2001] [warn] mod_plsql: /pls/portal30/PORTAL30.wwapp_app_explorer.access_form had to be described for execution. Refer to the PL/SQL GateWay documentation on how to avoid this
    [Mon Aug 06 17:11:52 2001] [warn] mod_plsql: /pls/portal30/PORTAL30.wwexp_api_engine.action had to be described for execution. Refer to the PL/SQL GateWay documentation on how to avoid this
    [Mon Aug 06 17:12:52 2001] [warn] mod_plsql: /pls/portal30/PORTAL30.wwv_builder.accept had to be described for execution. Refer to the PL/SQL GateWay documentation on how to avoid this
    [Mon Aug 06 17:13:56 2001] [warn] mod_plsql: /pls/portal30/PORTAL30.wwv_builder.accept had to be described for execution. Refer to the PL/SQL GateWay documentation on how to avoid this
    [Mon Aug 06 17:14:04 2001] [warn] mod_plsql: /pls/portal30/PORTAL30.wwv_builder.accept had to be described for execution. Refer to the PL/SQL GateWay documentation on how to avoid this
    [Mon Aug 06 17:14:37 2001] [warn] mod_plsql: Stale Connection due to Oracle error 12571
    [Mon Aug 06 17:14:37 2001] [error] mod_plsql: /pls/portal30/PORTAL30.wwv_component_control.run_as_portlet ORA-12571
    ORA-12571: TNS:packet writer failure

    [Mon Aug 06 17:14:37 2001] [warn] mod_plsql: Stale Connection due to Oracle error 3114
    [Mon Aug 06 17:14:41 2001] [warn] mod_plsql: Stale Connection due to Oracle error 12571
    [Mon Aug 06 17:14:41 2001] [error] mod_plsql: /pls/portal30/PORTAL30.wwv_component_control.run_as_portlet ORA-12571
    ORA-12571: TNS:packet writer failure

    [Mon Aug 06 17:14:41 2001] [warn] mod_plsql: Stale Connection due to Oracle error 3114
    [Mon Aug 06 17:14:44 2001] [warn] mod_plsql: Stale Connection due to Oracle error 12571
    [Mon Aug 06 17:14:44 2001] [error] mod_plsql: /pls/portal30/PORTAL30.wwv_component_control.run_as_portlet ORA-12571
    ORA-12571: TNS:packet writer failure

    [Mon Aug 06 17:14:44 2001] [warn] mod_plsql: Stale Connection due to Oracle error 3114
    [Mon Aug 06 17:14:51 2001] [warn] mod_plsql: Stale Connection due to Oracle error 12571
    [Mon Aug 06 17:14:51 2001] [error] mod_plsql: /pls/portal30/SCOTT.QBE_EMPS.show ORA-12571
    ORA-12571: TNS:packet writer failure

    [Mon Aug 06 17:14:51 2001] [warn] mod_plsql: Stale Connection due to Oracle error 3114
    [Mon Aug 06 17:15:11 2001] [warn] mod_plsql: Stale Connection due to Oracle error 3114
    [Mon Aug 06 17:15:11 2001] [error] mod_plsql: /pls/portal30/PORTAL30.wwv_builder.edit HTTP-503 ORA-12571 BClient Logon Failed with error : 12571/BBRBReset Session Call also failed with error : 3114/BBR
    [Mon Aug 06 17:16:04 2001] [warn] mod_plsql: Stale Connection due to Oracle error 12571
    [Mon Aug 06 17:16:04 2001] [error] mod_plsql: /pls/portal30/portal30.home HTTP-503 ORA-12571 BCall to WPG_SESSION API Failed./BBR

    null

    DB:3.38:Weird Error_Log Entries And Apache Crashing c8

    Has anyone can any idea for this? I need to sort this urgently.

    I had a partial fix by running in inctxgrn.sql which got rid of most of the ctx errors, but they still appear sfter a while. The stale connection and TNS errors still appear.

  • RELEVANCY SCORE 3.38

    DB:3.38:Forms 6i Installation Problem. 8x


    Dear members,

    I am facing the ora-12571 on a PC when i try to connect SQL PLUS. I failed to fix the problem so i am trying to reinstall the FORMS 6i.
    Now I have the following problem:

    zrc60.map(0): FILE_NOT_FOUND while mapping zrc60

    and close the installation.

    Thanks in advance.

    Regards:

    Muhammad Nadeem
    nadeem14375@gmail.com

    DB:3.38:Forms 6i Installation Problem. 8x

    Dear Danish Hayder,

    the same error:

    Regards

    Muhammad Nadeem
    nadeem14375@gmail.com

  • RELEVANCY SCORE 3.38

    DB:3.38:Sys.Utl_Http And Tns:Packet Writer Failure x3


    Hello )

    I have strange error in network level

    This issue happened in the first run for my function

    ORA-12571: TNS:packet writer failure
    ORA-06512: at "SYS.UTL_HTTP", line 1229
    ORA-06512: at "XMLA.XMLA_GET_DATA_PKG", line 32line 30: UTL_HTTP.set_header(vUtlHttpReq, 'content-length', LENGTH(vXmlaBody));
    line 31: UTL_HTTP.write_text(vUtlHttpReq, vXmlaBody);
    line 32: UTL_HTTP.set_transfer_timeout(2147483647);but if I run function more times - all works fine.

    Please - help me for how to determinate whats wrong in PL-SQL code or Network env ? )
    And what are must be fixed ?

    DB:3.38:Sys.Utl_Http And Tns:Packet Writer Failure x3

    I think - problem resolved

    I am change windows registry setting - enlarge parametr TcpTimedWaitDelay to 500

  • RELEVANCY SCORE 3.36

    DB:3.36: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.36

    DB:3.36:Ora Error 12571:Tns Packet Failed To Write a7


    while installing oracle i am getting the error message like this
    user1.pin(20): OS_ERROR while spawning ifsrv60 - install forms60 server-orahome2 port=9000 mode=socket batch=yes

    please clarify how to tackle

    469875

    DB:3.36:Ora Error 12571:Tns Packet Failed To Write a7

    Check out the following for more details on ur problem.

    http://www.dbmotive.com/oracle_error_codes.php?errcode=12571

    Regards,
    Senthil .A. Perumal.

  • RELEVANCY SCORE 3.36

    DB:3.36:"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:3.36:"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 3.36

    DB:3.36: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.36: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.35

    DB:3.35: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.35: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.35

    DB:3.35: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 3.33

    DB:3.33: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.33: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.32

    DB:3.32: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:3.32: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 3.32

    DB:3.32: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.32: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.29

    DB:3.29:Tns-12571 ak


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

    Any Ideas??

    DB:3.29:Tns-12571 ak

    Which communation protocol you are using????

  • RELEVANCY SCORE 3.29

    DB:3.29:Ora-12571: Tns:Packet Writer Failure At Oci Call Ocistmtexecute 9j


    i Experts,
    In OBIEE 11.1.1.6.0.
    I make use of Agent functionality to send the reports for users,but sometimes it will generate the following error message, and if send it again, it will be ok.Why? Is it bug?

    View Display Error
    Odbc driver returned an error (SQLExecDirectW).
    Error Details
    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. [nQSError: 17001] Oracle Error code: 12571, message: ORA-12571: TNS:packet writer failure at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
    SQL Issued: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL "Exception"."Connection Pool" select BUSINESSDATE, US_CODE, SMS_NUM, MARKET_NO, DATA_BI, DATA_BD from V_EDW_TTL_MISSING_LOG where BUSINESSDATE=to_char(sysdate-1,''yyyyMMdd'') order by US_CODE')}

    Note: I have used 'Direct Database Request' to create reports for sending.

    DB:3.29:Ora-12571: Tns:Packet Writer Failure At Oci Call Ocistmtexecute 9j

    i Experts,
    In OBIEE 11.1.1.6.0.
    I make use of Agent functionality to send the reports for users,but sometimes it will generate the following error message, and if send it again, it will be ok.Why? Is it bug?

    View Display Error
    Odbc driver returned an error (SQLExecDirectW).
    Error Details
    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. [nQSError: 17001] Oracle Error code: 12571, message: ORA-12571: TNS:packet writer failure at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
    SQL Issued: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL "Exception"."Connection Pool" select BUSINESSDATE, US_CODE, SMS_NUM, MARKET_NO, DATA_BI, DATA_BD from V_EDW_TTL_MISSING_LOG where BUSINESSDATE=to_char(sysdate-1,''yyyyMMdd'') order by US_CODE')}

    Note: I have used 'Direct Database Request' to create reports for sending.

  • RELEVANCY SCORE 3.26

    DB:3.26:Tns-12571 Packet Writer Failure p8


    Hi,

    Oracle Database 10.2.0.1 on Windows Server 2003 V5.2

    A few weeks the datbase works fine.

    In the last night, oracle crashs / the listener (???)

    In the trace-file I can read:

    "optisk: network error occurred while two-task server trying to send break; error code = 12571"

    TNS-12571:TNS:packed writer failure

    Anybody here who can tell me what could cause this behaviour ?

    Temporary network-problems ???

    Kind regards,

    Walter Laurentius

    DB:3.26:Tns-12571 Packet Writer Failure p8

    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:
    n SHUTDOWN ABORT
    n SHUTDOWN IMMEDIATE
    n SHUTDOWN TRANSACTIONAL
    Action: For further details, turn on tracing and re-execute the operation. If the
    error persists, contact Oracle Support Services.

  • RELEVANCY SCORE 3.26

    DB:3.26: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.26:Ora-12571: Tns:Packet Writer Failure zm

    IS it happening daily

    If not

    I think your Db server network is unplugged

  • RELEVANCY SCORE 3.26

    DB:3.26:Re: Ora-12571_Tns_Packet Writer Failure zs


    TheHades0210 wrote:
    Aloha!

    I need some urgent help on this error. All the users in the network is experiencing this error.

    C:\sqlplus sys/xxxxx@orc4 as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 10 10:43:26 2011

    Copyright (c) 1982, 2010, Oracle. All rights reserved.

    ERROR:
    ORA-12571: TNS:packet writer failure

    Enter user-name:

    An urgent help is very much appreciated.

    Hadeswhen did SQL*Net work without error?
    what changed since then.

    what clues exist within listener.log file?

    If you are logged onto DB Server itself, does below succeed?

    sqlplus scott/tiger@prod

    -- where you use valid username/password@tns_alias

    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:~$

    DB:3.26:Re: Ora-12571_Tns_Packet Writer Failure zs

    ok, so if you use the listener you cannot connect

    I had this issue but it wasn't the firewall.

    Can you post the listener.ora for us?
    try to change it, pointing the host address as "localhost" or even the IP Address instead the "hostname". And then try to tnsping your service.
    If necessary, re-create the listener.

    In my case, re-creating the listener and configuring the local ip address instead hostname or even localhost worked well, and I could then connect to the DB.

    Hope it Helps
    Keen

  • RELEVANCY SCORE 3.26

    DB:3.26: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.26: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.24

    DB:3.24: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.24: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.24

    DB:3.24:Re: Ora-03113: End-Of-File On Communication Channel &Amp; Ora-03114: za


    Yes i am connecting through client side(TOAD).

    When i continously execute the query then there is no problem. But problem occurs when i sits idle more than approx. 2 minutes.

    Listner is properly running at server side.

    Also while connecting though toad
    1st Error is
    Ora-12571: TNS: PAcket write failure
    Ora-12541: TNS: No Listener
    Then it connects.

    What is the problem?
    Where i can look into?

    Thanks,

    DB:3.24:Re: Ora-03113: End-Of-File On Communication Channel &Amp; Ora-03114: za

    you should create a new listner from listner confrigation.
    As per your database requirements.
    Also check paging size of your server, is it competable with RAM?
    Check the firewall setting with the network.

    thanks reguards,

    darshan.