oddness... yeah, no need for Oracle client install and tnsnames on the server, but the tnsnames entry is helpful for filling out the DSN info in CFAdmin.
Is this new Oracle install a RAC? No SID with that. see this http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0 info near the bottom DK On 5/12/06, Brian Kotek <[EMAIL PROTECTED]> wrote: > If you're using the JDBC drivers that come with CF to connect to Oracle, I > don't think you need a tnsnames.ora file at all. You set all the necessary > parameters right in the CF datasource admin: the SID name, the server, the > port, and if desired the user name and password. > > On 5/12/06, Eddie Trinidad <[EMAIL PROTECTED]> wrote: > > > > 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:240382 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
