This is covered in the following Adobe tech notes: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=42dcb10a http://www.adobe.com/support/documentation/en/coldfusion/mx701updater/oracle10g.html
>Good afternoon HOF users, > >I'm a first time poster and I'm a business analyst... >so I'm not that tech savvy. > >I maintain our office CF server Jacksonville that >links up with an network operation center in KC. > >Well they did this migration thing of Oracle 10g and >our webserver can't connect with Oracle. I tried to >modify the Data Source in the administration page but >I don't see an entry for Service_name (no more SID in >the tnsnames.ora file). So how do I add on the >service_name for an Oracle data source? > >http://127.0.0.1:8500/CFIDE/administrator/datasources/oracle.cfm?dsn=OCDB >has no service_name field. :( > >Thanks and have a good day. > >Eddie Trinidad >904-219-3288 >[EMAIL PROTECTED] >[EMAIL PROTECTED] > >Here's my troubleshooting trail: > >TNSNAMES.ORA > >OLD********************* > >jea.world = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = > (COMMUNITY = tcp.world) > (PROTOCOL = TCP) > (Host = 148.80.159.14) > (Port = 1526) > ) > > ) > (CONNECT_DATA = (SID = jea) > ) > ) > > > >NEW************************ > >jea.world = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = > (COMMUNITY = tcp.world) > (PROTOCOL = TCP) > (Host = 148.80.116.5) > (Port = 1526) > ) > > ) > (CONNECT_DATA = (SERVICE_DATA = jea) > ) > ) > > > ************ > > Error Message > > Connection verification failed for data source: OCDB > []java.sql.SQLException: [Macromedia][Oracle JDBC >Driver][Oracle]ORA-12505 Connection refused, the >specified SID (jea) was not recognized by the Oracle >server. >The root cause was that: java.sql.SQLException: >[Macromedia][Oracle JDBC Driver][Oracle]ORA-12505 >Connection refused, the specified SID (jea) was not >recognized by the Oracle server. > >__________________________________________________ >Do You Yahoo!? >Tired of spam? Yahoo! Mail has the best spam >protection around >http://mail.yahoo.com > >__________________________________________________ >Do You Yahoo!? >Tired of spam? Yahoo! Mail has the best spam protection around >http://mail.yahoo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
