Changing the Shared Services and Registry Database Connection Information and Password

Changing the Shared Services password also changes the EPM Workspace password.

If you are working in a distributed environment, repeat this procedure on each machine in the deployment.

  To update the connection information for the Shared Services Registry database (changing the password or the server):

  1. Make a backup copy of the Shared Services Registry database.

  2. If you are changing the password, using the database administration console, change the password of the user account that was used to configure the Shared Services database.

  3. Stop EPM System Web applications and services and processes, and stop the original Shared Services Registry database.

  4. On the machine hosting Shared Services, start EPM System Configurator.

  5. On the “Configure a New or Existing EPM Oracle Instance” page, select Modify an existing EPM Oracle instance.

  6. On the “Shared Services and Registry Database Configuration” page, select Connect to a previously configured Shared Services database, and then enter the new password or database connection information.

    You cannot change the database type.

  7. Click Next to go to the Task Selection page, and then close EPM System Configurator.

    The reg.properties file is now updated with the new database connection information.

  8. On the machine hosting Shared Services, launch EPM System Configurator again with the enableRegTask option: Change to EPM_ORACLE_HOME/common/config/version_number and then launch configtool.bat|.sh -enableRegTask.

  9. On the “Configure a New or Existing EPM Oracle Instance” page, select Modify an existing EPM Oracle instance.

  10. On the Task Selection page, under the Foundation tasks, select Configure Database.

  11. On the “Shared Services and Registry Database Configuration” page, select Connect to a previously configured Shared Services database and re-enter the new database connection information.

  12. Continue through EPM System Configurator and return to the Task Selection page. On the Task Selection page, for any other products that are configured to use the Shared Services Registry database, select Configure Database.

    For these products, on the “Database Configuration” page, select Connect to a previously configured database and re-enter the new database connection information

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

  14. Restart the Web applications and services and processes.

  15. If you are working in a distributed environment, repeat steps step 4 - step 7 on each machine in the deployment, launching EPM System Configurator on each machine.