Can css load balancing oracle sql queryes?

Unanswered Question
Jul 19th, 2007

We have 2 Oracle database servers.

We need to switch sql querys between them.

Can we use Cisco CSS?

Or maybe we need some other solution?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
catliao Thu, 07/19/2007 - 08:31


Are you looking to a) load balance specific type of query to a particular server? Or are you simply looking to b) distribute traffic to the two servers regardless of query type? The latter is basically L4 switching and supported by CSS (though you do need to make sure that the db knows how to properly replicate records with each other). a) is basically generic protocol parsing and is not supported on the CSS today.


rvv Thu, 07/19/2007 - 12:12


We need load balance traffic, but we need load balance all type of query type ( updates etc...)

What i wanna to know is how CSS will work with dynamic port allocation scheme in oracle?

Oracle use not only 1525/tcp.

And how to keep user on one server when user can establish multiple tcp connections during one trnsaction?

catliao Thu, 07/19/2007 - 18:11

Have you looked at using a sqlnet proxy to enable the consolidation of dynamic ports? Another approach to this would be to load balance traffic destined to a vip only rather than vip:port. You can maintain sticky based on source ip.

rvv Fri, 07/20/2007 - 22:12

Thnx! I think sticky based on source ip will help to solve dynamic ports.

What is sqlnet proxy?

catliao Mon, 07/23/2007 - 07:34

sqlnet proxy is a feature that is part of some firewalls designed to address the dynamic ports in sqlnet.


This Discussion