Tasks in the Release 11.2.15 Target Environment

1. Oracle Database and SQL Server: Stop Oracle Enterprise Performance Management System services.

2. For Oracle Database: Import the source database you exported from Release 11.2.12+ (hfm_source) to be used with the Release 11.2.15 environment. Use Oracle Data Pump to import to a different schema (for example, hfm_target).

   impdp <user>/<password>@<SID> DIRECTORY=data_pump_dir dumpfile=<DatabaseDumpFile.dmp> logfile=import.log SCHEMAS=<schema name to be imported>

   For example:

   impdp <hfm_source>/<password>@<SID> DIRECTORY=data_pump_dir dumpfile=<hfm_source.dmp> logfile=import.log SCHEMAS=<schema name to be imported>

   For Oracle Database 21c - Ensure that you open the pluggable database and set <CONTAINER=PDB NAME> as indicated below, prior to executing the import command:

   ALTER PLUGGABLE DATABASE ALL OPEN;
   ALTER SESSION SET CONTAINER=<PDB NAME>

   impdp <system>/<password>@<PDB SID> DIRECTORY=data_pump_dir dumpfile=<DatabaseDumpFile.dmp> logfile=import.log SCHEMAS=<schema name to be imported>

3. For SQL Server: To restore the backup of Oracle Hyperion Financial Management schema to the target environment, perform the following steps:

   • In the Target database server (11.2.15), launch SQL Server Management Studio.

   • In the left pane, right-click on Database and select Restore Database.

   • Navigate to the HFM database backup file (.bak) that was copied in step 4. Click OK.

   • On the Restore Database screen, click OK. A confirmation message stating that the database has been restored will appear.

   • In order to comply with the target database schema naming convention, rename the restored HFM schema (if required).

4. Oracle Database and SQL Server: Restart all EPM System servers and run Oracle Hyperion Enterprise Performance Management System Diagnostics.