You can use Fusion Middleware Control to publish the Oracle BI metadata repository and set the location of the Oracle BI Presentation Catalog. Publishing a repository enables the Oracle BI Server to load the repository into memory upon startup and makes the repository available for queries.
When you upload a repository file for publishing, you provide the name and location of the repository to upload and the current repository password.
The published repository is available to all Oracle BI Server clients, not just to Oracle BI Presentation Services.
This chapter contains the following topics:
In addition to publishing the metadata repository, you can use Fusion Middleware Control to provide a shared location for the repository and a local or shared location for the Oracle BI Presentation Catalog.
You can publish the repository in distributed mode or shared mode:
In distributed mode, each Oracle BI Server instance loads the repository from its default local directory. Repositories uploaded through Fusion Middleware Control are uploaded to each default local directory. Any changes made to the repository using the Administration Tool affect only the Oracle BI Server component that is associated with the changed repository file.
In shared mode, each Oracle BI Server instance loads the repository from the shared network location designated as the repository publishing directory. Note that repositories uploaded through Fusion Middleware Control are uploaded to both the shared location and the default local directory for each Oracle BI Server. You typically publish the repository in shared mode when you have multiple Oracle BI Server components in your deployment.
Like the Oracle BI repository, the Oracle BI Presentation Catalog can be published in shared mode, or distributed mode. Each Presentation Services instance loads the Oracle BI Presentation Catalog from the catalog location specified in Fusion Middleware Control.
Before you begin this procedure, ensure that you are familiar with the information in Section 3.2, "Using Fusion Middleware Control to Update Oracle Business Intelligence Configuration Settings."
To use Fusion Middleware Control to upload a repository and set the location of the Oracle BI Presentation Catalog:
Go to the Business Intelligence Overview page, as described in Section 2.2.2, "Using Fusion Middleware Control to Manage Oracle Business Intelligence System Components."
Display the Repository tab of the Deployment page.
On the Repository tab, you can view the name of the current published repository (called the Default RPD). Note that the Data Source Name (DSN) visible to Oracle BI Server clients for the repository published through Fusion Middleware Control is always Star.
Click Lock and Edit Configuration to allow changes to be made.
To publish the repository in shared mode, select Share Repository and provide a Shared Location. If you do not select this option, then the repository that you upload on this page is published in distributed mode by default.
To upload a repository and to set the location for the Oracle BI Presentation Catalog, complete the elements using the descriptions in the Help topic for the page. Click the Help button on the page to access the page-level help for the following options:
Click Apply, then click Activate Changes.
Return to the Business Intelligence Overview page and click Restart.
See Appendix A, "NQSConfig.INI File Configuration Settings" for information about advanced configuring settings for repositories. Note that hosting multiple repositories on a single Oracle BI Server is not recommended for production systems.
For information on using methods in the Oracle BI Systems Management API to change configuration settings, see Chapter 30, "Introducing the Oracle BI Systems Management API."
When you upload a repository, it is copied to the local repository directory for each Oracle BI Server component, located at:
ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obisn\repository
If you have published the repository in shared mode, then the repository is also copied to the shared network location.
After the repository is uploaded, it is given a version number suffix (for example, SampleApp_bi001.rpd). This version number is incremented each time that the repository is uploaded. To revert to a previous version, you must re-upload the specific version of the repository to use.
Note that you can delete older versions from the repository directory or shared network directory to reclaim disk space.
This section explains how to use the Fusion Middleware Control System MBean Browser to publish the default metadata repository.
To use the System MBean Browser to publish the Oracle BI repository:
Manually copy the repository file to publish to the local repository directory for each Oracle BI Server component in the deployment, at:
ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obisn\repository
Use the System MBean Browser to specify the new repository name. See Section 3.5, "Using the Fusion Middleware Control MBean Browser to Update Configuration Settings" for more information.
Commit your changes and restart Oracle Business Intelligence.
Note that if you perform this procedure and then later scale out the deployment to include additional Oracle BI Server components, then you must manually copy the repository file to the local repository directory for the new Oracle BI Server component. Perform this copy step after the Oracle BI Server component has been created, but before restarting the system.