ORA-03113: end-of-file on communication channel error - Please Help

User_KOLMZ

Content

Hi All,


In last few months, for the second time we are facing one quite strange issue. Random users, with random reports (or some user with all reports) are facing following error message and code:

We had technical SR (3-20715306161) where we bounce the server at one point of time which still didnt fix the issue. Issue was gone after 3,4 days.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 3113, message: ORA-03113: end-of-file on communication channel Process ID: 246507 Session ID: 6224 Serial number: 29851 at OCI call OCIStmtExecute: BEGIN fnd_session_mgmt.attach_session('9861821953AF9216E0534C8D630A8F6D'); END;. (HY000)

State: HY000. Code: 17011. [nQSError: 17011] SQL statement execution failed. (HY000)

 

Now we are having the same problem, it does impact less people  accross the globe (Germany, UK, Singapore) than the previous time, but at still reports are erroring quite randomley and also some users cannot run any. Clearing cache/ logging in out does not solve a problem.

Users on the front end are just sseeing error - Please contact your system Adminsitrator where back in the logs we are seeing the error from above.

Did anyone face similar issue in the past or at the moment and are there are any recommendation/ ideas how to solve it and what could be the rootcause?


Regards,
Janko

Aman Jain-Oracle

Hello Janko,

Please refer to the below oracle support documentation:

Fusion OTBI - OTBI Reports Return Error: ORA-03113: end-of-file on communication channel (Doc ID 2585601.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=1073552235616521&id=2585601.1&displayIndex=3&_afrWindowMode=0&_adf.ctrl-state=duxjec3g3_267#SYMPTOM 

Hope this helps!

Best Regards,
Aman Jain

User_KOLMZ

Hi Aman,

Thank you on this and apologies on delayed response. It seems it worked! Thank you so much!

Aman Jain-Oracle

Happy to help