Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Client install sequence before EPM install..

user623259Jul 4 2011 — edited Jul 16 2011
Hi All,

I'm trying to install EPM 11.1.2.1 on a Windows 2008 R2 Standard Server(64 bit). IIS 7. This a development/proof of concept set up.

I want to install Foundation, EPM Architect, Essbase, Planning, Reporting and Analysis, HFM, Strategic Finance and FDM on the same machine.

I want to install an Oracle 11g database 64 bit database to use as repository.

According to the Installation documents, EPM Architect and HFM support 64 bit Oracle client, but Strategic Finance and FDM require 32 bit Oracle client.

I installated them in the following order.

Oracle 11g 32 bit client
Oracle 11g 64 bit database
Oracle 11g 64 bit client

I faced issues in configuring EPM Architect where it didn't recognize ODAC installation.

1. What should be the order in which I should install the Oracle 11g 64 bit database, Oracle 11g 32 bit client and Oracle 11g 64 bit client ?

2. To install ODAC (ODP for ASP.NET ), I had to use the custom option for the clients, but the custom option shows listener and MTS services.
Should I install them for each client ?

Thanks.

Comments

odie_63

Hi,

Simple example :

If the count() function returns 11, then 11 div 10 = 1.1 (datatype xs:decimal), and 1.1 is not a valid value for the sequence iterator, it must be an integer.

At this point you have different options depending on how you want to round the value to an integer :

  • using fn:round()
  • using fn:floor()
  • using fn:ceiling()
  • casting to xs:integer directly : for $v in 1 to xs:integer(fn:count($anyType1/*:adad) div 10)

Your choice.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details