tracker issue : CF-4204465

select a category, or use search below
(searches all categories and all time range)

Add the option to connect to Oracle databases using SERVICE_NAME instead of SID

| View in Tracker

Status/Resolution/Reason: Open//

Reporter/Name(from Bugbase): Dave I. / ()

Created: 05/29/2019

Components: Database, Oracle

Versions: 2016

Failure Type:

Found In Build/Fixed In Build: /

Priority/Frequency: Normal /

Locale/System: / Win 2016

Vote Count: 0

Oracle 18 is moving away from using SID identifiers in their listeners.  We need a way to create data sources that can connect to Oracle databases using the SERVICE_NAME instead.  Can you add this field as an optional data source parameter for the Oracle connections?

Currently the Oracle DBA team added a "SID as a SERVICE" option to work around the issue, and this allows ColdFusion to connect using the SID method.  They tell us this is a temporary fix, and will have to be resolved in the near future.