Creating the ODI Repository for Oracle BI Applications 11.1.1.10.2

Use these instructions to create the ODI repository for Oracle BI Applications 11.1.1.10.2.

These steps are the same as when installing a refresh ODI repository. The only difference is that you need to select the option to restore the ODI Master and Work repositories only.

You must run the BI Applications 11.1.1.10.2 RCU to create the schema for the ODI repository for 11.1.1.10.2. This schema will use the same name as the 11.1.1.10.1 ODI repository schema that was just dropped.

Note:

You must select the option to use an existing prefix and re-use the same prefix that was used by the schema that was previously dropped.
To create the ODI repository for Oracle BI Applications 11.1.1.10.2:
  1. Unzip the BI Applications 11.1.1.10.2 RCU downloaded from the Oracle Business Intelligence Applications 11.1.1.10.2 media pack.
  2. If you are not running RCU on the database host machine, then you must copy the obia_odi.dmp file to a directory with global write access on the appropriate database server machine.

    RCU writes log files to this directory. The .dmp file is located in BIA_RCU_HOME/rcu/integration/biapps/schema.

  3. Launch the BI Applications RCU for 11.1.1.10.2 from BIAPPS_RCU_HOME\bin: 
    UNIX: ./rcu
Windows: rcu.bat
  4. Select the Create radio button.
  5. In the Database Connection Details screen, provide the connection details to the database which previously hosted the ODI repository for Oracle BI Applications 11.1.1.10.1 which you dropped in the previous procedure.
  6. In the Select Components screen, from the Select an existing Prefix list, select the same prefix as that of your ODI repository for 11.1.1.10.1. If you do not see the prefix as an existing prefix, then choose the Create a new Prefix radio button and enter the same prefix as you had used before for the ODI repository for 11.1.1.10.1.
  7. Select the Oracle Data Integration Master and Work Repository. Do not select any other component.
  8. In the Value field in the Custom Variables screen, for the <prefix>_BIA_ODIREPO schema enter the directory path of the folder on the database server that contains the obia_odi.dmp file.

    Note:

    Do not include the name of the .dmp file in the directory path.
  9. Complete the ODI repository creation.
  10. Create a connection in ODI Studio to the ODI repository for 11.1.1.10.2 which you created in the previous step.
    The repository is set to Internal Authentication. The user and password you use to connect to the repository are:

    • User: SUPERVISOR

    • Password: welcome

  11. Change the ID of the 11.1.1.10.2 ODI repository.

    The ID of the repository has to be changed from the default to avoid conflicts when importing the configurations, objects, and customizations from the ODI Repository for 11.1.1.10.1. To note the default repository ID for the Master and Work repositories (default value is 500), see Noting the ID of the 11.1.1.10.1 ODI Repository. Use the following steps to update the value in the ODI repository for 11.1.1.10.2 to a different value:

    1. In ODI Studio, click Topology, click Repositories, click Master Repository. Right-click Master Repository and select Renumber.
    2. On the Renumbering the repository – Step 1 dialog, click Yes.
    3. On the Renumbering the repository – Step 2 dialog, enter a new ID that has not been used for any of your existing ODI Repositories. Oracle suggests incrementing the value you noted in Noting the ID of the 11.1.1.9.2 ODI Repository by 1. Click OK.

      Note:

      Ensure that the incremented value is not the same number as the Repository ID of any existing ODI repository. Oracle reserves all values below 500. All repositories are shipped with 500 as the default value. The value that you enter must be a numeric ID between 501 and 899.
      Description of GUID-932E061D-D979-495F-8281-13CC6ED6E2C2-default.gif follows
      Description of the illustration GUID-932E061D-D979-495F-8281-13CC6ED6E2C2-default.gif
    4. Verify the new number by selecting the Master Repository. Right-click and select Open to view the Internal ID value that was set in the previous step.
    5. Repeat steps a–d to renumber the Work repository to the same value as the renumbered Master repository.

      Note:

      ODI recommends using different values for Master and Work repositories in certain cases. None of these cases apply to Oracle BI Applications, which requires that both repositories use the same value.
      Description of GUID-35EBD53A-0913-4006-BB56-B533795ECC84-default.gif follows
      Description of the illustration GUID-35EBD53A-0913-4006-BB56-B533795ECC84-default.gif