Oracle 8i client load balancing

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rdbdba
Forum Newbie
Posts: 2
Joined: Wed Oct 08, 2003 3:40 pm

Oracle 8i client load balancing

Post 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?
rdbdba
Forum Newbie
Posts: 2
Joined: Wed Oct 08, 2003 3:40 pm

Post 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.
Post Reply