This discussion is archived
1 Reply Latest reply: Jan 7, 2013 6:35 AM by Srini Chavali-Oracle RSS

Oracle RAC + deployment on websphere

983282 Newbie
Currently Being Moderated
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.

Legend

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