Page 1 of 1

Oracle 8i client load balancing

Posted: Wed Oct 08, 2003 3:40 pm
by rdbdba
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?

Posted: Thu Oct 09, 2003 7:35 am
by rdbdba
OK folks, the problem was that PHP was linking in libclntsh.so.1 instead of libclntsh.so.8 when compiled with the 8i client.