Highlighted

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

New Here ,
Mar 02, 2017

Copy link to clipboard

Copied

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.

TOPICS
Database access

Views

1.4K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

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

New Here ,
Mar 02, 2017

Copy link to clipboard

Copied

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.

TOPICS
Database access

Views

1.4K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 02, 2017 0
New Here ,
Mar 02, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 02, 2017 0