ColdFusion 5.0 Enterprise is using?
Are there updated native (and ODBC for that matter) Oracle drivers available
for CF 5.0?
All of a sudden we cannot maintain our Oracle connectivity using the native
drivers (haven't yet tried switching to the ODBC drivers). All data sources
using these drivers are failing, even ones that we have not used when the
failures occur. If we restart the ColdFusion Application service we get back
our connectivity for just a few minutes before all the Oracle data sources
go down again (the CF Application service still shows as running and CF
still appears to be functioning normally after the data sources go down, we
just discovered that restarting the service restores the Oracle connectivity
- for a few minutes) and the pattern repeats all through the day. When the
Oracle data sources in CF Admin are down we can still connect to Oracle
using the Oracle tools on the server. DB2 data sources and Excel data
sources are not affected and continue to function normally.
The only change (and it's a big one!) to our environment is that last
Wednesday our Oracle database moved to a new bigger and faster server. It
was not a db upgrade, just a move to a new box. We had no problems Thursday
and Friday and the performance improved dramatically. When we left Friday
everything was just fine. When we came in Monday morning we could not keep
the Oracle connections through ColdFusion open.
Our Oracle folks say they see nothing on their end that would be causing us
to lose our connectivity (they've taken a trace which they sent off to
Oracle). We have had the usual load to the web server since the problem
started.
We're using CF 5.0 Enterprise for Windows, Windows 2000 Advanced Server, IIS
5.0 on a quad-processor 700MHz server with 4GB RAM hitting Oracle 8i. Limit
simultaneous requests is set to 7. This setup has given us absolutely no
problems for two years . . . until now . . .
Any ideas what could be causing our Oracle native drivers to keep failing
and how to fix them?
George
[EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
