Editing the Shared Services Registry

To edit the Oracle Hyperion Shared Services Registry:

Back up the Shared Services Registry.
On a machine hosting the 11.1.x Oracle Enterprise Performance Management System software, go to /bin and run the following command:
```
epmsys_registry view componentType
```
You need to view the component hierarchy to get the component property names that required to delete a component or update a component property.

For information see Viewing the Components in the Shared Services Registry.
Depending on the required changes, refer to the following commands:

To delete a component, see Deleting a Component Instance.

To update a component property, see Updating a Component Property.

Note:

When you run epmsys_registry commands on Linux, all # must be preceded by \.
If you changed the LOGICAL_WEB_APP property for any product, run EPM System Configurator and configure the web server again. (On the Task Selection page, select the Oracle Hyperion Foundation Services Web Server Configuration task.)

Viewing the Components in the Shared Services Registry

Before you can delete a component or update a component property, you need to view the component hierarchy to get the component property names and values.

To view the component hierarchy:

Go to /bin and use the following command:
```
epmsys_registry view componentType
```
where componentType is the name of the component in the Shared Services Registry.

This command displays all the components in the specified hierarchy, displaying only the immediate children of the component. The information is displayed in the console.

For example, to view all the components in the PLANNING_PRODUCT hierarchy, run:
```
epmsys_registry view SYSTEM9/PLANNING_PRODUCT
```
If needed, repeat the command to get the property names for a subcomponent.

For example, LOGICAL_WEB_APP is a child of PLANNING_PRODUCT. To view the properties for LOGICAL_WEB_APP for Oracle Hyperion Planning , enter the following command:
```
epmsys_registry view SYSTEM9/PLANNING_PRODUCT/LOGICAL_WEB_APP
```
From the display, note the following information about components you want to delete or update:
- Component ID for any components you want to delete or update
- Component property names and values for any components you want to update
For example, the LOGICAL_WEB_APP for Planning has several properties, including context, port, and host.

Deleting a Component Instance

You delete a component instance by referring to the component's ID that is displayed when you view the component hierarchy.

To delete a component from the component hierarchy, go to /bin and run the following command:

epmsys_registry deletecomponent #componentID

where componentID is the component's ID that you found when you viewed the component hierarchy.

On Linux, run:

epmsys_registry.sh deletecomponent \#componentID

Deleting a node does not delete its children.

Tip:

If you are deleting a product node, first delete all the children of the node and then delete the product node.

Caution:

Ensure that you delete the correct component.

Updating a Component Property

You update a component property by referring to the component ID and the component property name that are displayed when you view the component hierarchy.

To update a component property, go to /bin and run the following command:

epmsys_registry updateproperty #componentID/@componentProperty value

where componentID is the component's ID you found when you viewed the component hierarchy, componentProperty is the component property name you want to update, and value is the new value for the component property.

On Linux, run:

epmsys_registry.sh updateproperty \#componentID/@componentProperty value

Component property names are case sensitive.

Tip:

Look for the component property names in the section called "Properties" when you view the component hierarchy. In addition, you can update the host a component is running on using the property name "host."

For example, to change the port number for the Oracle Essbase Server with the component ID 99999 to port number 1425, enter the following command:

epmsys_registry updateproperty #99999/@agent_PortNumber 1425

Viewing Host Entries in the Shared Services Registry

You can view the host entries in the Shared Services Registry.

You can use this command for a number of purposes. For example, use the command to:

Simplify the rehosting process
Simplify the process of changing server names to alias names
Debug server communication issues

To view the host entries in the Shared Services Registry, go to /bin and run the following command:

epmsys_registry viewhosts

The displays shows the server names for this machine as they are stored in the Shared Services Registry in one column and the hostname as resolved by the DNS in another column

Tip:

If the names in the columns do not match, either resolve the DNS entries or create a hosts file to match the resolved names.