can 2 instances use the same BI/Infra tables — Oracle Analytics

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

can 2 instances use the same BI/Infra tables

Received Response
1
Views
3
Comments
User_4NU9S
User_4NU9S Rank 6 - Analytics Lead
edited Aug 13, 2024 5:47PM in Oracle Analytics Cloud and Server

Hi , I was thinking if this can be done ..

I've a obiee12212 instanceA running from one oracle home and domain home . Now can I have another oracle home  and domain home which will host my new obiee12212 instanceB with same infra/Bi tables used in instanceA . Only thing that will change in instanceB will be ports.  when when using instance B i will shutdown instance A

Thanks

Answers

  • User_4NU9S
    User_4NU9S Rank 6 - Analytics Lead

    No I cannot .. it will throw error while config that the Tables are already been used.   thanks

  • Joel
    Joel Rank 8 - Analytics Strategist

    You can't share RCU tables across OBIEE instances. You'll need to create a new set of schemas  for your instance B.

  • Avinash Pentyala
    Avinash Pentyala Rank 5 - Community Champion

    Nope, you have to create RCU schemas differently.