Forum Stats

  • 3,873,374 Users
  • 2,266,538 Discussions
  • 7,911,516 Comments

Discussions

Single Repository vs Multiple Repositories

Hello All,

I wanted to collect your inputs about what you think about implementing projects with Single Repository vs Multiple Repositories.
Does any approach have any special benefits?
Also has anyone setup Multiple Repositories on one BI server (OS is Solaris 10)?
Please let me know.

Thanks,
Micros
Tagged:

Best Answer

  • 631335
    631335 Member Posts: 24
    Answer ✓
    I'm going to write a document about this sometime in the future.
    Right now these are some basic steps:

    1. Deploy a new version of analytics application on OC4J using the analytics.war on $ORACLEBI/web/
    2. Edit file $ORACLEBI/oc4j_bi/j2ee/home/applications/analytics_<new>/WEB-INF/web.xml and change value for "oracle.bi.presentation.sawserver.port"to 9711
    3. Add new repository on NQSConfig.Ini and restart BI Server
    4. Create a new entry on $ORACLEBI/setup/odbc.sh as a copy of AnalyticsWeb, that should point to the new repository
    5. Create a new catalog folder on $ORACLEBIDATA/web/catalog
    6. Create a new instanceconfig.xml and add <Listener port=”9711″ />after the <DNS .../> entry.
    7. On the new instanceconfig.xml change the Catalogpath to point to the new catalog folder created on step 5, and DNS to the one created on step 4
    8. Create new scripts to start the sawserver with parameter the complete path to the new instanceconfig.xml.
    9. Restart OC4J and BI Server and start the new Presentation Services with the scripts you made.

    This is not a complete guide but the outline of the procedure. I 'm planning to make it complete sometime (if I find some free time)
    You can also check the following links
    [http://www.be-ice.eu/2007/09/11/managing-multiple-presentation-services-on-the-same-unix-box]
    [http://bvellinger.blogspot.com/2008/01/obiee-10132-and-multiple-presentation.html]

    Giorgio

Answers

  • 663750
    663750 Member Posts: 8
    hello Micros,

    If you have small project its beneficial to use Single repository

    and the main advantage to have a Single repository is the execution speed ,

    If you are using multiple rep its difficult to merge them and the speed is very low
  • 631335
    631335 Member Posts: 24
    Hello Micros

    I have made an installation with one BI Server with multiple repositories, served by multiple presentation services, on Oracle Unbreakable R4. It is a little bit tricky but it works.
  • 663712
    663712 Member Posts: 64
    Can you share how you did it? What was the tricky part?
  • 631335
    631335 Member Posts: 24
    Answer ✓
    I'm going to write a document about this sometime in the future.
    Right now these are some basic steps:

    1. Deploy a new version of analytics application on OC4J using the analytics.war on $ORACLEBI/web/
    2. Edit file $ORACLEBI/oc4j_bi/j2ee/home/applications/analytics_<new>/WEB-INF/web.xml and change value for "oracle.bi.presentation.sawserver.port"to 9711
    3. Add new repository on NQSConfig.Ini and restart BI Server
    4. Create a new entry on $ORACLEBI/setup/odbc.sh as a copy of AnalyticsWeb, that should point to the new repository
    5. Create a new catalog folder on $ORACLEBIDATA/web/catalog
    6. Create a new instanceconfig.xml and add <Listener port=”9711″ />after the <DNS .../> entry.
    7. On the new instanceconfig.xml change the Catalogpath to point to the new catalog folder created on step 5, and DNS to the one created on step 4
    8. Create new scripts to start the sawserver with parameter the complete path to the new instanceconfig.xml.
    9. Restart OC4J and BI Server and start the new Presentation Services with the scripts you made.

    This is not a complete guide but the outline of the procedure. I 'm planning to make it complete sometime (if I find some free time)
    You can also check the following links
    [http://www.be-ice.eu/2007/09/11/managing-multiple-presentation-services-on-the-same-unix-box]
    [http://bvellinger.blogspot.com/2008/01/obiee-10132-and-multiple-presentation.html]

    Giorgio
  • 663712
    663712 Member Posts: 64
    Awesome! Thanks
  • David_T
    David_T Member Posts: 2,432
    edited Oct 9, 2008 6:43PM
    Wow. After all that, no points for Giorgio?!
  • 667465
    667465 Member Posts: 71
    Hi Giorgio
    Do you have the document, since i have tried almost everything but i am still not able to do it.
    Here is the link where i have written all the steps please correct them if you find any mistake or please add steps if in case you find it missing.
    link : 3715965

    I badly need to try this, because people dont believe that this can be actually done.

    thanks
This discussion has been closed.