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.

OBIEE 10g rpd password reset : http://satyaobieesolutions.blogspot.com/2013/06/how-to-reset-forgotten-obiee-10g-rpd.html

Thanks,

Satya Ranki Reddy