4 Replies Latest reply: Jul 22, 2013 1:06 AM by alpyanar RSS



      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

          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

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

              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

                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.