topic Connecting Alfresco to Oracle 11g on a RAC server in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/connecting-alfresco-to-oracle-11g-on-a-rac-server/m-p/241928#M195058 <HTML><HEAD></HEAD><BODY><SPAN>Does anyone have any experience connecting Alfresco to an Oracle 11g DB on a RAC server. I'm getting errors when using the below connection string.</SPAN><BR /><BR /><SPAN>("jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@edhusracd001-vip:1521:alfd01", "uname","pwd");</SPAN><BR /><BR /><SPAN>The TNS listener is expecting a Service_name and what is being sent is a SID</SPAN><BR /><BR /><SPAN>I'm getting a "SID not recognized" error. From this same server, I can sqlplus to the database, and my dba has confirmed that the connection string above is accurate. I've also written a little java app that only tests db connections, and I can connect to several 10g DBs, but get the listener error when trying to connect to 11g DBs.</SPAN></BODY></HTML> Wed, 25 Nov 2009 23:32:05 GMT rootcd 2009-11-25T23:32:05Z Connecting Alfresco to Oracle 11g on a RAC server https://connect.hyland.com/t5/alfresco-archive/connecting-alfresco-to-oracle-11g-on-a-rac-server/m-p/241928#M195058 Does anyone have any experience connecting Alfresco to an Oracle 11g DB on a RAC server. I'm getting errors when using the below connection string.("jdbc<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@edhusracd001-vip:1521:alfd01", "uname","pwd");The TNS listener is expecting a Service_name and what is being sent is a SIDI'm getting Wed, 25 Nov 2009 23:32:05 GMT https://connect.hyland.com/t5/alfresco-archive/connecting-alfresco-to-oracle-11g-on-a-rac-server/m-p/241928#M195058 rootcd 2009-11-25T23:32:05Z Re: Connecting Alfresco to Oracle 11g on a RAC server https://connect.hyland.com/t5/alfresco-archive/connecting-alfresco-to-oracle-11g-on-a-rac-server/m-p/241929#M195059 <HTML><HEAD></HEAD><BODY><SPAN>I am in the process of configuring Alfresco and Oracle.&nbsp; From the supported stack looks like we should use the keyword "oci" rather than "thin" for 11g.</SPAN><BR /><BR /><SPAN>also is "alfd01" the name of the SID that would be in the tnsnames.ora file?</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Colin.</SPAN></BODY></HTML> Tue, 26 Jun 2012 13:26:27 GMT https://connect.hyland.com/t5/alfresco-archive/connecting-alfresco-to-oracle-11g-on-a-rac-server/m-p/241929#M195059 colindstephenso 2012-06-26T13:26:27Z