[Macromedia][Oracle JDBC Driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified

[amirullail]

Hi All
I'm using CF 8, when i try to connect my application to Oracle RAC 10g Release 2, i receive this error :
"Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified"

Previously when i connect using this old datasource setting there's no problem to connect to the application :
Data & Services > Datasources > Oracle
CF Data Source Name : kewangan
SID Name : S021
Server : 10.1.101.11 Port : 1521
User name : spb
Password : XXXXXXX

This is my datasource setting for Oracle RAC :
Data & Services > Datasources > Other

CF Data Source Name : kewangan
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;loadBalancing=true
Driver Class : macromedia.jdbc.MacromediaDriver
Driver Name :
User name : spb
Password : XXXXXXX

Can somebody help me to connect to Oracle RAc 10g Release 2....

[Newsgroup_User]

Did you google the error message?

--
Adam

[Guest]

Amirullail,
Do you have the Oracle client installed on your CF server? You should have the SQL*Plus tool as part of the install; use the SQL*Plus to try to connect from the CF server to the Oracle server. Make sure you can connect in this way before you even try CF.
Your SID name is S021, but I don't see where that went to in the CF datasource definition.
Scott

[amirullail]

Hi All...TQ for the advice and reply
By the way, i have solve this issue by applying the latest patch for Oracle 10g Release 2 RAC. After applying those path, all off sudden i can connect from my application to that RAC database.....