Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

susieqApr 10 2018 — edited Apr 10 2018

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!

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2018

Added on Apr 10 2018

#general-database-discussions

3 comments

576 views