| ORA-03135: connection lost contact [message #276033] |
Tue, 23 October 2007 13:01  |
caprikar
Messages: 226
Registered: March 2007
|
Senior Member |
|
|
Hi,
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.
Table XR.GR_BLOCK:
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?
Thanks,
GK
|
|
|
|
| Re: ORA-03135: connection lost contact [message #276048 is a reply to message #276033] |
Tue, 23 October 2007 14:39  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
