Skip to main content
Participant
March 2, 2017
Question

ColdFusion 2016 Enterprise: dB Connection to Oracle 12 via Service Name (no SID)

  • March 2, 2017
  • 1 reply
  • 1736 views

I need to add a dB connection to our new ColdFusion 2016 Enterprise server to an Oracle 12 dB using the service name instead of a SID.   If I put the service name into the SID field or leave the SID field blank I get an error.   Does anyone know how this is done?

ORA-12505
Connection refused, the specified SID (XXXXXX) was not recognized by the
Oracle server.

This topic has been closed for replies.

1 reply

JFCarrollAuthor
Participant
March 2, 2017

I got the following info from Adobe which appears to work (so far anyway).   I have added it here in the hope that it helps others out whom may run into the same issue.

From: CF Install
Sent: Thursday, March 02, 2017 8:02 AM
To: Carroll, James F
Cc: CF Install


Subject: CF2016-Service name mapping

Hi Jim,

Navigate to Data
& Services > Datasources > Other and Specify the following settings:

  • JDBC URL - jdbc:macromedia:oracle://hostname:port;ServiceName=servicename;AlternateServers=(alternatehostname:port);ConnectionRetryCount=2;ConnectionRetryDelay=5 (servicename,a
         name that is typically composed of the database name and domain name, is
         used to specify connections to Oracle RAC because the nodes in a RAC
         system share a common service name. AlternateServers is a comma separated
         list of servers and port names.)
  • Driver
         class - macromedia.jdbc.MacromediaDriver
  • Username - A
         user defined to the database
  • Password - The
         password for the username

Thanks,

Vikram