Restoring the Database to a Different Server

If you back up a database from one server and restore it to a second server (for example, because the first database server is under maintenance), you must use the WebLogic Admin Console to update the data source and the reg.properties file:

  To restore a database to a different server:

  1. Update the data source:

    1. From the WebLogic Admin Console, select Services, then dataSource, and then EPMSystemRegistry.

    2. On the Connection Pool tab, specify the user name, password, and JDBC URL for the second server.

    3. Click Save and Activate Changes.

  2. Open reg.properties with a text editor and update the user name, password, and JDBC server URL.

    The reg.properties file is in EPM_ORACLE_INSTANCE/config/foundation/11.1.2.0.

  3. Start Shared Services.