Just wondering if anyone has got Transparent Application Failover to
work with PHP. I've compiled the php using --with-oci8-instant-client
and the TNS_NAMES environment variable is has been set to the path of
my tnsnames.ora. I've also installed sqlplus.
This works as I am able to connect using names given in the
tnsnames.ora file.
Using sqlplus I connect and do a
SELECT host_name from v$instance;
this returns
node1
i then shutdown the database on node 1 from a remote host and execute
the query the result is now
node2
I'm also able to shutdown the dbmid query and the correct result is
returned.
This is all handled by OCI8
When i try to replicate this in php I get an end of communication
channel which is correct really, but Oracle TAF should handle this for
me.
Thanks in avance for your help,
Carlos
As it does in SQL plus is this correct ?
work with PHP. I've compiled the php using --with-oci8-instant-client
and the TNS_NAMES environment variable is has been set to the path of
my tnsnames.ora. I've also installed sqlplus.
This works as I am able to connect using names given in the
tnsnames.ora file.
Using sqlplus I connect and do a
SELECT host_name from v$instance;
this returns
node1
i then shutdown the database on node 1 from a remote host and execute
the query the result is now
node2
I'm also able to shutdown the dbmid query and the correct result is
returned.
This is all handled by OCI8
When i try to replicate this in php I get an end of communication
channel which is correct really, but Oracle TAF should handle this for
me.
Thanks in avance for your help,
Carlos
As it does in SQL plus is this correct ?