Changing Database Passwords

Periodically change the password for all EPM System product databases. The procedure for changing the database password in Shared Services Registry is detailed in this section.

For detailed procedures to change an EPM System product database password, see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.

  To change EPM System product database passwords in Shared Services Registry:

  1. Using the database administration console, change the password of the user whose account was used to configure EPM System product database.

  2. Stop EPM System products (web applications, services and processes).

  3. Using the EPM System Configurator, reconfigure the database using one of the following procedures.

    Shared Services Only:

    Note:

    In distributed environments where EPM System products are on machines different than Shared Services, you must perform this procedure on all servers.

    1. From the Foundation tasks in EPM System Configurator, select Configure Database.

    2. On the Shared Services and Registry Database Configuration page, select Connect to a previously configured Shared Services database.

    3. Specify the new password of the user whose account was used to configure Shared Services database. Do not change any other settings.

    4. Continue the configuration and click Finish when you are done.

    EPM System Products Other Than Shared Services:

    Note:

    Follow these steps for the EPM System products deployed on the current server only.

    1. From the configuration task list of the product in EPM System Configurator, select Configure Database.

    2. On the Database Configuration page, select Perform 1st-time configuration of database.

    3. Specify the new password of the user whose account was used to configure EPM System product database. Do not change any other settings.

    4. Click Next.

    5. Select Reuse the existing database.

    6. Continue the configuration, and click Finish when you are done.

    See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide for detailed instructions.

  4. Start EPM System products and services.