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 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=. to HOST=, then restart the Oracle services. Check with your DBA for assistance locating the files and restarting the services.

Incident Number: 2280964

Date:
 
Name:
 
Description of change: 
Date:
 
Name:
 
Description of change: