NOTICE: Our Community is moving. Get more information. Updated information on a New Login Process
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 <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.