topic Alfresco and Oracle RAC in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-and-oracle-rac/m-p/272852#M225982 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><SPAN>Alfresco also recommended to use OCI driver for JDBC-url. Here the example reported on alfresco support FAQ:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />db.url=jdbc:oracle:oci:@(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = OFF) (FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP)<BR />(HOST =HOST_1) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = HOST_2) (PORT = 1521)))<BR /> (CONNECT_DATA=(SERVICE_NAME = serviceName)(SERVER=DEDICATED)))<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>In my Test environment the OCI driver don't work!</SPAN><BR /><SPAN>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: </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />$ env | grep LIBRARY<BR />LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><PRE class="language-none line-numbers"><CODE><BR />$ sqlplus64&nbsp; alfresco/alfpasswd@rac-scan-name:1521/ora-service-name<BR />SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 31 11:22:51 2013<BR /><BR />Copyright © 1982, 2011, Oracle.&nbsp; All rights reserved.<BR /><BR />Connected to:<BR />Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<BR />With the Partitioning, Real Application Clusters, OLAP, Data Mining<BR />and Real Application Testing options<BR /><BR />SQL&gt; select * from cat;<BR /><BR />TABLE_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLE_TYPE<BR />—————————— ———–<BR />ACT_GE_BYTEARRAY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLE<BR />ACT_GE_PROPERTY &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLE<BR />ACT_HI_ACTINST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLE<BR />ACT_HI_ATTACHMENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLE<BR />ACT_HI_COMMENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLE<BR />ACT_HI_DETAIL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLE<BR />[…..blablablabla….]<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Using &lt;strong&gt;oci&lt;/strong&gt; driver and ojdbc6.jar don't work:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />### database connection properties ###<BR />db.driver=oracle.jdbc.OracleDriver<BR />db.username=alfresco<BR />db.password=alfpasswd<BR />db.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)))<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Here the log exception:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />2013-01-30 17:43:18,554&nbsp; WARN&nbsp; [hibernate.cfg.SettingsFactory] [main] Could not obtain connection metadata<BR /> org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory…. <BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Using &lt;strong&gt;thin&lt;/strong&gt; driver works fine:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />### database connection properties ###<BR />db.driver=oracle.jdbc.OracleDriver<BR />db.username=alfresco<BR />db.password=alf421<BR />db.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)))<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Someone managed to properly use OCI in db.url?</SPAN></BODY></HTML> Thu, 31 Jan 2013 11:45:40 GMT joe_l3 2013-01-31T11:45:40Z Alfresco and Oracle RAC https://connect.hyland.com/t5/alfresco-archive/alfresco-and-oracle-rac/m-p/272852#M225982 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 examp Thu, 31 Jan 2013 11:45:40 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-and-oracle-rac/m-p/272852#M225982 joe_l3 2013-01-31T11:45:40Z Re: Alfresco and Oracle RAC https://connect.hyland.com/t5/alfresco-archive/alfresco-and-oracle-rac/m-p/272853#M225983 <HTML><HEAD></HEAD><BODY><SPAN>Does Alfresco Enterprise trial Editon 4.2 comes with default scripts for Oracle.</SPAN><BR /><SPAN>I need to connect to Oracle with trail edition. Is it supported</SPAN></BODY></HTML> Wed, 07 May 2014 14:09:52 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-and-oracle-rac/m-p/272853#M225983 geostp 2014-05-07T14:09:52Z Re: Alfresco and Oracle RAC https://connect.hyland.com/t5/alfresco-archive/alfresco-and-oracle-rac/m-p/272854#M225984 <HTML><HEAD></HEAD><BODY><SPAN>Yes.</SPAN><BR /><BR /><SPAN>Please see the supported stacks list.&nbsp;&nbsp;&nbsp; </SPAN><BR /><BR /><A href="http://www.alfresco.com/services/subscription/supported-platforms" rel="nofollow noopener noreferrer">http://www.alfresco.com/services/subscription/supported-platforms</A></BODY></HTML> Thu, 08 May 2014 10:16:06 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-and-oracle-rac/m-p/272854#M225984 mrogers 2014-05-08T10:16:06Z