Mailing-List: contact php-db-help@lists.php.net; run by ezmlm
Precedence: bulk
Message-ID: <A722EED83069D611AED200508B8B0D9106348C52@EXCHANGE>
From: Michael Caplan <michael.caplan@lechateau.ca>
To: "'John Lim'" <jlim@natsoft.com.my>
Cc: "'php-db@lists.php.net'" <php-db@lists.php.net>
Date: Thu, 18 Nov 2004 09:15:35 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C4CD79.1276D0D0"
Subject: RE: [PHP-DB] Re: oci8 cannot connect after restarting DB

------_=_NextPart_001_01C4CD79.1276D0D0
Content-Type: text/plain

Hi John,

Just saw your blog today on Andi's PHP5 / Oracle article.  

One of the two bugs you sited in your previous email was one that I opened
(http://bugs.php.net/bug.php?id=30808)  I'm not sure what the case is with
the 4.3.x line, but my hunch this issue is 'bigger' than PHP5.  More
troubling is tony2001 response to my bug report (we don't want to turn on
the noted fix, but will implement something workable with PDO).  I'm anxious
to hear his reply to my follow-up: it makes no sense to me that oracle users
will have to settle for broken logon functions (with the fix sitting
commented in the current code) or abandond the oci8 library all together for
PDO when it hits the streets (which will be some time).

Best,

Michael


-----Original Message-----
From: John Lim [mailto:jlim@natsoft.com.my] 
Sent: Thursday, November 18, 2004 3:42 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: oci8 cannot connect after restarting DB


Michael,

After rereading your post again, i realise you mentioned it's happening with

non-persistent connections also. That puzzles me. Perhaps we are talking 
about multiple bugs here. In general, I have not found PHP5 and oci8 to be 
very stable, and would not recommend moving anything production to use PHP5 
just yet.

Regardsd, John

"John Lim" <jlim@natsoft.com.my> wrote in message 
news:20041118072559.26084.qmail@pb1.pair.com...
> Hi
>
> This is because you are using persistent connections, which are left 
> dangling and do not restart after the database restarts. Apparently 
> you can hack your tnsnames.ora or oci8 extension.
>
> See http://bugs.php.net/bug.php?id=15390
>
> and http://bugs.php.net/bug.php?id=30808
>
> Regards, John
>
> "Michael Caplan" <michael.caplan@lechateau.ca> wrote in message
> news:A722EED83069D611AED200508B8B0D9106348C4E@EXCHANGE...
>> Every evening, for whatever reason, our Oracle db (9.2.0) is 
>> restated. After it is restarted, I am unable to build a connection 
>> with Oracle from PHP untill Apache is restarted.
>>
>> Whenever I do an ociplogon() or ocilogon() following an Oracle DB
>> restart,
>> it fails but I am unable to get a description of the error.  Restarting
>> Apache "fixes" the problem.
>>
>> Has anyone else experianced the same issue?  It appears to me that 
>> this
>> is a
>> php oci8 bug.  (shouldn't a new connection be built if a persistant
>> connection fails, and if not using persistant connections, shouldn't this

>> be
>> a non issue?)
>>
>> Thanks,
>>
>> Michael
>>
>> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



------_=_NextPart_001_01C4CD79.1276D0D0--