KPI Partners Blog

Changing the OBIEE Repository Password from the Command Line

Posted by KPI Partners News Team on Wed, May 01, 2013 @ 03:21 PM

by Shiva Molabanti

In OBIEE 11.1.1.7.0 there is new BI Server utility called obieerpdpwdchg to change the RPD password from command line.

Follow these steps to change the repository password using the obieerpdpwdchg utility, and then deploy the modified repository in Fusion Middleware Control:

  1. Run bi-init to launch a command prompt.

You can find the bi-init command from

  • Client installations:  ORACLE_HOME/bifoundation/server/bin
  • All other installations: ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup

Double-click bi-init.cmd (or bi-init.bat for client installations) to display a command prompt that is initialized to your Oracle instance.

  1.  At the command prompt, type obieerpdpwdchg with the following arguments:
    • -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 E:\SampleAppLite.rpd -O E:\New_SampleAppLite.rpd

Give password for repository: Admin123

Give password for repository: <new Password>

 

 

molabantiShiva 2013 04 17 ChangingTheOBIRepositoryPasswordFromTheCommandLine 1 resized 600

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

  1. Open a Web browser and log in to Fusion Middleware Control from the computer where the updated repository is located.
  2. In the navigation tree, expand Business Intelligence and then click coreapplication to display the Business Intelligence Overview page.
  3. Display the Repository tab of the Deployment page.
  4. Click Lock and Edit Configuration.
  5. Click Browse next to Repository File. Then, select the updated repository file and click Open.
  6. 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.

  1. Click Apply, then click Activate Changes.
  2. Return to the Business Intelligence Overview page and click Restart.
molabantishiva 128

Shiva Molabanti is a Manager and Senior Architect at KPI Partners.  He is a business intelligence enthusiast who likes blogging about acquisitions in the BI space, technical workings of BI tools, and Oracle Business Intelligence.  Visit Shiva at his personal blog: http://shivabizint.wordpress.com/

Tags: OBIEE, Shiva Molabanti, Oracle, Oracle BI, Blog



Subscribe to the KPI Blog