Skip to main content
Participant
March 13, 2009
Question

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

  • March 13, 2009
  • 1 reply
  • 2058 views
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....
This topic has been closed for replies.

1 reply

Inspiring
March 13, 2009
Did you google the error message?

--
Adam
March 16, 2009
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
Participant
March 20, 2009
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.....