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:
-
On the machine hosting Foundation Services, update the
TNS_ADMIN
environment variable to point to the location of the existing Oracle Database Client'stnsnames.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. -
Move TNS entries from
EPM_ORACLE_INSTANCE/user_projects/config/dbclient/tnsnames.ora
(which is populated during database configuration) to the existingtnsnames.ora
file. Copy the entire file contents and append to the existing contents of thetnsnames.ora
file.