Re: Apache::DBI & Oracle Not Reconnecting

2003-10-10 Thread Perrin Harkins
On Thu, 2003-10-09 at 07:32, Levon Barker wrote: > 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. Are you opening connections to Oracle before Apache forks (in startup.pl)? I've had problems like this when I did tha

Re: Apache::DBI & Oracle Not Reconnecting

2003-10-10 Thread Patrick Mulvany
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 ca