PLANNING PASSWORD ENCRYPTION UTILITY

The documentation around the PasswordEncryption utility is very straightforward but I still wanted to make that post  for anyone that might not know that such a utility exists or might not know how to use it.

Here is what the Oracle documentation says about this utility:

When running Planning utilities that prompt for passwords, administrators can use an option to suppress password prompts, for example, when running utilities in batch mode. To enable suppressing password prompts, use the PasswordEncryption utility to create a file that stores a password in encrypted form. After the file is set up, you can run Planning utilities with the [-f:passwordFile] option as the first parameter in the command line to skip the password prompt and use the password from the encrypted file. Each password file contains one password, and is stored in the location that you specify when running the utility.

To encrypt a password to be used in Planning utilities:

On a Windows environment:

Go on the server where Planning is installed using remote desktop. Locate the PasswordEncryption.cmd. It should be under the planning1 folder where all the planning utilities are stored.

Then open the Command prompt. In my case utilities are on the E drive so once I switched to drive E, I just navigate to the planning utility folder E:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1

The syntax to start encrypting a password is: PasswordEncryption.cmd passwordfile. If you only specify the file name then the passwordfile will be created under the default folder which is planning1 folder. In my case, I want the Encryptedpassword file to be placed under E:\Oracle, so I will enter: PasswordEncryption.cmd E:\Oracle\Encryptedpassword.txt

Then press enter. When prompted, enter the password you wish to encrypt. While you typing the password nothing will be visible on the command prompt.

Once the password has been entered, press Enter again. You should get a successful message.

Finally go to the Planning utility folder (default folder) or the one you specified (E:\Oracle) to get your Encryptedpassword.txt file.

When opening the file, you should see the actual encrypted password.

On a Unix environment:

Go on the server where Planning is installed using Putty. If you don’t have Putty, just go online and download it. Locate the PasswordEncryption.sh. It should be under the planning1 folder where all the planning utilities are stored.

Use cd to navigate to "u11/Oracle/Middleware/user_projects/epmsystem1/Planning/planning1"

The syntax to start encrypting a password is: PasswordEncryption.sh passwordfile

If you only specify the file name then the passwordfile will be created under the planning1 folder. I want the Encryptedpassword file to be placed under u11/Oracle, so I will enter:
./PasswordEncryption.sh u11/Oracle/Encryptedpassword.txt

Note - Make sure you type ./ before calling the utility otherwise the utility won’t be executed.

Then press enter. When prompted, enter the password you wish to encrypt.

Once the password has been entered, press Enter again. You should get a successful message.

Finally go to the Planning utility folder or the one you specified to get your Encryptedpassword.txt file.

When opening the file, you should see the actual encrypted password. (to open the text file in putty, you have to use "vi" command - vi Encryptedpassword.txt )

Thank you.

Hope you like this post.

Best Regards,

SST.!