Log in to the ColdFusion admin page.
Navigate to Data Sources-> Create a new DSN -> Select Other as a driver.
Set up a DSN using a service name
There are situations where you need to set up a DSN for Oracle database (RAC) using service name instead of SID. In such situations, use a JDBC connection string to define the DSN.
Log in to the ColdFusion admin page.
Navigate to Data Sources-> Create a new DSN -> Select Other as a driver.
Specify the following settings:
jdbc:macromedia:oracle://hostname:port;ServiceName=servicename;AlternateServers=(alternatehostname:port);ConnectionRetryCount=2; ConnectionRetryDelay=5
Where,
Click Submit.