RSS

How to reset forgotten OBIEE 11G RPD password?

30 Apr

Forgot OBIEE 11G RPD password?

In OBIEE 10g, If you forgot the repository (RPD) password, we can easily rest with simple straight configuration change (AUTHENTICATION_TYPE = BYPASS_NQS) in NQSConfig.ini file.This was a security breach in OBI 10g versions and it didn’t have had fix for it. Fix? Why?… Yes, as a developer we might still need such a (un)fair upshot. But it is a very dangerous security breach. If anyone gets the production RPD, he can simply bypass the rpd security and can deploy it to see the valuable data. As the OBI rpd doesn’t require someone to know the production Database password, the information theft is quite possible.

So unlike OBIEE 10G, The newer OBIEE 11G has a very tight security i.e. TWO level key authentication to open a RPD in online mode and one key (RPD password) in offline mode. Either of the modes cannot open the repository with some configuration changes. So be careful if you want to reuse the OBI repository, make sure that you have memorized the RPD password.  There is NO any reset process.

But however, you can get a password for an already deployed RPD. With the help of wlst script, you can get the forgotten OBI Repository password that is deployed earlier.

To know forgotten OBIEE11G Repository (RPD) password:

Login to weblogic EM (http://localhost:7001/em) and navigate to credentials store page.

Reset_OBIEE11G_Password_1

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

Reset_OBIEE11G_Password_2

For the context of this blog post, I would like to show you how to know the forgotten password of a deployed repository.

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 “New_SampleAppLite_BI0002” 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 New_SampleAppLite_BI0002 repository
    wls:/bifoundation_domain/serverConfig> listCred(“oracle.bi.enterprise”,”repository.New_SampleAppLite_BI0002″)

    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

That’s it, you can see the password: Admin321 for my New_SampleAppLite_BI0002 repository.

You can even get other key values listed in other key maps to avoid any guess work.

If you want to reset the weblogic Admin password look at here

Thanks,
Shiva Molabanti

Advertisements
 
7 Comments

Posted by on April 30, 2013 in BI Publisher, OBI EE, OBIEE 11g, Weblogic

 

Tags: , , , , , , , , , , , , , , , ,

7 responses to “How to reset forgotten OBIEE 11G RPD password?

  1. Greg Jonathan

    April 30, 2013 at 3:01 pm

    This is really incredible work Shiva!!!. Great blog post as always from you. I am just in a impression that there is no any other way to get a password. But you made it very simple. trust me this is really helpful and needful to everyone.

    Thanks,
    greg

     
  2. venkat

    May 9, 2013 at 9:49 am

    Hi Shiva,Great and its really helpful for OBIEE users to reset the password.

    Thanks,
    Venkat

     
  3. alisha

    May 21, 2013 at 7:30 am

    Hi,
    NICE work this was of great help as i was new to OBIEE 11g. I also consulted http://www.wiziq.com/course/22309 for more knowledge about OBIEE.

     
  4. Pepe

    October 28, 2014 at 4:09 pm

    Amazing job!! Thanks!!

     
  5. anan seti

    March 30, 2016 at 2:16 am

    Hi,
    Thank you , Great ,really work.

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: