Skip navigation
mjsale
Currently Being Moderated

Using CF 8 with Oracle RAC environment

Oct 25, 2009 5:24 PM

Hello,

 

I am working with a client who uses Oracle as their Database.  This part is no issue.  However, they are running in a RAC environment.  I cannot see any way to setup the data source in the Admin to accommodate this redundancy.  Does anyone work with this type of environment?  PS - I am using the built in Oracle driver with CF 8 Enterprise.

 

Thanks, Mike

 
Replies
  • Currently Being Moderated
    Oct 25, 2009 6:04 PM   in reply to mjsale

    Hi Mike

    I've never had to do this before, but I just googled "jdbc orcle rac" and there's a whole swag of stuff covering it, and it seems reasonably straight fwd.

     

    Have you had a look through some of those links?

     

    --

    Adam

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 2, 2009 1:00 AM   in reply to mjsale

    You can connect to Oracle RAC by creating a new datasource and choosing the driver as *other* in CF admin.

     

    Please check the following post for more info.This is more specific to CF9 but I think this may work with CF8 also:-

    http://ozeetee.com/2009/11/using-coldfusion-9-with-oracle-real-applica tion-clusters-rac/

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 25, 2012 3:18 PM   in reply to mjsale

    I've gone down this road before with Oracle drivers. Re: CF8/CF9.....If you don't use the coldfusion enterprise version with the native driver, coldfusion is limited with how it can handle store procedure requests.

    In other words, the jdbc driver is free, and you get what you pay for.... save yourself the migrane...don't use it.

    Calling datasource within a RAC is just pointing to different instances as data source names within the <cfquery/> object.

     

    In a RAC environment, you'll have to create new seperate data source names,

    and use the native oracle driver for each one, pointing each name to a different oracle identifer (SID or whatever they use to seperate the instances).

    That should work.

    When you call your <cfquery/> you'll be using one of the datasource names. You can't call two different datasource names on the same query.

    Coldfusion is not designed to be a RAC.

    Coldfusion has it's own clustering functionality, but beware. It's complex and it has nothing to do with the oracle layer.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points