topic Re: ORACLE RAC configuration for Alfresco in Weblogic in Alfresco Archive

ORACLE RAC configuration for Alfresco in Weblogic

sdas — Fri, 11 Sep 2009 15:59:22 GMT

Hi,In my project I am using Alfresco with ORACLE RAC and Weblogic application server.I would like to know how can we confiure Alfresco for ORACLE RAC?Can I specify:db.url=jdbcracle:thin: @(DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-1vip)(PORT=1521)) (ADDRESS=(PROTOCOL=TC

Re: ORACLE RAC configuration for Alfresco in Weblogic

rmacian — Mon, 20 Jun 2011 07:50:07 GMT

I've tested a configuration against ORACLE 10g and 11g and it's working fine with:

db.url=jdbcracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip.red.dominio.es)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip.red.dominio.es)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=LAN_APLICACIONES.red.dominio.es)))

http://alfrescoadmin.blogspot.com/2011/06/configuracion-con-oracle-rac-10g-y-11g.html (Spanish)

Re: ORACLE RAC configuration for Alfresco in Weblogic

hbomb — Wed, 22 Jun 2011 03:09:31 GMT

Has anyone tested something similar to whats described in client failover bestpractice using SCAN_NAME for 11gr2 whcih eliminates the need to hardcode the specific hostnames/VIPs as described below?
page 14 : http://www.oracle.com/technetwork/database/features/availability/maa-wp-11gr2-client-failover-173305.pdf

"jdbcracle:thin:@" +
"(DESCRIPTION_LIST=" +
"(LOAD_BALANCE=off)” +
"(FAILOVER=on)"+ "(DESCRIPTION=" + "(ADDRESS_LIST=" + "(LOAD_BALANCE=on)" + "(ADDRESS=(PROTOCOL=TCP)(HOST=Austin-scan)(PORT=1521)))" + "(CONNECT_DATA=(SERVICE_NAME=alfresco)))" +
"(DESCRIPTION=" + "(ADDRESS_LIST=" + "(LOAD_BALANCE=on)" + "(ADDRESS=(PROTOCOL=TCP)(HOST= Houston-scan)(PORT=1521)))" + "(CONNECT_DATA=(SERVICE_NAME=alfresco))))";

Does Alfresco/Weblogic like to maintain affinity to specific nodes with regards to RAC or can we define the generic service across on or multiple nodes as above ?