Home » RDBMS Server » Server Utilities » ORA-03135: connection lost contact
ORA-03135: connection lost contact [message #276033] Tue, 23 October 2007 13:01 Go to next message
Messages: 226
Registered: March 2007
Senior Member
I have a script to load the data using SQL Loader which is running from the application server and fails after inserting some records with the following err:
SQL*Loader-643: error executing INSERT statement for table XR.GR_BLOCK

ORA-03135: connection lost contact

SQL*Loader-643: error executing INSERT statement for table REX.GROUP_BLK

ORA-03135: connection lost contact

SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
Specify SKIP=3712 when continuing the load.


3712 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.

Space allocated for bind array: 214656 bytes(64 rows)

Read buffer bytes: 1048576

Total logical records skipped: 0
Total logical records read: 3776
Total logical records rejected: 0
Total logical records discarded: 0

Run began on Mon Oct 22 19:52:49 2007
Run ended on Mon Oct 22 19:53:04 2007

Elapsed time was: 00:00:14.34
CPU time was: 00:00:00.03

Can anyone tell me what could be the problem?

Re: ORA-03135: connection lost contact [message #276048 is a reply to message #276033] Tue, 23 October 2007 14:39 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-03135: connection lost contact
 *Cause:  1) Server unexpectedly terminated or was forced to terminate.
          2) Server timed out the connection.
 *Action: 1) Check if the server session was terminated.
          2) Check if the timeout parameters are set properly in sqlnet.ora.

Previous Topic: import whole database
Next Topic: Sequence Issues After Export / Import
Goto Forum:

Current Time: Wed Aug 23 16:35:14 CDT 2017

Total time taken to generate the page: 0.03116 seconds