Change/Update EPM/Hyperion Shared Services Database Server

STEP 0: Stop ALL EPM Components

STEP 1: Migrated Databases and all objects from previous database server to the new database server.

STEP 2: Execute Configtool on each server to reconfigure the Shared Services/Foundation database connection.

STEP 3: Edit the Database connections within the Weblogic Admin Console for EACH Weblogic Domain (EPM, Planning, ODI).

STEP 4: Update the server name for each EPM component via the EPM registry editor.

STEP 5: ODI

STEP 6: DRM

STEP 7: Update Static Connections from Tables

STEP 2: Execute Configtool on each server to reconfigure the Shared Services/Foundation database connection.

STEP 2A: Windows servers

1. Open a command prompt window /SSH session on EACH EPM Server.
2. Execute the following on one server at a time. Do not run multiple instances of the configtool utility.

e:\Oracle\middleware\EPMSystem11R1\common\config\11.1.2.0\configtool.bat –enableRegTask

1. Verify the correct EPM Home and Instance name and click Next.

1. Verify “Connect to a previously configured Shared Services database” is selected. The fields will be set to defaults, not the previous server configuration. Update all of the fields with new server information. Don’t forget to click Advanced Options to set the index and data table names. Click next when finished.

1. Uncheck “Check All” and Expand Hyperion Foundation to verify that only Configure Database is selected. Click next.

1. Click Next on the verification screen.

1. Click Finish after the configuration has completed successfully.

STEP 2B: Linux servers

1. Open a SSH session on EACH EPM Server, along with a xming or another X windows viewer/emulator.
2. Export the display, if it isn’t already exported.

export DISPLAY=localhost:12.0 (12.0 is an example of the port)

1. Execute the following on one server at a time. Do not run multiple instances of the configtool utility.

/usr/local/epm/Oracle/Middleware/EPMSystem11R1/common/config/11/1/2/0/configtool.sh –enableRegTask

STEP 3: Weblogic

Click Save at the bottom.

Edit all other datasources and save changes.

Click Activate Changes

STEP 4: EPM Registry tool

E:\Oracle\Middleware\user_projects\epmprcsa\bin

epmsys_registry view #3e9893979a3f7214S7ff849213c6d60685fS7aad

epmsys_registry updateproperty #3e9893979a3f7214S7ff849213c6d60685fS7aad/@dbJdbcUrl “jdbc:oracle:thin:@EPMPRD.DOMAIN:1530:EPMPRHYP”

Verify:

Do the same thing for the name:

epmsys_registry updateproperty #1d9f9df2306c801d48b124b113c6816c1c2S7aea/@NAME “EPMPRDBOA.DOMAIN:EPMPRHYP:EPMEAS”

UPDATE PLANNING DATASOURCES

UPDATE ODI STUDIO CLIENT

Update Workrep1 connection:

Planning Servers stuck in Admin Mode: