DB is up but connection is down how??

[grtfercho]

We are using a Coldfusion 5.0 Server and from time time our users get a message

3114 ORA-03114: not connected to ORACLE

However when I try to login to the database using other Software(TOAD, SQL*PLUS) it connects without problems.

So I go to Coldfusion administrator and press the "verify all Connections" button. After that everything goes back to normal.

Any idea why is this happening and how I can solve this??

You help will be greatly appreciated



grtfercho çB^]\..
"Imagination is more important than Knowledge" A. Einstein

 

[csteinhilber]

If you look at all the connection settings in CF Administrator:

1) is "Maintain connections across client requests" checked?
2) is "Limit Connections" unchecked?
3) is "Restrict connections to" blank?

the above should all be true (unless there's a driving need to configure them otherwise... but, then, the tradeoff is you'll have situations like you're describing).

Also, what are the values for "Timeout" and "Interval". Ours are 20 and 7 respectively (which I believe is the default). And they've worked pretty well.



-Carl

 

[grtfercho]

All of the above is true with the exception of the Timeout and Interval.

I couldn't find something under those labels
I found "login timeout" and "Connection timeout" and they were blank and zero respectively.

However I think that we got it, in CFadministrator under Settings > Caching the
Limit cached database connection inactive time value was set to 30 minutes.

we changed to 0, that way the connection to the database doesn't die while the CF server is active.
Now we have to wait until tomorrow and see if this problem happens again.



grtfercho çB^]\..
"Imagination is more important than Knowledge" A. Einstein