Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Failover doesn't work for Java clients, but works for SQL Plus
"DA Morgan" <damorgan_at_psoug.org> wrote in message
news:1150216249.325813_at_bubbleator.drizzle.com...
> Andreas Sheriff wrote:
> > You are connecting to the server, LOCALHOST, not the service. Look at > this TNSNAMES entry for comparison. > > TSTCD = > (DESCRIPTION = > (ADDRESS=(PROTOCOL = TCP)(HOST = vipgamma1.psoug.org)(PORT = 1521)) > (ADDRESS=(PROTOCOL = TCP)(HOST = vipgamma2.psoug.org)(PORT = 1521)) > (ADDRESS=(PROTOCOL = TCP)(HOST = vipgamma3.psoug.org)(PORT = 1521)) > (ADDRESS=(PROTOCOL = TCP)(HOST = vipgamma4.psoug.org)(PORT = 1521)) > (LOAD_BALANCE = yes) > (CONNECT_DATA = > (SERVER = DEDICATED) > (SERVICE_NAME = TSTC) > ) > ) > > Note the connection is to the VIP. > -- > Daniel A. Morgan > University of Washington > damorgan_at_x.washington.edu > (replace x with u to respond) > Puget Sound Oracle Users Group > www.psoug.org
I'm sorry.
My bad.
I forgot to mention that I was tunneling through SSH to the vip from
localhost:1522-> vip1:1521 and localhost:1523->vip2:1521
SQLPlus uses failover, PHP uses failover, but Java does not. And it doesn't matter whether I'm tunneling or connecting from inside the network.
The connections load balance well, but gv$session shows that failover is not active.
Thanks,
-- Andreas Oracle 9i Certified Professional Oracle 10g Certified Professional Oracle 9i Certified PL/SQL Developer "If you don't eat your meat, you cannot have any pudding. "How can you have any pudding if you don't eat your meat?!?!" --- WARNING: DO NOT REPLY TO THIS EMAIL Reply to me only on this newsgroupReceived on Tue Jun 13 2006 - 12:28:06 CDT