A Oracle Hyperion Planning utility called SetDBNEssbasePassword enables you to set database and Oracle Essbase passwords for a list of applications you provide. You must provide application names as a comma-separated list enclosed in quotation marks and without spaces.

Launch the utility using this syntax at the command line:

SetDBNEssbasePassword /U:<username> /A:"<application names in comma-separated list enclosed in quotation marks and without spaces>"

SetDBNEssbasePassword.cmd uses these arguments:

• /U:admin
• /A:"Application names comma-separated without spaces"

When the utility is launched:

1. It prompts login password for the user.
2. It prompts Enter database password: which is the new DB password that needs to be set
3. It prompts Enter Essbase password: which is the new Essbase password that needs to be set.

Then it confirms that the application password reset is complete:

Reset of database and Essbase passwords for app ApplicationName is successful.

If an invalid application is provided or an application name with a space in the comma separated list is provided, it will prompt for the new passwords but will fail and display the following message:

Unable to find application entry for app ApplicationName. Skipping...

After running the utility, you must restart Planning for the password changes to take effect.