portal entry

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

How to configure DSN using service name for Oracle 12c RAC in CF2016?

| View in Portal
October 18, 2017 05:29:22 PM GMT
You may come across a situation where you need to set up a DSN for Oracle database(RAC) using service name instead of SID. In such scenario, you could use JDBC connection string to define the DSN. In this article, we will see how to set up DSN using service name in two simple steps. Log in to CF admin page -> Navigate to Data Sources-> Create a new DSN -> Select “Other” as  driver. Specify the following settings: jdbc:macromedia:oracle://hostname:port;ServiceName=servicename;AlternateServers=(alternatehostname:port);ConnectionRetryCount=2; ConnectionRetryDelay=5 […]
Labels: Blog, ColdFusion