1. Installation and Configuration Guide
  2. Preparing Your Environment
  3. Preparing a Database
  4. Using an Oracle Database
  5. Using an Existing Oracle Database Client

Using an Existing Oracle Database Client

For a new installation, if you want to use your existing Oracle Database Client instead of the one installed with EPM System, during EPM System installation clear the selection from Oracle Database Client 32-bit and Oracle Database Client 64-bit under Foundation Services. Then, after installing and configuring Oracle EPM System, perform the following steps:

  1. On the machine hosting Foundation Services, update the TNS_ADMIN environment variable to point to the location of the existing Oracle Database Client's tnsnames.ora file location. If you are using a separate database for Oracle Hyperion Financial Management, make this change on the server hosting the xfm process.

  2. Move TNS entries from EPM_ORACLE_INSTANCE/user_projects/config/dbclient/tnsnames.ora (which is populated during database configuration) to the existing tnsnames.ora file. Copy the entire file contents and append to the existing contents of the tnsnames.ora file.