Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Automating Passwords Resets – nqschangepassword.exe utility

Posted by Venkatakrishnan J on March 31, 2008

Though many of you might be aware of the simple utility called as nqschangepassword.exe, i thought this deserves a special mention here since it can serve as an automation utility to change the passwords/reset the passwords etc. You can find this utility under {OracleBI}\Server\Bin directory. As the name suggests, it helps in changing the passwords of the users in the Repository without opening the repository. The syntax for using this utility is

nqschangepassword.exe -d <data source name> -u <user name> -p <password> -n <new password> [-w <ssl passphrase> | -y]

For example,

nqschangepassword.exe -d AnalyticsWeb -u Administrator -p Administrator -n welcome1

      

This utility can be used in combination with DBMS_SCHEDULER and UTL_SMTP packages to automate the process of resetting the passwords and sending those passwords out to the end users. A very simple and very handy utility. We shall see the multitude of uses this utility can be put through in future blog entries.

Advertisements

8 Responses to “Oracle BI EE 10.1.3.3/2 – Automating Passwords Resets – nqschangepassword.exe utility”

  1. […] See the original post: Oracle BI EE 10.1.3.3/2 – Automating Passwords Resets … […]

  2. I don’t have an environment that I can test this on right now.

    I know there is a bug in the product that only users in the administration group can change their passwords in the web interface.
    Would this allow “normal” users to change their password?

    Ross
    http://www.RossGoodman.com

  3. I have just tested this.
    If the user in not in the admin group then this command reports an error in trying to change the password.

    Ross
    http://www.RossGoodman.com

  4. Venkatakrishnan J said

    Ross – You are correct. A sureshot enhancement candidate. This is currently not possible because any non-admin user cannot even open the repository (and hence cannot change his password).

  5. Vency said

    Hi Venkat,

    Is there any way to recover the Lost password for the Repository?

  6. […] for users, just use the nqschangepassword.exe tool. For more details on this, check my blog entry here. So, on a high level your entire migration process would look as shown […]

  7. suma said

    HI,
    can u show me what r major difference between siebel analytics 7.8 and OBIEE 10.1.3.3

  8. Jacky said

    it can run in linux?. i how to set up data source in linux?

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

 
%d bloggers like this: