Oracle Analytics

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

Categories

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

OAS best Practices for HA / Failover

Accepted answer
40
Views
5
Comments
Alwyn Paes
Alwyn Paes Rank 3 - Community Apprentice
in Oracle Analytics
  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

Best Answer

  • SteveF-Oracle
    SteveF-Oracle Mod
    edited Dec 17, 2025 6:01PM Answer ✓

    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.

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

  • Alwyn Paes
    Alwyn Paes Rank 3 - Community Apprentice

    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
  • Alwyn Paes
    Alwyn Paes Rank 3 - Community Apprentice

    so here are my concerns

    1. Scale Horizontally within same Data Center, primary server which has admin running goes down, the second server is of no use
    2. in case of DR, is there a way to achieve without using the same hostname in DR?
  • RVohra
    RVohra Mod

    Tagging @Veera Raghavendra Rao Koka-Oracle , appreciate any advise/comments on these concerns!