Copy link to clipboard
Copied
Hi all,
Can someone tell me the adv and disadv of 'Maintain Connections ' under CF Admin > Data & Services > Datasources > Oracle?
Note : yesterday we got ora -01000 error ...after cf server restart there were no ora errors...
Copy link to clipboard
Copied
Basically the connection to the database server stays open until the timeout in the admin, so the authenticate piece of the communication to the database doesn't have to be performed each time.
So you want to enable this, which is the default.
Not sure what the specific error is; however CF will drop all of it's DB connections on restart (graceful or not).
This seems like a good resource for oracle errors: http://www.ora-error.com/
The error you have seems like a max cursor error, so maybe CF fired off something and was still running after the restart. What was the cf restart reason? If it was stalled maybe the code is firing something off and doing some bad things. Have you seen the issue since or just on CF restart? How about the Oracle logs, do they indicate anything?
Byron Mann
mannb@hostmysite.com
byronosity@gmail .com
Lead Software Architect
hosting.com | hostmysite.com
http://www.hostmysite.com/ ?utm_source=bb