Hi All
We are using Oracle client 11.2.0.1 from ETL servers to Oracle source DB. Sometimes the jobs are failing and below errors/warning are noticed in client side. Need expert advice on how can we fix this issue, upon checking with DBA team we were informed that no memory/cpu spike was noticed in source db. We also did not notice mush spike above 85% in ETl servers where the client is installed.
We have also upgraded the Oracle client to 12.1.0.2.0 in test env and still face similar issues. No pattern was noticed, these errors occur randomly across any of the source db.
Kindly advice how can I resolve the issue.
Trace files created at client side.
Dump file E:\Oracle\client\log\diag\clients\user_<USERACCOUNT>\host_2699986917_80\incident\incdir_33\ora_3520_2648_i33.trc
Dump continued from file: E:\Oracle\client\log\diag\clients\user_<USERACCOUNT>\host_2699986917_80\trace\ora_3520_2648.trc
oci-24550 [2147483649] [Unhandled exception: Code=80000001 Flags=0
] [] [] [] [] [] [] [] [] [] []
========= Dump for incident 33 (oci 24550 [2147483649]) ========
Tracing is in restricted mode!
----- Short Call Stack Trace -----
dbgexPhaseII()+976<-dbgexProcessError()+3008<-dbgeExecuteForError()+65<-dbgePostErrorDirect()+2448<-kpeDbgSignalHandler()+297<-skgesig_Win_UnhandledExceptionFilter()+173<-0000000077779460<-0000000077993398<-00000000779185C8<-0000000077929D2D<-00000000779191CF<-0000000077951248<-00000000752EE4A5<-00000001801F4297<-00000001801D47C9<-00000001801DF668<-00000001801DFD20<-00000001801DCE96<-0000000180076D96<-00000001800878B6<-0000000140002266<-0000000140002ADA<-000000014000F9F0<-00000000776F652D<-000000007792C541----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
End of Incident Dump
2@2|2|IuyngWLw1"3520_2648|
host_2699986917_80|
TRM file along with trace files.
02s06%dbgrimbid_begin_incdump
*dbgrim.c*MD1v1QrpyngWLw1"
C5001$e3filename`S1|0:EU1X5"
EK006$Error Stack*330P"
C4001$3b1B"
UK$030L"
AHs6M1$a1incident_id`2Se1incident_pk`MW:dbgexProcessError*diag_dde*dbgex.
c*incident_dump*1EJ21
80m01$dbgexPhaseII*7LW
EG006$short_call_stack_dump*1Ba
7?3Q9"l5I
MI00G$03-10
EG006$Event Triggered Actions*1Vi
UG$06f
AGs1M$dbgerRunActions*dbger.c*DDE Actions*1kJa
C$RO
!0P
QH00G$Z1act_exec_duration`1Y:0uMn
Q0q4H$dbgexEndIncident*4PNM
Regards
Manish Singh