Skip to main content

Describes how to modify listener.ora and tnsnames.ora to prevent MW termination when a network connection is lost.

Problem:

MW terminates unexpectedly with the error "ORA-3114: Not Connected to Oracle” when a computer with an open MW session is disconnected from the network. The error results when the <localhost> value in the Oracle files listener.ora and tnsnames.ora is qualified with a domain name. When the network connection is lost, Oracle can no longer find the domain.

Resolution:

If you are performing MW tasks over a long period of time and are concerned about losing your work in the event of a network disconnect, you can remove the domain name from listener.ora and tnsnames.ora. In both files, change HOST=<localhost>.<domain> to HOST=<localhost>, then restart the Oracle services:
  1. Choose Start > Settings > Control Panel > Administrative Tools > Services (or its equivalent on your system).
  2. In the Services window, select the Oracle listener service and choose Action > Start, then select the Oracle database service and choose Action > Start.
Note: Check with your DBA for assistance locating the files and identifying the services.
Old KB# 14640

#EnterpriseAnalyzer
#SupportTip
Terms & ConditionsAccessibility statement