DB connection terminated

empower_1
empower_1
in Software Products
We are working with citrix environment. Past few days we r getting the ora-03113 error but we don't see any DB distraction. This error is coming while working with empower application. 

Comments

  • ydan1977
    ydan1977
    Try this :smile:
    https://support.waters.com/Special:Search?qid=&fpid=230&fpth=&path=&q=ORA-03113
  • JCarter280
    JCarter280
    Since it's a generic error you need to gather more details. Are there any Windows event logs (system and App) on the client/server/DB that correspond to the time? Is this just one user or multiple? Same questions for general troubleshooting. Look for memory issues or long times not rebooted.
    A google may help;
    ORA-03113: end-of-file on communication channel
    Cause: The connection between Client and Server process was broken. It may also happen if the external agent extproc crashes for some reason.
    Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.


    Search for any recent logs under empower\oracle\ path on client and Citrix server. Knowing the latency and network performance may help too. 
  • Dan_Ramlose
    Dan_Ramlose
    That's a drawback to working with Citrix servers - one more layer of potential dropped comms.
    In the end, all it means is that Oracle lost track of your session. Typically, either a Citrix server rebooted, the application server rebooted, a VMHost server for either VM rebooted or someone tripped over a cable that disconnected you from the application server (any switch, any cable).
    The other drawback to Citrix is that if that's the source of the comms issue, you can't get it back until you get the session manually closed out or it times out (typically 15').

Categories