Forum Discussion

Ron_Chennells_7's avatar
Ron_Chennells_7
Icon for Nimbostratus rankNimbostratus
Sep 10, 2010

Connections via F5 vip hangs

I have a two node oracle setup that I need to load balance between node1 and node2

 

both with listeners on port 1522.

 

 

I've having trouble connecting via the f5 vip that has been set up for me.

 

 

From the network teams view point the vip is passing traffic through.

 

 

However from the dba view point when I try to connect via telnet or oracle tnsping via the f5 vip I don't get through

 

 

I have set the listeners to drop connections after 60 seconds of inactivity

 

 

When I telnet to the ports directly the connection is dropped after a minute.

 

 

When I go via the load balancer vip it never drops and I have to kill the telnet job.

 

 

In this case after 4 and a half minutes or so.

 

 

[oracle@host2][FAILTEST]/shared/oracle/scripts $timex telnet host1 1522

 

Trying...

 

Connected to host1 Escape character is '^]'.

 

Connection closed by foreign host.

 

real 1:00.19

 

user 0.00

 

sys 0.01

 

 

[oracle@host2][FAILTEST]/shared/oracle/scripts $timex telnet host2 1522

 

Trying... Connected to host2.

 

Escape character is '^]'.

 

Connection closed by foreign host.

 

real 1:00.15

 

user 0.00

 

sys 0.01 .

 

 

[oracle@host2][FAILTEST]/shared/oracle/scripts $timex telnet f5vip 1522

 

Trying... Connected to f5vip .

 

Escape character is '^]'.

 

Command terminated abnormally. <- Killed the job from another session here

 

real 4:39.14

 

user 0.00

 

sys 0.00

 

 

The Oracle tnsping utilty has similar results. It hits the listener in 10msecs when I do directly

 

but times out via the f5vip

 

 

Any ideas ?

 

 

Thanks Ron

 

2 Replies

  • Can you explain a bit more what your issue is?

     

     

    You're unable to telnet to the VIP port? Or traffic isn't getting sent from the F5 to your servers?
  • Chris_Akker_129's avatar
    Chris_Akker_129
    Historic F5 Account
    Hi Ron, we have just published a deployment guide for configuring the BIG-IP for use with oracle database and RAC. This might be a good place to start. I would suggest you look it over, and talk it over with your network people and see if the SQLnet setting and TCP settings on the F5 match up.

     

     

    You can find the deployment guide at f5.com/oracle, in the database section. Good luck and let us know how it goes.

     

     

    -Chris.