Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

On Thu, Jan 27, 2011 at 4:04 AM, John Scoles <[email protected]> wrote:

>  On 26/01/2011 3:35 PM, Bill Ward wrote:
>
>> On Wed, Jan 26, 2011 at 12:27 PM, John Scoles<[email protected]>  wrote:
>>
>>> Or, is there some way to verify the OCI environment and reset it when
>>>> it is found to be unusable - in other words, trap the
>>>> "OCIHandleAlloc(OCI_HTYPE_ERROR)" error and reconnect?
>>>>
>>>>  Well normally an environment will not die unless you loose
>>> connectivity.  If
>>> you have lost connectivity then there would not be much point in trying
>>> to
>>> reconnect automatically your network or DB is Down??
>>>
>> Databases go down sometimes.  There could be a power failure or
>> hardware crash, or maybe the DB is just being bounced by the DBAs
>> after making a configuration change or upgrade.  The problem is even
>> if the database comes back up, it still keeps generating the same
>> error.  Why should I also have to manually restart the Apache server
>> just because the database has come back online?
>>
> That's odd, Are you using Apache::DBI ??? Which version of DBD::Oracle and
> OCI are you using?
>
>
Nope.  These apps were written long before Apache::DBI was a twinkle in
Edmund's eye.

We're using DBI 1.607, DBD::Oracle 1.22, and Apache 2.2.9 with mod_perl
2.000004

I don't know about OCI in particular but we're using Oracle database version
10.2.0.4.0.

                                                    <#>
<#>
<#>        <#>