How To Connect CF9 to Oracle DB with Svs Name/No SID

Forum|Forum|13 years ago
October 28, 2012
1 reply
3540 views

Running CF9 64-bit on Win Server 2008 R2, and all my Oracle connections have SIDs. Just got a new Oracle DB that I need to connect to, but doesn't have a SID, it has a Service Name. Was unabl to connect using the default ORACLE connector in CF9.

Have read thru messages, but am still not clear on how to add an Oracle server with a Service Name and not a SID. Would appreciate any help/advice on the correct syntax for using OTHER, if this is the best (or only) way to add this type of Oracle DB connection.

I've successfully added OTHER connections for Teradata and IBM-DB2, but I knew that was the direction to go, and was able to obtain the info, syntax, etc. for creating these OTHER (JDBC) connections. Thank you.

Gary

Database access

This topic has been closed for replies.

BKBK

Community Expert

What error message do you get when you attempt to set up the data source in the administrator, using ORCL as the SID?

A

Anonymous

Thanks for the reply. If I don't enter anything in the SID box, I get "SID NOT RECOGNIZED." If I enter the Service Name in the SID box, I still get the same "SID NOT RECOGNIZED."

I think Oracle 11g uses (to some degree or entirely) Service Names and not SIDs. In doing research, it sounds like until CF9 is updated so you can add an Oracle database with a Service Name and not a SID, these have to be entered as OTHER.

As mentioned, I've done several "OTHER" configurations, one for Teradata and one for IBM-DB2. But never Oracle. Am trying to find an example of where someone has successfully configured an Oracle DB using OTHER, and to learn the syntax for filling out the various boxes required by "OTHER."

I also need to know if, in order to install an Oracle DB using OTHER, will I need to download and install any Oracle "client" software? Currently, I have not downloaded or installed any Oracle software, drivers, clients, etc. Have not had a need to, since CF9 had everything you needed for Oracle DB connections that use SIDs.

If I need to install any Oracle software, drivers, clients, etc., need to know what to download and install for a JDBC/OTHER connection using CF9.0.1, on both 32 and 64-bit Windows 7 machines, and 64-bit Windows Server 2008 R2.

Thanks for any help/advice. Much appreciated.

Gary

BKBK

Community Expert

Gary1 wrote:
Thanks for the reply. If I don't enter anything in the SID box, I get "SID NOT RECOGNIZED." If I enter the Service Name in the SID box, I still get the same "SID NOT RECOGNIZED."

My question was, what happens when you enter ORCL in the SID box?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.