RPD Password RESET in OBIEE11g

As per my knowledge we cant able to reset the RPD password.But we can able to know already deployed RPD passwords with the help of Wlst script.

Like 10g in 11g also we can able to open RPD in Offline and Online mode.Better to memorize the password for future perspective.If we have process to reset pwd then developer can able to know the production rpd password.Then security issues come into pictuire.

Login to weblogic EM  and navigate to credentials store page as shown below.

Expand the key map oracle.bi.enterprise. It shows the earlier deployed RPD passwords.
In above image, I have 4 repositories and one scheduler schema keys in my credential key map. From the list, to get the password of “SampleAppLite” repository, follow these steps:

• Open command prompt,
• E:\>cd <OBIEE_HOME>\oracle_common\common\bin
• Run wlst scrpt: <OBIEE_HOME>\oracle_common\common\bin>wlst.cmd
• Connect to weblogic domain with the command:
  
  connect(“<weblogic_AdminUser>”,”<weblogic_AdminUser_Password>”,”<Adminserver_Hostname>:<Admin_Portno>”) 
  e.g: wls:/offline> connect(“weblogic”,”weblogic123″,”localhost:7001″)Connecting to t3://localhost:7001 with userid weblogic …Successfully connected to Admin Server ‘AdminServer’ that belongs to domain ‘bifoundation_domain’.————
• Run listCred() command to get the password of SampleAppLite repository
  wls:/bifoundation_domain/serverConfig> listCred(“oracle.bi.enterprise”,”repository.SampleAppLite″)
  Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root.
  For more help, use help(domainRuntime)
  [Name : tempvalue, Description : null, expiry Date : null]
  PASSWORD:Admin321

You will get the password: Admin321.