in reply to Re^2: Oracle 10g Database Connection Trouble
in thread Oracle 10g Database Connection Trouble
Or, you can put something likemy $dbConnectString = 'dbi:Oracle:' . '(LOAD_BALANCE=on)'. '(ADDRESS=(PROTOCOL=TCP)(HOST=myhost1)(PORT=1521))'. '(ADDRESS=(PROTOCOL=TCP)(HOST=myhost2)(PORT=1521))'. '(CONNECT_DATA=(SERVICE_NAME=pcipJDBC.oracle.com))';
in your 'tnsnames.ora' file, and useSIMPLE= (DESCRIPTION= (LOAD_BALANCE=on) (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (PORT=1521) (HOST=al4.almg.uucp)) (ADDRESS=(PROTOCOL=TCP) (PORT=1521) (HOST=al4.almg.uucp)) ) (CONNECT_DATA= (SERVICE_NAME=pcipJDBC.oracle.com)) )
my $dbConnectString = 'dbi:Oracle:SIMPLE';
|
|---|