Hi,the Alfresco Support FAQ reports Oracle RAC this is not a feature Alfresco have tested hence it is not officially supported or documented, but it is being used successfully by several customers in Alfresco Enterprise Network.Alfresco also recommended to use OCI driver for JDBC-url. Here the example reported on alfresco support FAQ:db.url=jdbc:oracle:oci:@(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = OFF) (FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP)(HOST =HOST_1) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = HOST_2) (PORT = 1521))) (CONNECT_DATA=(SERVICE_NAME = serviceName)(SERVER=DEDICATED)))
In my Test environment the OCI driver don't work!I've configured a 2 nodes Oracle RAC 11.2.0.3 for Alfresco. Also the Oracle OCI and JDBC dirver is correctly installed on the alfresco machine, infact the sqlplus connection using alfresco user works fine: $ env | grep LIBRARYLD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
$ sqlplus64 alfresco/alfpasswd@rac-scan-name:1521/ora-service-nameSQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 31 11:22:51 2013Copyright © 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> select * from cat;TABLE_NAME TABLE_TYPE—————————— ———–ACT_GE_BYTEARRAY TABLEACT_GE_PROPERTY TABLEACT_HI_ACTINST TABLEACT_HI_ATTACHMENT TABLEACT_HI_COMMENT TABLEACT_HI_DETAIL TABLE[…..blablablabla….]
Using <strong>oci</strong> driver and ojdbc6.jar don't work:### database connection properties ###db.driver=oracle.jdbc.OracleDriverdb.username=alfrescodb.password=alfpasswddb.url=jdbc:oracle:oci:@(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = OFF) (FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP) (HOST = racnode01) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = racnode02) (PORT = 1521))) (CONNECT_DATA=(SERVICE_NAME = ora-service-name)(SERVER=DEDICATED)))
Here the log exception:2013-01-30 17:43:18,554 WARN [hibernate.cfg.SettingsFactory] [main] Could not obtain connection metadata org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory….
Using <strong>thin</strong> driver works fine:### database connection properties ###db.driver=oracle.jdbc.OracleDriverdb.username=alfrescodb.password=alf421db.url=jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = OFF) (FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP) (HOST = racnode01) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = racnode02) (PORT = 1521))) (CONNECT_DATA=(SERVICE_NAME = ora-service-name)(SERVER=DEDICATED)))
Someone managed to properly use OCI in db.url?
