ORA-03114: not connected to ORACLE

[nlbvita]

Hi,

here is description of a problem we have with PL/SQL Developer :

1. the application is started and some queries are executed.

2. We leave application opened for some time (10 minutes or more) and switch to other tasks and use other applications.

3. After some time we execute already opened query again and then everithig freezes for maybe half a minute, ORA-03114 appears.

4. After we click "Ok" in dialog window, everything is back to normal again.

Here is a debig file, with latest entry as a result of ORA-03114 error :

PL/SQL Developer
Version 8.0.4.1514
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Physical memory : 2.097.152 kB (1.466.740 available)
Paging file : 4.194.304 kB (3.551.620 available)
Virtual memory : 2.097.024 kB (2.031.488 available)

5.10.2011 10:14:03 NavigationBookmarks.EnableButtons(Rebuild)
5.10.2011 10:14:03 NavigationBookmarks: Backward=10, Forward=0
5.10.2011 10:14:03 TOracleQuery $02D5FFD0 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
5.10.2011 10:14:22 TOracleQuery $02D5FFD0 End
Result = ORA-03113: end-of-file on communication channel
Duration = 18,828
5.10.2011 10:14:22 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
5.10.2011 10:14:22 TOracleQuery Query End
Result = ORA-03114: not connected to ORACLE
Duration = 0,016
5.10.2011 10:14:22 NavigationBookmarks.EnableButtons(Rebuild)
5.10.2011 10:14:22 NavigationBookmarks: Backward=10, Forward=0
5.10.2011 10:14:27 SQLForm 99 rows selected in 0,141 seconds
5.10.2011 10:14:28 SQLForm 99 rows selected in 0,141 seconds

 

[Marco Kalter]

This might indicate that either the session was killed, or that your user has a resource profile with a limited IDLE_TIME.

 

[nlbvita]

Hi,

thank you for your answer.

The session was not terminated by me, or anyone else. The user has unlimited idle time in its profile.

Regards,

Vajo

 

[Marco Kalter]

Maybe the Oracle Server process for the current session has crashed. Can you check if a user trace dump file exist on the database server that corresponds to this ORA-03114 error? Usually you will see an ORA-00600 error here, with some error codes that may help us find the cause of the problem. If it does, can you send it to me?