Wednesday, April 27, 2011

How to reset/change the 'Administrator' password in OBIEE, BI Publisher and BIScheduler


The steps to perform this task are below.

The example solution begins by creating a BI Publisher superuser.
 On both OBIEE and BI Publisher.
 
Start    username/password:    Administrator/Administrator
After   username/password:    Administrator/admin3

BI Publisher superuser username/password admin2/admin2

After the test it was proved that it was possible to log into OBIEE and click on the preconfigured Dashboard.

Please follow the exact steps below and create the same usernames and passwords to start off with.

1. Take a backup copy of the 
c:\OracleBI\xmlp\XMLP\Admin\Configuration\xmlp-server-config.xml file. 
2. Log into BI Publisher
3. Select Admin > Security Center > Security Configuration
4. Enable a Local Superuser called: admin2 with the password admin2  . Click <Apply>
5. Restart oc4j
6. Sign into BI Publisher as  admin2/admin2.  This should log in successfully.
7. Log into OBIEE Admintool (Online) and change the Administrator password to 'admintool'.
8. Check in and save the changes.
9. Log into OBIEE Answers as Administrator/admin3 
10. Change the 'Administrator' password under the 'Security Model' to 'admin3'. Click <Apply>
11. Restart oc4j
12. Login to BI Publisher as Administrator/admin3.   This should log in successfully.
13. Log into OBIEE Answers as Administrator/admin3
14. Click on More Products > BI Publisher
15. This should go straight through to BI Publisher without prompting for a username and password.

If the above method still fails attach your c:\OracleBI\xmlp\XMLP\Admin\Configuration\xmlp-server-config.xml file for comparison. It is expected that the encrypted password strings exactly match your environment.

** BI Scheduler password **

This password can be changed in 'schconfig' from the DOS/UNIX command line/shell.
C:\>schconfig
Copyright (c) 1997-2006 Oracle Corporation, All rights reserved

***** Delivers Configuration Menu *****
1 - Configure Scheduler

>>> Enter Choice: 1

***** Scheduler Configuration *****
1 - Database
2 - General
3 - Advanced
0 - Quit

>>> Enter Choice:


>>> Enter Choice: 2

***** Scheduler General Configuration *****
10 - Administrator Name : Administrator
11 - Administrator Password : *****
0 - Quit

>>> Enter Choice: 10, then 11

0 - Quit
0 - Quit
0 - Quit
>>>>>>>>

Quit 3 times and restart all Analytics Services (To bring them back in sync. Restarting the BI Scheduler on its own also works, but Job Manager connections may exhibit stale behaviour depending on what has been changed) .

No comments:

Post a Comment