Oracle Communities

Oracle Analytics and AI

Child Item

OAS best Practices for HA / Failover

Alwyn Paes

can someone recommend the best practices for HA /Failover for OAS between 2 servers , Active/Active or Active/Passive
I am trying to install a second instance over the same DB and getting an error that the STB have already been used
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

Find more posts tagged with

Accepted answers

Steve F-2

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.

All comments

BalaGuddeti-Oracle

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

Thanks any idea on this

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

Steve F-2

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

Alwyn Paes

so here are my concerns

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

RVohra

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