Oracle Oledb problem when application pool restarts

Hi,

I have an ASP.Net application hosted in a windows server 2003 (IIS
6.0). The application uses a Oracle Database to retrieve some data
through an Oledb connection. I've set the IIS application pool used by
the application to get recycled when the application consumes too much
memory which it ocasionally does and I don't want the server to hang.

After this I stress the application to know it's performance and
monitor it's scalability. The problem I have is that the application
works well until that memory limit is reached, then the IIS recycles
the application pool used by the app but after that, the following
requests get an exception:

"Oracle client and networking components were not found. These
components are supplied by Oracle Corporation and are part of the
Oracle Version 7.3.3 or later client software installation. Provider is
unable to function until these components are installed"

All the requests after the application pool has been restarted get that
exception and we must manually restart the IIS with a iisreset command
to repair the application's behaviour. After the IIS has been fully
restarted, everything works well again.

Could anybody help me with this situation ? Why is this error happening
and is there any solution to it ? Thanks in advance for everything, any
help will be appreciated.

ori

re: Oracle Oledb problem when application pool restarts

ori schrieb:[color=blue]
> Hi,
>
> I have an ASP.Net application hosted in a windows server 2003 (IIS
> 6.0). The application uses a Oracle Database to retrieve some data
> through an Oledb connection. I've set the IIS application pool used by
> the application to get recycled when the application consumes too much
> memory which it ocasionally does and I don't want the server to hang.
>
> After this I stress the application to know it's performance and
> monitor it's scalability. The problem I have is that the application
> works well until that memory limit is reached, then the IIS recycles
> the application pool used by the app but after that, the following
> requests get an exception:
>
> "Oracle client and networking components were not found. These
> components are supplied by Oracle Corporation and are part of the
> Oracle Version 7.3.3 or later client software installation. Provider is
> unable to function until these components are installed"[/color]
I suggest you ask this in an oracle forum like comp.databases.oracle.misc.

Lots of Greetings!
Volker