Forum Discussion
Ron_Chennells_7
Nimbostratus
Sep 10, 2010Connections 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
- Chris_Miller
Altostratus
Can you explain a bit more what your issue is? - Chris_Akker_129Historic F5 AccountHi 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.
Recent Discussions
Related Content
DevCentral Quicklinks
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com
Discover DevCentral Connects