Connecting Alfresco to Oracle 11g on a RAC server

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2009 06:32 PM
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
racle: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.
("jdbc

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.
Labels:
- Labels:
-
Archive
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2012 09:26 AM
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.
also is "alfd01" the name of the SID that would be in the tnsnames.ora file?
Regards,
Colin.
