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