Every time our Oracle database shutdown for maintenance, we have to shutdown the application. Is there anyway we can avoid that such that the application can reconnect itself to Oracle as soon as the database is up?
Delphi 6 + Oracle 8i
How to enable the application automatically connect to DB
Try to solve this problem with Transparent Application Failover. It can be
useful when Oracle server shutdowns suddenly. You need to configure Oracle
client (please see Oracle documentation) and use TOraSession.OnFailover.
The last versions of ODAC 5.10 can reconnect automatically during executing
SQL statement if Oracle server was restarted. Unfortunately, here you will
lose uncommitted transactions and cannot fetch additional records from opened
TOraQuery.
useful when Oracle server shutdowns suddenly. You need to configure Oracle
client (please see Oracle documentation) and use TOraSession.OnFailover.
The last versions of ODAC 5.10 can reconnect automatically during executing
SQL statement if Oracle server was restarted. Unfortunately, here you will
lose uncommitted transactions and cannot fetch additional records from opened
TOraQuery.