Problem with asp pages accessing database and internet access on web server

The strangest issue has started to occurr on our web server. We are
running:

Windows 2000 SP4
IIS 5.0
Oracle Client 9.2.0.4
Oracle ODBC 9.2.0.5
Oracle Data Provider for .NET 9.2.0.4 - recent install but machine ran
fine for several weeks before issue started.

The problem just started recently but the machine ran just fine
several months ago. Now every three or four days the ASP/.NET pages
that access the database fail to respond. ASP/.NET/HTML pages that do
not access the database all work fine. FTP works too whereas SMTP
fails. A related issue is that from the machine access to the
internet fails with a DNS error. It cannot access itself or any
outside web site like Google.

Note to self:
Next time it fails, check if it will resolve web sites or self via IP
Address & localhost.

This partial 'hang' seems to be rather consistent as the last three
weeks in a row it has always failed somewhere in the early AM on
Sunday and then again on Wednesday or Thursday.

I am looking for any and all suggestions.

Sincerely,

Tim Frawley

Egbert
Mon May 24 02:56:43 CDT 2004

Hi,

You can create a simple ASP page, that accesses the oracle database and
monitor the following performance counters (perfmon.exe)

Private Bytes (dllhost.exe that one that hosts your website or
inetinfo.exe), handles, threads, asp page requests per second
The difficult thing is finding the correct dllhost that your asp app runs
at. I always watch CPU activity (using ctrl-shift-escape) and choose the DLL
host that generates the most CPU activity.

If you succeeded, you can monitor your ole db performance.
If the private bytes/handles always go up, you have a clear memory leak.
Oracle is not unknown, delevering Ole db drivers that leak as hell :)

Two things to do,
1) ask Oracle for a fix
2) reset your website daily using a scheduled vbscript


--
compatible web farm Session replacement for Asp and Asp.Net
http://www.nieropwebconsult.nl/asp_session_manager.htm

"Tim Frawley" <tim_frawley@fishgame.state.ak.us> wrote in message
news:bfb6a0a.0405230814.5d4a593f@posting.google.com...
> The strangest issue has started to occurr on our web server. We are
> running:
>
> Windows 2000 SP4
> IIS 5.0
> Oracle Client 9.2.0.4
> Oracle ODBC 9.2.0.5
> Oracle Data Provider for .NET 9.2.0.4 - recent install but machine ran
> fine for several weeks before issue started.
>
> The problem just started recently but the machine ran just fine
> several months ago. Now every three or four days the ASP/.NET pages
> that access the database fail to respond. ASP/.NET/HTML pages that do
> not access the database all work fine. FTP works too whereas SMTP
> fails. A related issue is that from the machine access to the
> internet fails with a DNS error. It cannot access itself or any
> outside web site like Google.
>
> Note to self:
> Next time it fails, check if it will resolve web sites or self via IP
> Address & localhost.
>
> This partial 'hang' seems to be rather consistent as the last three
> weeks in a row it has always failed somewhere in the early AM on
> Sunday and then again on Wednesday or Thursday.
>
> I am looking for any and all suggestions.
>
> Sincerely,
>
> Tim Frawley