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

    OBIA Database creation question

    EBSDBA
      Hi,
      I am installing BI Apps 7.9.6.3 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" ?.

      Thanks


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

          Check this doc for more help
          http://docs.oracle.com/cd/E20490_01/bia.7963/e19038/toc.htm

          Appreciate if you mark as correct/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