Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-3114 error

902206Nov 25 2011 — edited Nov 26 2011

Please help on this issue which i am confronting.

We have 3 tier application. if the application is not used for a couple of hours
the connection is getting disconnected. When checked the application log
it was showing ora-3114 error. I loged in as sqlplus from the client system and issued a sql 'select sysdate from dual' after some couple of hours again i tried to issue the same sql its started throwing

SQL> /
select sysdate from dual
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 19040
Session ID: 971 Serial number: 17043

Database RAC 11.2.0.2
OS OEL 5.6
Client 11.2.0.1
OS Windows Server 2008R2

Any help on this is appreciated.

Thanks
-Dave

Edited by: 899203 on Nov 25, 2011 8:53 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2011

Added on Nov 25 2011

#general-database-discussions

7 comments

5,914 views