TOracleSession.Connected Hangs

[ddc]

We are running a 24/7 app. The DB goes down daily for 1.5 hours. During that time we catch and handle the errors. On a Oracle 9 client against the 8 DB, we occasionally have a situation where the session.connected := true hangs. no exception thrown. the app is running cause other threads are ok. the logs have indicated that an AV occurred on the oran9.dll on several previous nights, but the app recovers

What situation might occur where the connected := true happens

 

[Marco Kalter]

Maybe the AV's are a clue. Do you know what caused them?

------------------
Marco Kalter
Allround Automations

 

[ddc]

when the DB is down, and we try to connect,
the following AV occurs

Access violation at address 61491B37 in module 'oran9.dll'. Write of address 00000022

most of the time we get ORA-12541: TNS:no listener, or similar errors

 

[ddc]

Marco

Any idea or direction you can provide on where in the Connected procedure the app would/might hang (an oracle api function?). If this is an Oracle issue, it would help if I could provide precise information where this is occuring

DDC

 

[Marco Kalter]

I can only assume this is an Oracle Net / Server issue. You could enable SQL*Net client tracing to obtain an exact log file of the "TNS:no listener", maybe this provides a clue.

------------------
Marco Kalter
Allround Automations