Changing the Oracle BI Repository Password

Each Oracle BI repository has a password that is used to encrypt its contents.

You create the repository password when you create a new Oracle BI repository file, or when you upgrade a repository from a previous release of Oracle Business Intelligence.

You can change the repository password using the Administration Tool in offline mode, or using the obieerpdpwdchg utility. You cannot change the repository password when the repository is open in the Administration Tool in online mode.

The obieerpdpwdchg utility is especially useful when you want to change the repository password on Linux and UNIX systems where the Administration Tool is not available.

After you change the repository password using the Administration Tool or obieerpdpwdchg, you must also publish the updated repository and specify the new password in Fusion Middleware Control. Specifying the repository password in Fusion Middleware Control enables the password to be stored in an external credential store, so that the Oracle BI Server can retrieve it to load the repository.

Note:

If you are using the SampleAppLite.rpd or SampleApp.rpd sample repository, you must change the default password the first time you open it in the Administration Tool, for security reasons. See About the SampleApp.rpd Demonstration Repository for the sample repository.

This section contains the following topics:

• Changing the Oracle BI Repository Password Using the Administration Tool

• Changing the Oracle BI Repository Password Using the obieerpdpwdchg Utility

Changing the Oracle BI Repository Password Using the Administration Tool

Learn how to change your password in the Administration Tool and publish a modified repository.

Use the Upload Repository Command to change the repository password and to publish the modified repository.

1. Open the repository in the Administration Tool in offline mode.
2. Select File, then select Change Password.
3. Enter the current (old) password.
4. Enter the new password and confirm it. The repository password must be longer than five characters and cannot be empty.
5. Click OK.
6. Save and close the repository.
7. Open a Web browser and log in to Fusion Middleware Control from the computer where the updated repository is located.
8. In the navigation tree, expand Business Intelligence and then click coreapplication to display the Business Intelligence Overview page.
9. Display the Repository tab of the Deployment page.
10. Click Lock and Edit Configuration.
11. Click Browse next to Repository File. Then, select the updated repository file and click Open.
12. Enter the new (updated) repository password in the Repository Password and the Confirm Password fields.

    Make sure to specify the password that has been set in the repository. If the passwords do not match, the Oracle BI Server fails to start, and an error is logged in nqserver.log.

13. Click Apply, then click Activate Changes.
14. Return to the Business Intelligence Overview page and click Restart.

Changing the Oracle BI Repository Password Using the obieerpdpwdchg Utility

Learn how to change the repository password.

Follow these steps to change the repository password using the obieerpdpwdchg utility, and then publish the modified repository using the Upload Repository Command.

1. Navigate to the obieerpdpwdchg utility, which is located here:

   BI_DOMAIN/bitools/bin

2. Type the following arguments for obieerpdpwdchg:

   • -I name_and_path_of_existing_repository

   • -O name_and_path_of_new_repository

   Then, enter the current (old) password and the new password when prompted. The repository password must be longer than five characters and cannot be empty. For example:

   obieerpdpwdchg  -I my_repos.rpd -O my_changed_repos.rpd
   Please enter the repository password:
   
   Please enter a new repository password:
   

   Note that passwords are masked on the command line unless you include the -C option in the command to disable masking.

3. Open a Web browser and log in to Fusion Middleware Control from the computer where the updated repository is located.
4. In the navigation tree, expand Business Intelligence and then click coreapplication to display the Business Intelligence Overview page.
5. Display the Repository tab of the Deployment page.
6. Click Lock and Edit Configuration.
7. Click Browse next to Repository File. Then, select the updated repository file and click Open.
8. Enter the new (updated) repository password in the Repository Password and the Confirm Password fields.

   Make sure to specify the password that has been set in the repository. If the passwords do not match, the Oracle BI Server fails to start, and an error is logged in nqserver.log.

9. Click Apply, then click Activate Changes.
10. Return to the Business Intelligence Overview page and click Restart.