3 Replies Latest reply on Apr 10, 2018 6:07 PM by jgarry

    Error SQLLDR-643 Unable to insert records beyond a certain point

    susieq

      Hello,

      Oracle 11.2.0.3 on Solaris SPARC. 

      I am trying to use sqlldr utility to upload about 300k records.  The file to be imported is about 250M. 

       

      I get the following error:

      SQL Loader-643 : error executing insert statement for table foo

      ORA-03113: end of file communication channel

      My alert log says : ERROR: Unrecoverable error ORA-29701 raised in ASM I/O path; terminating process 3202

       

      My Oracle user profile CONNECT_TIME, IDLE_TIME has UNLIMITED values.

      I've also tried setting my sqlnet.expire_time to 0 thinking maybe it was due to connection time.

      I also tried using direct path but that failed as well.

       

      Database is in NOARCHIVELOG mode and I have 6x100M redo log groups.

       

      Any ideas or help appreciated!

       

       

        • 1. Re: Error SQLLDR-643 Unable to insert records beyond a certain point

          You won't be able to load data over the network unless you keep your network up and running.

           

          I've loaded millions of rows and never had that problem.

           

          SHOW US:

           

          1. WHAT you do

          2. HOW you do it

          3. WHAT results you get

          • 2. Re: Error SQLLDR-643 Unable to insert records beyond a certain point
            John Thorton

            susieq wrote:

             

            Hello,

            Oracle 11.2.0.3 on Solaris SPARC.

            I am trying to use sqlldr utility to upload about 300k records. The file to be imported is about 250M.

             

            I get the following error:

            SQL Loader-643 : error executing insert statement for table foo

            ORA-03113: end of file communication channel

            My alert log says : ERROR: Unrecoverable error ORA-29701 raised in ASM I/O path; terminating process 3202

             

            My Oracle user profile CONNECT_TIME, IDLE_TIME has UNLIMITED values.

            I've also tried setting my sqlnet.expire_time to 0 thinking maybe it was due to connection time.

            I also tried using direct path but that failed as well.

             

            Database is in NOARCHIVELOG mode and I have 6x100M redo log groups.

             

            Any ideas or help appreciated!

             

             

            ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support


            Additional clues will exist in alert_SID.log file

            • 3. Re: Error SQLLDR-643 Unable to insert records beyond a certain point
              jgarry

              $ oerr ora 29701

              29701, 00000, "unable to connect to Cluster Manager"

              // *Cause: Connect to CM failed or timed out.

              // *Action: Verify that the CM was started.  If the CM was not started,

              //          start it and then retry the database startup. If the CM died

              //          or is not responding, check the Oracle and CM trace files for

              //          errors.