We would like to reset the ‘Administrator’ password for:
i) ‘OBIEE’
ii) ‘BI Publisher’ and
iii) ‘BI Scheduler’
ii) ‘BI Publisher’ and
iii) ‘BI Scheduler’
Please provide a solution to perform a password reset.
Solution
Solution
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
After username/password Administrator/admin3
BI Publisher superuser username/password admin2/admin2
After the test I also proved you could 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>
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.
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
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.
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.
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. I would expect the encrypted password strings to exactly match my 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
C:\>schconfig
Copyright (c) 1997-2006 Oracle Corporation, All rights reserved
***** Delivers Configuration Menu *****
1 – Configure Scheduler
1 – Configure Scheduler
>>> Enter Choice: 1
***** Scheduler Configuration *****
1 – Database
2 – General
3 – Advanced
0 – Quit
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
10 – Administrator Name : Administrator
11 – Administrator Password : *****
0 – Quit
>>> Enter Choice: 10, then 11
0 – Quit
0 – Quit
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) .