Skip to main content
Participant
February 18, 2009
Question

Can macromedia cold fusion version 7.0.0 support oracle RAC

  • February 18, 2009
  • 1 reply
  • 1010 views
Hi
I try to connect to oracle RAC 10g using this macromedia cold fusion. Below are the details of my macromedia cold fusion :
Server Product ColdFusion MX
Version 7,0,0,91690
Edition Enterprise

Can it be done???
If cannot, can someone advice me how to connect to Oracle RAC 10g using macromedia CF
This topic has been closed for replies.

1 reply

Inspiring
February 18, 2009
amirullail wrote:
> Hi
> I try to connect to oracle RAC 10g using this macromedia cold fusion. Below
> are the details of my macromedia cold fusion :
> Server Product ColdFusion MX
> Version 7,0,0,91690
> Edition Enterprise
>
> Can it be done???

Yes.

> If cannot, can someone advice me how to connect to Oracle RAC 10g using
> macromedia CF

We'll need more information about the specific problem you're having:
http://www.catb.org/~esr/faqs/smart-questions.html#beprecise .

--
Mack
Participant
February 20, 2009
TQ Mark for the advice. Let me detailing out the situation :

One of my application need to connect to Oracle 10.2.0.3 RAC

This is the entry that i enter in the CF Administrator :
DSN = kewangan
Driver=other
JDBC URL=jdbc:macromedia:oracle://dbl01-vip.dbp.gov.my:1521;ServiceName=orcl_taf.dbp.gov.my;AlternateServers=(dbl02-vip.dbp.gov.my:1521);ConnectionRetryCount=2;ConnectionRetryDelay=5
Driver Class = macromedia.jdbc.MacromediaDriver
Driver Name = none
user = xxx
login = xxx

tnsnames.ora in oracle client entry :
kewangan =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbl01-vip.dbp.gov.my)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = dbl02-vip.dbp.gov.my)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl_taf.dbp.gov.my)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)

When i click the "Submit" button, its ok. I receive this message "datasource updated successfully."

So when i go to access my sistem, when i try to login, i receive this error from my browser :
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified