Bug #16502 Updated: OCIPLogon does not reconnect to restarted Database

From: Date: Sat, 13 Apr 2002 13:21:20 +0000
Subject: Bug #16502 Updated: OCIPLogon does not reconnect to restarted Database
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-4885@lists.php.net to get a copy of this message 
 ID:               16502
 Updated by:       thies@php.net
 Reported By:      bmironov@jonview.com
 Status:           Closed
 Bug Type:         OCI8 related
 Operating System: RedHat 7.2
 PHP Version:      4.1.2
 New Comment:

hack:
change your tnsnames.ora to include a failover to the same db.
PROD=(
    DESCRIPTION=(
        ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))
       
(CONNECT_DATA=(SID=PROD)(failover_mode=(backup=PROD)(type=session)(method=basic)(retry=100)(delay=60)))
)

this will make the Net8 client to reconnect automagically



Previous Comments:
------------------------------------------------------------------------

[2002-04-13 09:20:49] thies@php.net

hack:
change your tnsnames.ora to include a failover to the same db.
PROD=(
    DESCRIPTION=(
        ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))
       
(CONNECT_DATA=(SID=PROD)(failover_mode=(backup=PROD)(type=session)(method=basic)(retry=100)(delay=60)))
)

this will make the Net8 client to reconnect automagically


------------------------------------------------------------------------

[2002-04-08 23:16:52] bmironov@jonview.com

Hello,

I have an issue between PHP and Oracle. As soon as I have to restart
database I have to do same for Apache. If I will not do that my session
will retrieve error message about "end-of-file coonection". I agree
that some of child processes in Apache can be in this status. But I
guess, that it is possible to track that OCIPLogon tries to connect to
DB through dead connection. That can trigger whole "connection process"
to run again. It is better than wait for administrator to restart whole
web server. I prefer OCIPLogon for small SELECT's because of
performance issue.

I tried to solve this issue with   apache_child_terminate() but
received message that it is disabled somehow (I even have no idea how
to enable it)

My environment is:
RedHat 6.1 / 7.2
Apache 1.3.23
PHP 4.1.2  (--with-oci8)
Oracle 8.1.5 client
remote Oracle7 and Oracle8.1.5 databases


Thanks for any advise,
Boris
bmironov@jonview.com

------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=16502&edit=1

Thread (9 messages)

« previous php.bugs (#4885) next »