Oracle 8i client load balancing
Posted: Wed Oct 08, 2003 3:40 pm
PHP 4.3.3, Apache 1.3.28, Oracle 8i client
We're having a problem with PHP apps not recognizing the load_balance=on in the tnsnames. The connection works and load balances properly using interactive sqlplus but fails with ORA-12197 when using PHP with this in the tnsnames:
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=on)
If we change tnsnames to read:
(DESCRIPTION =
(LOAD_BALANCE=on)
(ADDRESS_LIST =
then PHP doesn't complain, but no load balancing takes place with sqlplus or PHP.
This worked with PHP 4.2.2 and Apache 1.3.26 and the 8.0.6 Oracle client.
Any suggestions?
We're having a problem with PHP apps not recognizing the load_balance=on in the tnsnames. The connection works and load balances properly using interactive sqlplus but fails with ORA-12197 when using PHP with this in the tnsnames:
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=on)
If we change tnsnames to read:
(DESCRIPTION =
(LOAD_BALANCE=on)
(ADDRESS_LIST =
then PHP doesn't complain, but no load balancing takes place with sqlplus or PHP.
This worked with PHP 4.2.2 and Apache 1.3.26 and the 8.0.6 Oracle client.
Any suggestions?