We are using Oracle Apex application as a dashboard, we have created a DBLink to fetch our Apex based Dashboard results from EBS.
Often we come across an error mentioned below due to which the performance of our dashboard navigation hampers a lot. It will be helpful if you provide any assistance in this matter about the particular error. Different Error Details:
Error 1:
-----------
Error while executing statement: ORA-03150: end-of-file on communication channel for database link ORA-02063: preceding line from APEX
Error 2:
----------
Logging exception in final_exception_handler: Sqlerrm: ORA-20987: APEX - Error during rendering of page item YEARMANU. - ORA-04052: error occurred when looking up remote object SYS.SYS_STUB_FOR_PURITY_ANALYSIS@APEX ORA-00604: error occurred at recursive SQL level 3 ORA-28546: connection initialization failed, probable Net8 admin error ORA-02063: preceding line from APEX ORA-03150: end-of-file on communication channel for database link ORA-02063: preceding line from APEX Backtrace: ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 861 ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 896 ORA-06512: at "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", line 3285 ORA-06512: at "APEX_040200.WWV_FLOW_PAGE", line 1609 ORA-06512: at "APEX_040200.WWV_FLOW_PAGE", line 1814 ORA-06512: at "APEX_040200.WWV_FLOW_PAGE", line 1958 ORA-06512: at "APEX_040200.WWV_FLOW", line 5418
Error 3:
--------
Logging exception: Sqlerrm: ORA-20987: APEX - Error during rendering of page item YEARMANU. - ORA-04052: error occurred when looking up remote object SYS.SYS_STUB_FOR_PURITY_ANALYSIS@APEX ORA-00604: error occurred at recursive SQL level 3 ORA-28546: connection initialization failed, probable Net8 admin error ORA-02063: preceding line from APEX ORA-03150: end-of-file on communication channel for database link ORA-02063: preceding line from APEX Backtrace: ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 630 ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 911 ORA-06512: at "APEX_040200.WWV_FLOW_FORMS", line 1485 ORA-06512: at "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", line 4138 ORA-06512: at "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", line 4605
Error 4:
---------
Session Idle Time Exceeded, request:
Please Help.
Application Express 4.2.5.00.08