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=jdbc
racle:thin: @(DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-1vip)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-2vip)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ERP)))
Please let me know if this is the right way to configure ORACLE RAC for Alfresco.
Is there any way to configure datasources in Weblogic server and Alfresco connect to the database using JNDI of the datasources?
Thanks in advance.
SD
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=jdbc
racle:thin: @(DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-1vip)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-2vip)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ERP)))Please let me know if this is the right way to configure ORACLE RAC for Alfresco.
Is there any way to configure datasources in Weblogic server and Alfresco connect to the database using JNDI of the datasources?
Thanks in advance.
SD
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)
db.url=jdbc
racle: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)
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...
"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 ?
page 14 : http://www.oracle.com/technetwork/database/features/availability/maa-wp-11gr2-client-failover-173305...
"jdbc
racle: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 ?
