Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAS best Practices for HA / Failover

Received Response
16
Views
3
Comments
User_AAYSI
User_AAYSI Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server
  1. can someone recommend the best practices for HA /Failover for OAS between 2 servers , Active/Active or Active/Passive
  2. I am trying to install a second instance over the same DB and getting an error that the STB have already been used
  3. Also for DR what is the recommendation if DB if Prod and DR DB are in sync and host DB connections names are name using alias

Answers

  • BalaGuddeti-Oracle
    BalaGuddeti-Oracle Rank 5 - Community Champion

    Hello,

    Active/ Active, Active/ Passive is design choice, that depends on how you want to steer the traffic.

    Here is blog on DR, which will gives design guidelines
    https://blogs.oracle.com/analytics/oas-dr-fsdr
    https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/deploy-high-availability.html

    Thanks

  • User_AAYSI
    User_AAYSI Rank 2 - Community Beginner

    Thanks any idea on this

    1. I am trying to install a second instance over the same DB and getting an error that the STB have already been used
  • SteveF-Oracle
    SteveF-Oracle Mod
    edited Dec 17, 2025 6:01PM

    Hi Alywin,

    Welcome to the Oracle Analytics community and thanks for your question@

    I am trying to install a second instance over the same DB and getting an error that the STB have already been used

    You cannot install a second OAS into the same RCU schema.

    You may be confusing High Availability (HA) using scale-out as documented in the OAS Enterprise Deployment Guide or the OAS Administration Guide with Disaster Recover (DR) failover.