Hi,
When you reboot the Oracle Database are you rebooting the machine or just restarting
the oracle process. If it is the later then you might try restarting the Orcle
Listener as well.
I have noticed that sometimes the listener keeps open a connection to the now
restarted database and this can cause issues as Apache::DBI can not spot it unlessit
pings first. Assuming that your ping time is set to 0 then this should be spotted.
Hope this helps
Paddy
PS. Previously I have posted patches to the current Apache::DBI to handle :-
Limiting time a connection can be cached.
Limiting number of connections that can be cached
Correct handling of begin_work and Auto-commit
Correct resetting of other attributes LongTruncOk etc.
I would be grateful for feedback on these patches.
Thanks
Paddy
On Thu, Oct 09, 2003 at 07:32:39AM -0400, Levon Barker wrote:
> Hello,
>
> Excuse me if there is a better list for this but...
>
> Every time I reboot my Oracle database, my mod_perl server is not able to
> connect to the db until I restart the apache server.
>
> I am using Oracle 9.12, Apache::DBI 0.92, Apache 1.3.28.
>
> I get the following entry in the Apache error log:
>
> DBD::Oracle::st execute failed: ORA-03114: not connected to ORACLE (DBD
> ERROR: OCIStmtExecute) [for Statement "
> BEGIN
> :amt :=
> RA_TEST.CURRENCY_CONVERT(56, 8, 1,
> '31-MAY-03');
> END;
> " with ParamValues: :amt=undef] at
> /perl_modules/CurrencyManager.pm line 58.
>
> My understanding is that Apache::DBI is supposed to establish a new
> connection if the cached connection is invalid.
>
> Any thoughts on this would be great.
>
> Thanks,
> Levon Barker
>
