1 Reply Latest reply: Jan 8, 2013 12:49 AM by P.Forstmann RSS

    Oracle RAC + deployment on websphere

    983282
      I have an java application deployed on websphere that is using Oracle. Datasource are created in websphere using URL like this:
      jdbc:oracle:thin:@DBSERVER_NAME:1521:DB_NAME

      Now, that we plan to move move to oracle rac, I learnt that we need to make change to datasource like this:

      jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
      (HOST=DBSERVER1_NAME)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)
      (HOST=DBSERVER2_NAME)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME
      =DATABASE_SERVICENAME)))


      would that be enough, or I need to make other changes as well from application perspective.


      Another thing is that application deployment is done through ant scripts, which at the moment copies some data on /tmp/.. folder on db server and then run db scripts. These scripts make some ddl changes and some record updates. Now with rac implementation, these scripts will be run on one of the rac node(instances), so do I need to run these ddl scripts/record updates scripts on other node in oracle rac or oracle rac would take care of this automatically.
        • 1. Re: Oracle RAC + deployment on websphere
          P.Forstmann
          980279 wrote:
          Now, that we plan to move move to oracle rac, I learnt that we need to make change to datasource like this:

          jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
          (HOST=DBSERVER1_NAME)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)
          (HOST=DBSERVER2_NAME)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME
          =DATABASE_SERVICENAME)))


          would that be enough, or I need to make other changes as well from application perspective.
          What is your 4 digits Oracle version on database side and on client side ?
          If you are using 11.2 on database side, are you using SCAN listener ?
          Which Automatic Workload Management features are used by your application ? (see http://docs.oracle.com/cd/E11882_01/rac.112/e16795/hafeats.htm).

          >
          Another thing is that application deployment is done through ant scripts, which at the moment copies some data on /tmp/.. folder on db server and then run db scripts. These scripts >make some ddl changes and some record updates. Now with rac implementation, these scripts will be run on one of the rac node(instances), so do I need to run these ddl >scripts/record updates scripts on other node in oracle rac or oracle rac would take care of this automatically.
          A RAC database has several database instances but only one database: you only need to run SQL scripts on one instance.