Intermittent ORA-12592 (TNS:BAD PACKET) and ORA-03137 [12333] When Running SQL*Loader or Any Jobs
(Doc ID 1905674.1)
Last updated on MARCH 31, 2022
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.
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.
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].
...
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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |