Install the full Oracle Database client on the following machines before you start your installation of EPM System products:
Performance Management Architect Dimension server
Financial Management application server
FDM Application Server and any machine that has FDM Workbench
It is important to install the full database client as part of the installation because the PATH variable is updated to include the path to the /bin folder of the Oracle client. This setting is required for successful configuration.
If you are using Oracle Database 10.2.0.4+, you must use a minimum of Oracle Database client 220.127.116.11.0.
On Windows 64-bit systems, Performance Management Architect and Financial Management both require that a 64-bit Oracle Database client be installed. Strategic Finance and FDM both require that a 32-bit Oracle Database client be installed. Note that Strategic Finance only uses the Oracle OLEDB driver supplied in the Oracle Database client install.
Financial Management and FDM can coexist on Windows 2008 64-bit systems using IIS7; however, there is a required sequence for installing the Oracle Database clients to support this scenario. You must install the Oracle Database 32-bit client first, then install the Oracle Database 64-bit client. If you already have installed both Oracle Database clients, uninstall the 64-bit client and install it again.
If you are using FDM or Performance Management Architect Dimension Server, Oracle Data Provider (ODP) for .NET 2.0 (from the Oracle Data Access Component (ODAC) package) is required and must be installed by a user with Windows administrator rights.
In order to use Oracle RAC/SCAN, install OCI (Oracle Call Interface) as part of the Oracle database client installation.
If your database resides on a remote computer, create a Net Service Name that enables the product to connect to the remote database.
Use the global database server name when specifying locations and paths. Do not use localhost as a server name.