Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Modifying Oracle files to prevent MW termination when a network connection is lost

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.

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

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 18:15
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.