Modifying Oracle files to prevent MW termination when a network connection is lost
Describes how to modify listener.ora and tnsnames.ora to prevent MW termination when a network connection is lost.
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 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.
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=. to HOST=, then restart the Oracle services. Check with your DBA for assistance locating the files and restarting the services.
Incident Number: 2280964