dbTalk Databases Forums  

where to set the Oracle timeout? ORA-02396: exceeded maximum idletime

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss where to set the Oracle timeout? ORA-02396: exceeded maximum idletime in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jobs
 
Posts: n/a

Default where to set the Oracle timeout? ORA-02396: exceeded maximum idletime - 11-16-2007 , 04:49 PM






I got this error while performing an ado.net call to an oracle
procedure that returns a dataset.

Exception of type 'System.Web.HttpUnhandledException' was
thrown.ORA-02396: exceeded maximum idle time, please connect again
System.WebSystem.Exception[]

The process maybe takes 2 to 3 seconds to come back to the webpage.

my vb.net method has cmd.timeout=0

Is my problem there? and is that in minutes or seconds.

My connection string has no timeout setting. Is there a default?

Thanks for any help or information.

Reply With Quote
  #2  
Old   
jobs
 
Posts: n/a

Default Re: where to set the Oracle timeout? ORA-02396: exceeded maximum idletime - 11-16-2007 , 04:54 PM






Forgot to mention. I only sometimes (actually very rarely) get the
displayed error. So apparently, some other factor on the db is likey
causing it. Where should I adjust my timeout?

Reply With Quote
  #3  
Old   
Michel Cadot
 
Posts: n/a

Default Re: where to set the Oracle timeout? ORA-02396: exceeded maximum idle time - 11-17-2007 , 12:32 AM




"jobs" <jobs (AT) webdos (DOT) com> a écrit dans le message de news: 853bd8aa-1194-425e-8f83-7674a4f6b243...oglegroups.com...
Quote:
I got this error while performing an ado.net call to an oracle
procedure that returns a dataset.

Exception of type 'System.Web.HttpUnhandledException' was
thrown.ORA-02396: exceeded maximum idle time, please connect again
System.WebSystem.Exception[]

The process maybe takes 2 to 3 seconds to come back to the webpage.

my vb.net method has cmd.timeout=0

Is my problem there? and is that in minutes or seconds.

My connection string has no timeout setting. Is there a default?

Thanks for any help or information.
Have a look at profiles.

http://download.oracle.com/docs/cd/B...0.htm#i2065930

Regards
Michel Cadot




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.