It is definitely possible. We have LVS sitting in front to balance all requests, including email, web, etc. Then on the web nodes we have Apache mod_proxy sending back to Oracle servers. LVS doesn't cut it with multiple web node Oracle servers because of how persistence works, where Apache works just fine.
We have two LVS balancers (one acting as failover) and two Apache servers, but only one Apache server balances back to Oracle. We have this set up through the front-end balancers as they pass one routable IP to standard web traffic on both servers, and a second routable IP to pass Oracle traffic to a single Apache node. We then weight the non-Oracle Apache node higher since it is not handling Oracle balancing (and SSL encryption to Oracle for that matter).
Standard traffic:
Users -> Internet -> Firewall -> LVS -> Apache0 (Weighted heavier)
-> Apache1
-> Email0
-> Email1
-> Other Services
Oracle traffic:
Users -> Internet -> Firewall -> LVS -> Apache1 -> Oracle Web0
-> Oracle Web1