Configuring BusinessObjects for use with Oracle RAC

If you are using Oracle Real Application Cluster (RAC) in your environment, after installing the product, you must configure the BusinessObjects Business Intelligence (BI) platform to work with Oracle RAC. For Oracle RAC system requirements, see System-requirements.

The SAP BusinessObjects BI Platform Client Tools must be installed on the BusinessObjects BI server to complete this procedure.

• To configure BusinessObjects BI for use with Oracle RAC
• Where to go from here

To configure BusinessObjects BI for use with Oracle RAC

1. From the Start menu, select Programs > SAP BusinessObjects BI platform 4.0 > SAP BusinessObjects BI platform Client Tools > Universe Design Tool.
    The Universe Designer login dialog appears.
2. Enter the user name and password and click OK.
3. From the Tools menu, select Connections.
4. In the Connection window, locate bds_da_cn, right-click it, and select Edit.
5. In the Connection Edit panel, click Back.
6. Expand the Oracle node and select Oracle Client.
7. Provide the following connection details for your Oracle RAC database server:
    Some of these values match those that you used in the tnsnames.ora file that you configured in Configuring-the-data-warehouse-database.
   • User name
   • Password
   • Service (Use the TNS name that you added to the tnsnames.ora file.)

8. Click Test the connection.
   If the connection is set up correctly, the following message appears:

   The server is responding\! Click OK 

   .
    If you do not get this message and there is a problem with the connection, go back and correct any errors in the setup and then complete this procedure.

9. Click Next twice and then click Finish.
10. Restart the BusinessObjects services.

Where to go from here

Verifying-the-URGMapper-properties-file