1 Reply Latest reply on Aug 19, 2009 6:30 PM by byron1021

    CF Admin -Data Source Q

    emmim44 Level 1

      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...

        • 1. Re: CF Admin -Data Source Q
          byron1021

          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