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




5 comments:

  1. interesting piece of information, I had come to know about your web-page from my friend pramod, jaipur,i have read atleast eight posts of yours by now, and let me tell you, your blog gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a million once again, Regards, obiee online training

    ReplyDelete
  2. Satya...it worked for me..thanks for sharing this piece of info and it helped me a lot today.

    ReplyDelete

  3. Thank you provide valuable informations and iam seacrching same informations,and saved my time OBIEE Online Training

    ReplyDelete

  4. Thank you provide valuable informations and iam seacrching same informations,and saved my time SAS Online Training

    ReplyDelete
  5. Great stuff provided by the Admin here… look into this for Obiee online training

    ReplyDelete