Occasional ORA-12592 (TNS:BAD PACKET) and ORA-03137 [12333] When Running SQL*Loader Jobs (Doc ID 1905674.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Net Services - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 04-Jan-2016***

Symptoms

When running several SQL*Loader jobs on 11.2.0.4 or higher, you notice that sometimes one of the jobs fails with following errors:

Record 592545: Rejected - Error on table MY_TAB.
ORA-12592: TNS: Bad Packet

SQL*Loader-604: Error occurred on an attempt to commit
ORA-03113: end-of-file on communication channel
Process ID: 16057148
Session ID: 3541 Serial number: 47955

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


The alert logfile shows the following error:

...
Sat Jul 05 11:42:48 2014
Errors in file /oracle_base/diag/rdbms/ORCL/ORCL/trace/ORCL_ora_16057148.trc  (incident=247676):
ORA-03137: TTC protocol internal error: [12333] [50] [9] [7] [] [] [] []
Incident details in: /oracle_base/diag/rdbms/ORCL/ORCL/incident/incdir_247676/ORCL_ora_16057148_i247676.trc
Sat Jul 05 11:42:52 2014
Dumping diagnostic data in directory=[cdmp_20140705114252], requested by (instance=1, osid=16057148), summary=[incident=247676].
...

The errors are occasional: if the load is re-run then it is likely that the sqlldr job now succeeds without errors.

Other possible errors:

ORA-25408: can not safely replay call
ORA-25402: transaction must roll back
ORA-12152: TNS:unable to send break message
ORA-12592  TNS: Bad Packet

 

Changes

You recently upgraded to 11.2.0.4 and are loading data to the database server with SQL*Loader.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms