Notifications
Clear all
Topic starter
We are on EMR 9.8.11. One of our providers is receiving the below error. Does anyone know what this means and how to resolve it?
Open: ORA-03114; not connected to ORACLE
OK
You have to click OK numerous times before it will finally go away.
Posted : May 18, 2016 4:19 am
From https://docs.oracle.com/cd/B19306_01/win.102/b14306/appendixb.htm.
ORA-03114: not connected to ORACLE
Cause: The connection between Client and Server process was broken. This may also happen if the external agent extproc crashes for some reason.
Action: There was a communication error which 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. There may be some system calls in the .NET function which might terminate the process. Remove such calls.
If it's only happening to one user, obviously it isn't a database issue. Network connectivity is a possible cause, but why only one user? I'd start with the machine that user has. Somehow connectivity to the database is being interrupted. Is it wifi or wired?
Posted : May 18, 2016 4:31 am
Topic starter
His device is a local install of EMR and is wireless.
Posted : May 18, 2016 6:14 am
There are obviously many possible causes for a broken network connection. The wifi could be disconnecting/reconnecting, there may NIC driver updates that address a problem, and so on.
You might want to start a continuous ping to the device and wait to see if it fails. I expect the pings will start failing around the same time he gets the Oracle error.
Posted : May 18, 2016 6:33 am
Topic starter
Thank you for the advice and information. We will do some review.
Posted : May 19, 2016 3:45 am
Take a look at his TNSNAMES.ORA file. Maybe something is messed up with it. You can try the TNSPING utility to try and check the connection.
Posted : June 2, 2016 10:45 am
