 |
|
ORA-03114: Not Connected to Oracle tips
Oracle Tips by Burleson Consulting |
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
- 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. |
