I said: > For some functions we use the native Oracle 8.0 drivers supplied with CF 5.0 Enterprise to access Oracle 8i. They worked fine till Monday, now none of them work and they will not verify.
Dave said: > Perhaps there were some network changes made? > > You might try connecting from the CF server console using SQL*Plus. Janet said: >What are you seeing in the CF logs (server, application, exception) when the lost queries are happening? On the Oracle side, what are they seeing in the listener.log file? Resolution: Turns out our sqlnet.ora file was bad. Once we copied in a correct one all of our native data sources started to work again. Funny thing is it appears we had been using this bad sqlnet.ora file since June without seeing the problems that started on Monday . . . There was nothing in any of the CF logs except an occasional unresponsive thread in the server.log file. There was nothing in the listener.log file but that got us to look at the sqlnet.ora file which is where we found a problem. Thanks! George ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183903 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
