I use Delphi 6 with ODAC 5.5 with .Net option
My program run batch during the night. The treatments finish with 2h30 AM. When i try to use the program with access DB after a long moment of inactivity (for example at 9h30 AM), i have the error ORA-12571.
Does the DB access with .net option have a timeout parameter ?
ORA-12571 with .Net option
ODAC with Net=true does not have a connection timeout parameter. This error is equivalent to
ORA-03113 end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.
This error can happen if TCP connection is broken. Or possibly Oracle server break connection due to errors in traffic. Or this can happen if you try to execute unsupported operation (for example if you work with BLOB/CLOB column through RAW/LONG parameter)
ORA-03113 end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.
This error can happen if TCP connection is broken. Or possibly Oracle server break connection due to errors in traffic. Or this can happen if you try to execute unsupported operation (for example if you work with BLOB/CLOB column through RAW/LONG parameter)