This discussion is archived
4 Replies Latest reply: Jul 21, 2013 11:06 PM by alpyanar RSS


Bob Explorer
Currently Being Moderated

Hi All,


Can we create a multidatasource on a normal database, i mean if we are not using RAC database.




  • 1. Re: multidatasource
    Vijaya Moderator -Oracle Expert
    Currently Being Moderated

    Multidatasource is a feature in Oracle Weblogic Server to connect to a RAC  Database and to leverage the loadbalancing and failover capabilities.


    It may not serve the purpose to configure a multidatasource to a non RAC database.


    Instead you can choose to use GenericDataSource to connect to a non RAC Database.


    Hope this answers your question!!




  • 2. Re: multidatasource
    Bob Explorer
    Currently Being Moderated

    we want to do this only for testing purpose, in our current env. we have normal database, but in prod we have RAC DB and multidatasource.

    we want to convert generic datasource to multidatasource and test some tuning parameters.

    so is it possible, if we create generic datasource pointing to same DB and create multidatasource, pointing these two generic datasouce,

  • 3. Re: multidatasource
    Joe Weinstein Expert
    Currently Being Moderated

    Yes you can, no problem, except that you will have sole responsibility for ensuring consistency between the data in the multiple datasources.

  • 4. Re: multidatasource
    alpyanar Explorer
    Currently Being Moderated

    As i know, multi data source can be used for two or more physical databases. If you have only one physical db, you dont need to create multi data source.

    By using multi data source you can use two or more db at the same time or you can use it for failover situations.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points