Forgot password for OBIEE Repository or Resetting the Admin Tool Prepository Password

There are various ways to reset the Admin Tool Repository password.

In OBIEE 10g, follow the following steps to reset the password using NSQConfig.INI file.

You can find this file at:

ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn
Make a backup copy of the file before editing.

1. Stop the BI Server service
2. Close Administration Tool, if opened. (Then only the changes are affecting to the Administration Tool)
3. Open the NQSConfig.INI file in a text editor.
4. Go to Security part and find AUTHENTICATION_TYPE = BYPASS_NQS;
5. Uncomment (remove #) this part.
6. Save the changes you have made.
7. Open Administration Tool, then rpd which needs password reset, in offline mode
8. Give any password, it accepts.
9. Now go to Manage > Security.
10. Change password.
11. Save the changes to repository.
12. Revert back the changes in NQSConfig.INI.
13. Start BI Server and open repository with new password.

But unlike OBIEE 10g, OBIEE 11g provides some easy and built-in processes to get the repository passwords.

• Open your Enterprise Manager.
• Navigate to Weblogic Domain > bifoundation domain > security > Credentials.

• Expand oracle.bi.enterprise

This is the key map which stores all the repository passwords that are deployed.

Now from the above mappings, we can retrieve any repository passwords.

• Open command prompt.


• 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","admin123","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_BI0001 repository
  wls:/bifoundation_domain/serverConfig> listCred("oracle.bi.enterprise","repository.SampleAppLite_BI0001")
  
  [Name : tempvalue, Description : null, expiry Date : null]
  PASSWORD:Admin123


• This is it. The password is in front of you...... :-)

Repository modes in OBIEE

Online Mode

Use online mode to view and modify a repository while it is loaded into the Oracle BI Server. The Oracle BI Server must be running to open a repository in online mode. There are certain things you can do in online mode that you cannot do in offline mode. In online mode, you can perform the following tasks:

• Manage scheduled jobs
  
• Manage user sessions
  
• Manage the query cache
  
• Manage clustered servers

In online mode, the administrator edits a live repository that the server has in memory; that is, users can still access the repository while changes are being made. Changes to the repository are immediately applied to the server when they are checked in.

Oracle BI Server has already opened the repository file and the operating system has put a write-lock on the file. In this mode, Oracle BI Server act as an agent of the Administration Tool. When the Administration Tool tells it to, Oracle BI Server sends the Administration Tool a copy of its in-memory repository. Then it listens for messages from the Administration Tool about changes, makes those changes to its in-memory copy, and, when told by the Administration Tool, tells the OS to save the changed file.

Offline Mode

Use offline mode to view and modify a repository while it is not loaded into the Oracle BI Server. If you attempt to open a repository in offline mode while it is loaded into the Oracle BI Server, the repository opens in read-only mode. Only one Administration Tool session at a time can edit a repository in offline mode.

You can edit the repositories in offline mode by two of the following ways,

Follow these steps to open an RPD-format repository in offline mode:

1. In the Administration Tool, select File > Open > Offline.

• Go to the repository you want to open, and then select Open.
• In the Open Offline dialog, enter the repository password, and then click OK.

You do not need to enter a user name and password to open a repository in offline mode. You only need to enter the repository password.

2. You can also open MDS XML format repositories in offline mode, as follows:

• In the Administration Tool, select File > Open > MDS XML.
• Select the root folder location for your MDS XML files and click OK.
• If this is the first time you have opened this MDS XML repository in the Administration Tool, you are prompted to specify whether this repository is a standalone MDS XML repository, or whether it is under source control. Select the appropriate option and click OK.

When you open an MDS XML format repository in the Administration Tool, the title bar displays the format and root folder location (for example, MDS XML C:\Root_Folder).

Note:

If the server is running and the repository you are trying to open is loaded, the repository opens in read-only mode. If you want to edit the repository while it is loaded, you must open it in online mode. Also, if you open a repository in offline mode and then start the server, the repository becomes available to users. Any changes you make become available only when the server is restarted.

What is Oracle BI Admin Tool/Oracle Business Intelligence Administration Tool?

Oracle Business Intelligence Administration Tool is,

• Used to manage OBIEE server
• Available only for Windows operating systems.
• A Windows application that allows the BI Server administrator to create & edit repositories.
• Can edit repositories in either online or offline mode.
• Having a session manager and a cache manager in online mode.

You can start it in two ways:

1. Using Windows Menu : Start > All Programs > Oracle Business Intelligence > BI Administration
2. By launching the Administration Tool from the command line using bi-init.cmd