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.
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?