Set Up Shared Services and Registry Database Connection

Specify the settings for the Oracle Hyperion Shared Services and Registry database.

When you initially configure Oracle Enterprise Performance Management System products, you configure a database for use by Oracle Hyperion Foundation Services, which includes the Oracle Hyperion Shared Services Registry.

When you configure the Shared Services and Registry database, EPM System Configurator ensures that the database is connected and is a supported database type. If a database is detected, you might be prompted to choose whether to use the detected database or create a database.

If you are configuring an Oracle database, EPM System Configurator checks that the database was created with the correct character set. If not, you are prompted to correct it.

For a list of supported databases, see the Certification Matrix (https://www.oracle.com/middleware/technologies/bi-foundation/hyperion-supported-platforms.html).

For database prerequisites for this release, see Preparing a Database.

For more information about the Shared Services Registry, see About the Shared Services Registry.

Note:

This task assumes that you have created the database. If you have not created a database, see Preparing a Database.

If you uninstall EPM System products and then reinstall into the same location, you cannot reuse the Shared Services and Registry database.

The following table describes options for Shared Services and Registry Database configuration.

EPM System Configurator Fields	Description	Your Information
Connect to a previously configured Shared Services database/Perform first-time configuration of Shared Services database	When you first configure the Shared Services and Registry database, choose Perform first-time configuration of Shared Services database. This database includes the Shared Services Registry, which is used to store common information for all products. When you configure in a distributed environment, you must configure the Shared Services database on every machine. On the first machine, you are setting up the Shared Services Registry. For configurations on subsequent machines, choose Connect to a previously configured Shared Services database. In this case, you are letting the machine know the location of the Shared Services Registry. For some products, you can use this same database to store product information. In this case, each product has its own table in this database.
Database Type	Select the database type.
Server	Specify the name of the database server where the Shared Services database should be created. For Oracle RAC, specify the VIP name or one of the node names as the server name.
Port	Select the default or specify a custom Shared Services server port number on which the database listens.
Service Name or SID, or Database Name	Specify the name of the Shared Services database. If you are using an Oracle RAC database, specify the RAC service name.
User Name	Enter the name of the database user.
Password	Enter the password of the database user.
Advanced options (Optional)	Click or select to specify additional information. For more information on these options, see Advanced Options for Database Configuration (Optional). You can use this option to configure Oracle RAC or an LDAP-based JDBC URL.