Retrieving Hidden Password from EPM Registry

Author:-Sanjay Purohit

I normally take screen shots and make notes whenever I install Hyperion but sometime I forget to document the schema password details  or  DBA forgot to setup the password profile as never expire and schema password gets expired and you are stuck. Your DBA reset new password and you have to re-run the configurator. 

Objective

The purpose of this article is to demonstrate how to retrieve the hidden password of configured components.  Retrieving the password is two-step process. First you would need to run the epmsys_registry.sh/bat   from /Middleware/user_projects/epmsystem1/bin.

 The output of the report will be stored under

/Middleware/user_projects/epmsystem1/diagnostics/reports as registry.html. The report can be opened in any browser. I am going to select FDMEE (aif_product) to retrieve the password.

  

The same information can be retried by using

sh epmsys_registry.sh view aif_product/database_conn/@dbPassword

But the password is encrypted. We would need to decrypt the password. Run the below given command to decrypt the value.

sh epmsys_registry.sh viewencryptedproperty aif_product/database_conn/@dbPassword

sh epmsys_registry.sh view encrypted property planning_product/database_conn/@dbPassword

The hidden password is welcome1.

Related Webpages and Blogs

 Oracle Blog-EPM troubleshooting Utilities

https://blogs.oracle.com/proactivesupportEPM/entry/epm_troubleshooting_utilities

How to deleted registry components

http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_1112200/frameset.htm?apfs02.html