How To Reset the ‘Administrator’ Password in OBIEE 10g, BI Publisher and BI Scheduler


You need to reset the ‘Administrator’ password for:

  • ‘OBIEE’
  • ‘BI Publisher’
  • ‘BI Scheduler’.

How can you do that?

  1. Start 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

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

    1. Take a back up copy of the xmlp-server-config.xml file (i.e. c:\OracleBI\xmlp\XMLP\Admin\Configuration\xmlp-server-config.xml).
    2. Log in to BI Publisher.
    3. Select Admin > Security Center > Security Configuration.
    4. Enable a Local Superuser called: admin2 with the password admin2.
    5. Click <Apply>.
    6. Restart OC4J.
    7. Sign in to BI Publisher as  admin2/admin2  This should log in successfully.
    8. Log in to OBIEE Admintool (Online) and change the Administrator password to ‘admin3’.
    9. Check in and save the changes.
    10. Log in to OBIEE Answers as Administrator/admin3.
    11. Change the ‘Administrator’ password under the ‘Security Model’ to ‘admin3’. Click <Apply>.
    12. Restart OC4J.
    13. Log in to BI Publisher as Administrator/admin3 This should log in successfully.
    14. Log in to OBIEE Answers as Administrator/admin3.
    15. Click on More Products > BI Publisher.
    16. 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 synchronisation. Restarting the BI Scheduler on its own also works, but Job Manager connections may exhibit stale behaviour depending on what has been changed) .

Thanks,

~KKT~

Advertisements

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