DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2001

    Can you have load balancing with Failsafe?

    Can you load balance with Oracle Failsafe? In a metalink note it says the following:
    Fail Safe has two principal uses:

    Allows an Oracle database, Oracle Forms, or Oracle Reports to run on either node of a cluster, for continued availability in the event of node downtime.
    Shares workload between the cluster nodes, eliminating the need to have a standby machine that, typically, is idle and thus underutilized.

    but this has confused me as I thought with Oracle Failsafe, only 1 node can access the database at one time.

  2. #2
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    You are correct, you can only access the database from one node at a time. And no, you can not have true load balancing with Fail Safe.

    What they probably mean in that article on Metalink is this:
    - You have one database instance and one Oracle Forms/Reports server. They can be running:
    a) each on separate server (which impose you have two machines)
    b) both on the same server (which impose you have only one machine)

    Now you want to be prepared for any failure, so you configure two machines in two-node cluster and install Fail Safe on top of that.

    Now if your previous configuration was a), then now you would still run database instance and Forms server on separate machines, but now each of those two machines act as a bacup node for the other node in a cluster.

    If your previous configuration was b), then now you would have much higher availability and at the same time you are balancing your load somehow - one server will take a load of database server and the other one will take load of Forms server.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.