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.
Specify the following settings:
- 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 - a comma-separated list of servers and port names.
- Driver class –
macromedia.jdbc.MacromediaDriver. Enter the name of the driver in the Driver Name field(Optional).
- Username – A
user defined tothe database
- Password – The password for the username