Resolving Multiple Oracle Homes to Work with OBI

Previous TopicNext TopicContents

If you have multiple Oracle homes on the OBI server:

  1. Browse to:

    <OBI_HOME>\instances\<your_instance>\bifoundation\OracleBIApplication\coreapplication\setup

  2. Edit the bi-init.cmd or bi-init.sh (depending on your operating system) file in Wordpad.

    Note: The information in bi-init file will not resolve correctly in Notepad.

  3. Check for the following reference:

    If using Windows:

    call

    <OBI_HOME>\instances\<your_instance>\bifoundation\OracleBIApplication\coreapplication\setup\user.cmd

    If using non-Windows:

    <OBI_HOME>/instances/<your_instance>/bifoundation/OracleBIApplication/coreapplication/setup/user.sh

  4. Based on what is in the bi-init file:
    1. If the reference exists:
      1. Close the bi-init file.
      2. Edit the user.cmd or user.sh file from the path referenced above.
      3. In the user file, add the following reference:

        If using Windows:

        set TNS_ADMIN=<OBI_Home>\Oracle_BI1\network\admin

        where <OBI_Home> is the location of OBIEE Home (the default is \Oracle\Middleware\)

        If using non-Windows:

        TNS_ADMIN=<OBI_Home>/Oracle_BI1/network/admin

        where <OBI_Home> is the location of OBIEE Home (the default is /Oracle/Middleware/)

    2. If the reference does not exist, add the following reference in the bi-init file:

      If using Windows:

      set TNS_ADMIN=<OBI_Home>\Oracle_BI1\network\admin

      where <OBI_Home> is the location of OBIEE Home (the default is \Oracle\Middleware\)

      If using non-Windows:

      TNS_ADMIN=<OBI_Home>/Oracle_BI1/network/admin

      where <OBI_Home> is the location of OBIEE Home (the default is /Oracle/Middleware/)

  5. Restart the OBI processes for the changes to take effect.

Related Topics

Configuring P6 Analytics with OBI

Overview of OBI

Installing OBI

Prerequisites for Upgrading P6 Analytics

Verifying a TNSNAMES.ora File Exists

Verifying the STARDW Alias

Updating the OraclePrimaveraAnalytics.rpd with the Correct Staruser Name and Password

Updating the OraclePrimaveraAnalytics.rpd for P6

Configuring OBI 11.1.1.6 to Use the P6 Analytics Repository Definition (.rpd) and Catalog

Configuring OBI 11.1.1.7 to Use the P6 Analytics Repository Definition (.rpd) and Catalog



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014