Monday, June 17, 2013

How to reset forgotten OBIEE 11G RPD password

How to reset forgotten OBIEE 11G RPD password



I have seen several posts in OTN. How to reset the rpd password in OBIEE 11g. Here am providing step by step process to get rpd password in OBIEE 11g.


Step1:

In 10g reset password petty much easy (10g Reset the rpd password), but in 11g you can't reset the password.For the context of this blog post, I would like to show you how to know the forgotten password of a deployed repository. Here am providing wonderful solution please try this and give me your comments on this post.


Login to Weblogic EM like below.




Step 2:  Navigate  to credentials store page:-


Step 3:
Expand the -- oracle.bi.enterprise. This is the key map which stores all the repository passwords that are deployed.


I have forgot the password is satyawrite_BI0003.rpd, I want to know the existing password in this rpd. Please follow the steps am sure you will get the your password.


Step:4

Open the command mode:

Login to below path:

C:\Users\redsatya\Oracle>cd \

C:\>cd Oracle\Middleware\oracle_common\common\bin


Step:5

C:\Oracle\Middleware\oracle_common\common\bin>wlst.cmd

Execute the below command then you will get web logic offline mode like below.

wlst.cmd



Step 6:

You have to connect weblogic offline mode using below command .

Ex:  wls:/offline> connect("weblogic","weblogic123","redsatya212:7001")
Connecting to t3://redsatya212:7001 with userid weblogic ...


Once executed successfully the above command then you will get message like below.

Successfully connected to Admin Server 'AdminServer' that belongs to domain 'bif
oundation_domain'.

Warning: An insecure protocol was used to connect to the
server. To ensure on-the-wire security, the SSL port or
Admin port should be used instead.




Step 7:

Execute the listCred () command to get the password of satyawrite_BI0003 repository

Ex:   wls:/bifoundation_domain/serverConfig> listCred("oracle.bi.enterprise","reposito
ry.satyawrite_BI0003")





Once executed the above command in command mode you will get rpd password like below or screen shot as well.

Location changed to domainRuntime tree. This is a read-only tree with DomainMBea
n as the root.
For more help, use help(domainRuntime)

[Name : tempvalue, Description : null, expiry Date : null]
PASSWORD:satyawrite123  ---- This is my existing rpd password.


Good to see the password....... Cheer's.



Thanks,
Satya Ranki Reddy




2 comments: