Are you running an oracle database and JD Edwards. Do you ever get seemingly random ORA-03113 errors, and when they start they can often go downhill fast. I’ve blogged about this for a while, this error does occur on 11.2.0.4 and 12c database. Note also that you need to take a client patch, as it’s OCI that seems to have the issue.
I come across this all the time at big sites and the fix is great and easy.
2508/5060 WRK:DGTEST26_09632238_P01012 Thu May 19 14:15:49.932000 dbperfrq.c471
OCI0000178 - Unable to execute - SELECT MAOSTP, MAPA8, MAAN8, MASYNCS FROM UATDTA.F0150 WHERE ( MAOSTP = :KEY1 AND MAAN8 = :KEY2 ) ORDER BY MAOSTP ASC,MAAN8 ASC,MAPA8 ASC
2508/5060 WRK:DGTEST26_09632238_P01012 Thu May 19 14:15:49.932001 dbperfrq.c477
OCI0000179 - Error - ORA-03113: end-of-file on communication channel
Process ID: 115202
Session ID: 414 Serial number: 19786
2508/5060 WRK:DGTEST26_09632238_P01012 Thu May 19 14:15:49.932002 JDB_DRVM.C1005
JDB9900401 - Failed to execute db request
2508/5060 WRK:DGTEST26_09632238_P01012 Thu May 19 14:15:49.932003 JTP_CM.C1344
JDB9900255 - Database connection to F0150 (Business Data - UAT) has been lost.
2508/5060 WRK:DGTEST26_09632238_P01012 Thu May 19 14:15:49.932004 JTP_CM.C1298
JDB9900256 - Database connection to (Business Data - UAT) has been re-established.
http://shannonscncjdeblog.blogspot.com.au/2016/04/simple-post-about-oracle-clientsnot.html is a good summary about the fix.
Note that i’m currently fixing this at a site using exadata, same problem same everything!!
All windows this time, but still getting ORA-03113’s when I load up the system with OATS (Oracle Application Testing Suite).
Remember to NEVER trust windows find:
D:\JDEdwards\E910\log>findstr "ORA-03" *.log
jde_2508.log: OCI0000179 - Error - ORA-03113: end-of-file on communication channel
No comments:
Post a Comment