Specify the settings for the Shared Services and Registry database.When you initially configure EPM System products, you configure a database for use by Foundation Services, which includes the 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 may 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. See the Oracle Hyperion Enterprise Performance Management System Installation Start Here for character set requirements.
For a list of supported databases, see the Oracle Hyperion Enterprise Performance Management System Certification Matrix (http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html). For database prerequisites for this release, see Oracle Hyperion Enterprise Performance Management System Installation Start Here.
You can use Windows Authentication for SQL Server connections if you use Microsoft SQL Server database. See Setting Up Microsoft SQL Server Windows Authentication.
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” in Oracle Hyperion Enterprise Performance Management System Installation Start Here. |
If you uninstall EPM System products and then reinstall into the same location, you cannot reuse the Shared Services and Registry database.
If you are upgrading from an earlier release, select Perform first-time configuration of Shared Services database and enter database connection information for a new database.
If you are upgrading from Release 11.1.1.3, and you configured all EPM System products to use one database, you are alerted that pre-existing Shared Services tables have been detected in the database. When prompted to drop and recreate the tables, select Yes.
Note: | If you are applying the maintenance release to move from Release 11.1.2.0 to Release 11.1.2.1, select Connect to a previously configured Shared Services 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. See “Installation Planning Checklist” in Oracle Hyperion Enterprise Performance Management System Installation Start Here for additional information about database preparation for each product. Upgrade Note! If you are upgrading from an earlier release, select Perform first-time configuration of Shared Services database and enter database connection information for a new database. If you are applying the maintenance release to move from Release 11.1.2.0 to Release 11.1.2.1, select Connect to a previously configured Shared Services database and select a release number. | |
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. Note: If the password changes, reconfigure as described in Reconfiguring EPM System Products. | |
Advanced options (Optional) | Click or select to specify additional information. For more information on these options, see Advanced Options for Database Configuration (Optional). |