cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting Alfresco to Oracle 11g on a RAC server

rootcd
Champ in-the-making
Champ in-the-making
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.

("jdbcSmiley Surprisedracle:thin:@edhusracd001-vip:1521:alfd01", "uname","pwd");

The TNS listener is expecting a Service_name and what is being sent is a SID

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.
1 REPLY 1

colindstephenso
Champ in-the-making
Champ in-the-making
I am in the process of configuring Alfresco and Oracle.  From the supported stack looks like we should use the keyword "oci" rather than "thin" for 11g.

also is "alfd01" the name of the SID that would be in the tnsnames.ora file?

Regards,
Colin.