Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to recover forgotten password of rpd in OBIEE 12c?

Received Response
600
Views
8
Comments
DollyG
DollyG Rank 5 - Community Champion
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

Hi Guys,

I want to open an rpd in offline mode but do not remember its password.

Can anyone please tell me how to retrieve the rpd password in OBIEE 12c?

Thanks,

Dolly

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    I would say you can't ....

    The password doesn't exist anywhere else than inside the RPD. Keep trying with all the possible passwords (as it will not "lock" the RPD after some wrong attempts.

    Of course you can also script that and "brute force" it if you have at least an idea of what the password must look like.

  • Joel
    Joel Rank 8 - Analytics Strategist

    You can use the obieerpdpwdchg utility to reset the password.

  • Gianni Ceresa
    Gianni Ceresa Mod

    That thing require the old password, the one which is missing in this case.

    Otherwise why to set a password on the RPD if an utility you get with the Admintool can just reset it?

  • Joel
    Joel Rank 8 - Analytics Strategist

    Good point @Gianni Ceresa. In 11g, there was an option via WLST to do this but the listCred command doesn't appear to be in 12c any longer.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Yeah, because in 11g the server needed the password to load and open the RPD, while in 12c the RPD is transformed into XML which isn't protected by password anymore. So the server do not need to know the password of the RPD (it's asked when loading a new RPD to be able to open it once, that's it).

  • DollyG
    DollyG Rank 5 - Community Champion

    Hi,

    Thanks for replying!

    So, all I could get through this post is : It was possible to recover password in 11g via WLST but there is no such way available in 12c?

    Again, if someone forgets the password, there is no way yet designed to recover the same?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Nope, so far no documented or known way ...

    You can of course download a new copy of the "live" RPD, but that's probably not what you are after.

    If you desperately need to open your saved RPD you can always try to go through a SR but I suspect the reply will be the same.

  • DollyG
    DollyG Rank 5 - Community Champion

    Thanks