2 Replies Latest reply on Dec 1, 2012 7:11 PM by Ahsan Shah

    OBIA Database creation question

      I am installing BI Apps on Linux.

      I have the following question.

      I know that, i have to create a database instance for

      •DAC Repository

      •Informatica Domain

      •Informatica Repository

      •Oracle Business Analytics Warehouse

      As per your experience please share if creating one db to hold all the above four is good or should i create a separate database for "Oracle Business Analytics Warehouse" ?.


        • 1. Re: OBIA Database creation question
          Its better to have separate databases for each.

          Check this doc for more help

          Appreciate if you mark as correct/helpful
          1 person found this helpful
          • 2. Re: OBIA Database creation question
            Ahsan Shah
            There is no set rule...and you dont need separate "instances" for each..just schemas. the DAC/INFA metadata is fairly small so you can put them together if you want but OBAW is usually created in its own separate instance since the maintenance may be different. It really is a question for your DBA team. Suppose you need higher availability for certain instances, or if there is maintenance windows where you need the OBAW DB separate from INFA..or if you are using the INFA rep for populating other systems, you may not want to group it with OBAW. These are some things to consider.

            Pls mark helpful or correct
            1 person found this helpful