AV in module ORA804.dll after long working

[Piyush Jain]

Hi,

I got following error from my server(using DOA):
Access violation at address 011E4306 in module 'ORA804.dll'. Read of address FFFFFFF8

Server is using DOA 4.0.5.0
Server was working from about 24 hrs.

I know that this error is cause due to some problem with ORA dll.
After restarting the server application, server works fine.

I want to know how can I reload the ORA dll if such exception occur without causing any problem to DOA working?

 

[Marco Kalter]

It may be difficult to clean up everything if Oracle Net is raising access violation exceptions. What you would have to do is:

1. Disconnect all session(s).
2. Call DLLExit (in the OracleCI unit).
3. Reconnect your session(s).

Note that it may also be a good idea to upgrade Oracle Net to 8.0.5 or later, because 8.0.4 was not the most stable Oracle Net version.

 

[Piyush Jain]

Is it not possible that I block all the call to Oracle (ofcourse from DOA) and call DLLExit (to unload the DLL) and then call DLLInit (to reload the DLL)?

If I have multiple TOracleSession then are they using same handle of ORA dll?

Can you tell me from where I can download the upgrade version of Oracle Net? I was unable to find it on net.