ORA-03114: Not Connected to Oracle tips Oracle Database Tips by Donald Burleson

The "ORA-03114: Not Connected to Oracle" error is commonly found when there is a problem with the network connectivity.  The docs note:

ORA-03114 not connected to ORACLE

Cause: A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may also happen if communication trouble causes a disconnection.

Action: Try again. If the message recurs and the program is user written, check the program.

Common causes for the ORA-03114 error include:

• Webserver or listener process is not running

• Missing entry to the tnsnames.ora

• Network issues

• Problems with connection pooling (shared servers, MTS)

Also, see my notes on troubleshooting network errors in Oracle.

 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.