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:
Note: Check with your DBA for assistance locating the files and identifying the services.
Old KB# 14640
#EnterpriseAnalyzer
#SupportTip
