• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

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

New Here ,
Mar 02, 2017 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.6K

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
community guidelines
New Here ,
Mar 02, 2017 Mar 02, 2017

Copy link to clipboard

Copied

LATEST

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

Votes

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
community guidelines
Resources
Documentation