Copy link to clipboard
Copied
I am stuck on how to connect coldfusion 11 with Oracle RAC any body can help on this.
Thanks
NAF
Copy link to clipboard
Copied
Datasource > Other
with JDBC URL:
jdbc:macromedia:oracle://(ORACLE SERVER):1521;SERVICENAME=(serviceName);sendStringParametersAsUnicode=false;MaxPooledStatements=1000;AlternateServers=(IP ADDRESS1),(IP address 2))
where I got (ORACLE SERVER); (serviceName);(IP ADDRESS1),(IP address 2) all of the needed actually data from the tnsnames.ora file
Driver Class: macromedia.jdbc.MacromediaDriver
other stuff like driver name and user name and password are the same as you used before.
I hope that helps
Copy link to clipboard
Copied
Hi NAF, did you find solution for this issue. Even we are facing the same with coldfusion 10 trying to connect to Oracle 11g.
where data source is connecting to database server. but failover is not working.
please help.