Configure Oracle Business Intelligence Enterprise Edition Repository and Web Catalog Manually

1. Copy the RPD, and Catalog files from <AI HOME>OBIEE\RPD\ and <AI HOME>OBIEE\Catalog folders to a machine where the Oracle Business Intelligence Enterprise Edition is installed.
2. Open the RPD Admin tool in offline mode from the following path: obiee_home\user_projects\domains\bi\bitools\bin\ admintool.cmd

   The default Repository Password is insight123.

3. Change the Connection Pool Settings.

   See Import the BAR file in an existing Oracle Business Intelligence Enterprise Edition instance > Step 2

4. Save the changes, and close the RPD.
5. From the command prompt:
   1. Navigate to the obiee_home\user_projects\domains\bi\bitools\bin
   2. Run the following command:

      datamodel.cmd uploadrpd -I <RPDname> [-W <RPDpwd>] -U <cred_username> [-P <cred_password>] -SI <service_instance>

      For example, datamodel.cmd uploadrpd -I C:\AIOBIEE\RPD\ArgusInsight.rpd -W insight123 -U weblogic -P weblogic1 -SI ssi

6. Login to the Oracle Enterprise Manager with the Oracle WebLogic Server credentials.
7. Click Target Navigation.
   

   The Target Navigation drop-down menu appears.

8. Go to Business Intelligence > biinstance.

   The Business Intelligence Instance screen appears.

9. From the Availability tab, select Processes, and click Stop All.

   A confirmation dialog box appears.

10. Click Yes.

    All the running processes are stopped.

11. Go to Catalog\argusinsight\root\shared folder:
    1. Copy argus+insight folder, and argus+insight.atr file.
    2. Paste in obiee_home\user_projects\domains\bi\bidata\service_instances\ssi\metadata\content\catalog\root\shared folder.
12. Go to Oracle Enterprise Manager, from the Availability tab, select Processes, and click Start All.

    A confirmation dialog box appears.

13. Click Yes.
14. Create User Groups and Users manually in Admin Console. (See Create Users and Groups in Oracle WebLogic Server.).
15. Create Roles and policies manually in Oracle Enterprise Manager. (See Create Roles and Policies with Oracle Fusion Middleware Control.)
16. To view and administer privileges for the Oracle Business Intelligence components, login to Oracle Business Intelligence Enterprise Edition Analytics with Oracle WebLogic Server user credentials.
17. Go to Administration > Security > Manage Privileges.

    For a list of privileges assigned to these roles, refer to Oracle Business Intelligence Enterprise Edition Default Application Roles.

18. Go to Catalog, and set the folder level permissions for the Oracle Business Intelligence Enterprise Edition Groups. (See Oracle Business Intelligence Enterprise Edition Catalog Folder-level Permissions)
19. Go to Administration > Maintenance and Troubleshooting, and click Reload Files and Metadata.
20. To use the AI Aggregate Analysis Subject area and Dashboard, login with a valid user credentials.

Note:

All the WLST commands are case sensitive.

To start the WebLogic Scripting Tool on Unix or Linux, use wlst.sh command, rest all of the commands mentioned in the procedure remains same.

While executing the WLST commands on Windows server, you must use forward slash (/) to avoid any error messages. For example:

C:/AIBOEE/instance/import/ssi.bar