2 Replies Latest reply on Nov 17, 2015 2:47 PM by Hari Prasad Soma

    ORA-12571: TNS:packet writer failure

    New Member

      Hi Frnds,

       

      Please let me know if anyone is accross this issue and resolve that ?

       

      This is happening on the connecting to the multiple Oracle servers middle of the job.

       

      Error Message

      WRT_8001         
      Error connecting to database...

        WRT_8001 [Session
      s_ XXXX Username XXX DB Error -1805

      ORA-12571: TNS:packet writer failure

       

      Thanks,

      Sandeep

        • 1. Re: ORA-12571: TNS:packet writer failure
          Active Member

          Check the connection properties.

           

          What is the Enable parallel mode? What is the Connection Retry Period?

          • 2. Re: ORA-12571: TNS:packet writer failure
            Hari Prasad Soma New Member

            Hello Mr Sandeep Golla,

             

            There is a KB link with KBID 15795 is available. Please check that might help you.

             

            Also did you get a chance to work with your DBA and Network Admins.

             

            Problem Description

            When running a session with an Oracle target the following error occurs:

            WRITER_1_*_1> WRT_8229 Database errors occurred:
            ORA-12571: TNS:packet writer failure
            Database driver error...
            Function Name : Execute
            SQL Stmt : UPDATE BATCH_UPLOAD_TRIGGER SET G1_REPO_STATUS = ? WHERE ID = ?
            Oracle Fatal Error
            Database driver error...
            Function Name : Execute
            SQL Stmt : UPDATE BATCH_UPLOAD_TRIGGER SET G1_REPO_STATUS = ? WHERE ID = ?
            Oracle Fatal Error
            WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
            WRITER_1_*_1> CMN_1022 Database driver error...
            CMN_1022 [ ORA-03114: not connected to ORACLE
            Database driver error... Function Name : Commit Database driver error... Function Name : Rollback]
            WRITER_1_*_1> WRT_8183 Rollback failed for the target [Shortcut_to_BATCH_UPLOAD_TRIGGER]
            WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table [BATCH_UPLOAD_TRIGGER>

            "ORA-600 [12333]" errors are written to the Oracle server trace files. "ORA-600 [12333]" is a fatal Oracle Server error which is causing communication failure between PowerCenter Server and the Oracle Database.

            Solution

            This error will occur when the Oracle database NLS_NCHAR_CHARACTERSET option is set to AL16UTF16.

            Workaround:

            Change the NLS_NCHAR_CHARACTERSET to UTF8.

            Example:

            If the Oracle database has the following NLS parameters set:

            NLS_CHARACTERSET WE8ISO8859P1
            NLS_NCHAR_CHARACTERSET AL16UTF16

            Then change these parameters to the following settings:

            NLS_CHARACTERSET WE8ISO8859P15
            NLS_NCHAR_CHARACTERSET UTF8