RE: [PHP-DB] Losing the ability to connect to Oracle database

Leo,

Please let me know how that works for you.  I don't remember the specifics
(if we where testing using plogon, nlogon or just logon), but we did try and
implement that fix and it didn't work for us. =20

Thanks,

Michael


-----Original Message-----
From: Leo D. Geoffrion [mailto:ldg@skidmore.edu]=20
Sent: Wednesday, April 20, 2005 6:03 AM
To: Michael Caplan
Subject: Re: [PHP-DB] Losing the ability to connect to Oracle database

Yes, I just found 30808.  It's suspended because the fix is stated in=20
the discussion (uncomment out a small section of oci8.c), but for=20
performance reasons they don't want to make this part of the standard code.

I've rebuilt php5 now with the change in place and will see if this=20
fixes the problem for my systems.  I can confirm that it's at least=20
harmless.


Michael Caplan wrote:

>Hi Leo,
>
>We are having the same problem.  Check out the bug I filed many months ago
>http://bugs.php.net/bug.php?id=3D30808  I can't for the life of me figure =
out
>why the bug is suspended, as this seems to be a common issue with Oracle
and
>php5.  Perhaps you should also and your comments to the bug report.
>
>To "resolve" the issue, we do an apache restart every time the db goes
down.
>This flushes whatever connections php pools to Oracle (sounds weird
>considering we are doing oci8nlogon).
>
>I really hope that the OCI8 library gets some serious attention soon.  In
my
>mind this is a show stopper, and it appears that there are a few other big
>ones lying around...
>
>Michael
>
>
>-----Original Message-----
>From: Leo D. Geoffrion [mailto:ldg@skidmore.edu]=20
>Sent: Tuesday, April 19, 2005 8:27 AM
>To: php-db@lists.php.net
>Subject: [PHP-DB] Losing the ability to connect to Oracle database
>
>I recently upgraded to PHP5 and now have a curious Oracle problem.
>
>The PHP scripts query the database fine.  Then overnight, the database=20
>shuts down for backup and restarts.  The next day, PHP can no longer=20
>connect to the database until I restart Apache.  Then, it's happy until=20
>Oracle restarts the next night.
>
>We did not encounter this problem with PHP4.
>
>I've tried adjusting the php command from the old ocilogon() to=20
>oci_connect() but the problem continues.  Incidentally, I am using a=20
>simple connection, not a persistent one.
>
>Can someone advise what's wrong here or how to get PHP/Apache to survive=
=20
>a database restart.
>
> =20
>

--=20
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
Leo D. Geoffrion, Ph.D.                       EMAIL:   ldg@skidmore.edu
Skidmore College Retiree                      PHONE:   518 580-0555

Currently:
Senior Systems Administrator
SGS Testcom Inc.
2911 Route 9
Ballston Spa, NY 12020
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D



CONFIDENTIALITY NOTICE
This message contains confidential information intended only for the use of
the individual or entity named as recipient. Any dissemination, distribution
or copying of this communication by anyone other than the intended recipient
is strictly prohibited. If you have received this message in error, please
immediately notify us and delete your copy. Thank you.

AVIS DE CONFIDENTIALIT=C9
Les informations contenues aux pr=E9sentes sont de nature privil=E9gi=E9e et
confidentielle. Elles ne peuvent =EAtre utilis=E9es que par la personne ou
l'entit=E9 dont le nom para=EEt comme destinataire. Si le lecteur du pr=E9s=
ent
message n'est pas le destinataire pr=E9vu, il est par les pr=E9sentes pri=
=E9 de
noter qu'il est strictement interdit de divulguer, de distribuer ou de
copier ce message. Si ce message vous a =E9t=E9 transmis par m=E9garde, veu=
illez
nous en aviser imm=E9diatement et supprimer votre copie. Merci.

It worked!

I did not need to restart apache this morning in order to get an oracle
connection.


Michael Caplan wrote:
> Leo,
>
> Please let me know how that works for you.  I don't remember the specifics
> (if we where testing using plogon, nlogon or just logon), but we did try a
nd
> implement that fix and it didn't work for us.
>
> Thanks,
>
> Michael
>
>
> -----Original Message-----
> From: Leo D. Geoffrion [mailto:ldg@skidmore.edu]
> Sent: Wednesday, April 20, 2005 6:03 AM
> To: Michael Caplan
> Subject: Re: [PHP-DB] Losing the ability to connect to Oracle database
>
> Yes, I just found 30808.  It's suspended because the fix is stated in
> the discussion (uncomment out a small section of oci8.c), but for
> performance reasons they don't want to make this part of the standard code
.
>
> I've rebuilt php5 now with the change in place and will see if this
> fixes the problem for my systems.  I can confirm that it's at least
> harmless.
>
>
> Michael Caplan wrote:
>
> 
>
> and
> 
>
> down.
> 
>
> my
> 
>
>