Have a read of the following Oracle Support doc - "Error Configuring EPMA Database: 'The Oracle Data Access Client is not installed' [ID 1210084.1]"
Can you please validate what meant by oracle client. Is this Oracle database client 64 bit since our understanding is that EPMA uses 64bit client.
As we said we installed this database client using custom but did not select the option "Oracle Data Provider for .NET". Can we just add this component or uninstall the whole Oracle 64bit client? Or can we re-run the install and reselect all 6 components? (Oracle Java Client, SQL*Plus, Oracle JDBC/THIN Interfaces, Oracle Call Interface(OCI), Oracle Net, Oracle Data Provider for .NET). Please advise?
Thanks a lot John. You have been very helpful.
Yes the Oracle database client, just uninstall and reinstall, if you want to be sure install administrator option.
Thank you very much for all your help John.
We uninstalled the 64 bit Oracle client using the Standalone Deinstall Tool downloaded from OTN. Wen then reinstalled the Client by choosing the Custom option and selected the following options.
- Oracle Java Client
- SQL*Plus, Oracle JDBC/THIN Interfaces
- Oracle Call Interface(OCI)
- Oracle Net
- Oracle Net, Oracle Data Provider for .NET
Everything worked correctly after that. Phillip
I'm having the same error being discussed here: I've installed Oracle client 32bit (installation type Administrator) but when I try to configure EPMA I'm getting the "The oracle data access client is not installed" error message. I've installed 32bit version because the EPM 220.127.116.11 installation guide states "Strategic Finance and FDM both require that a 32-bit Oracle Database client be installed"
I've also tried to uninstall and reinstall the database client, this time using the custom option and I've selected ALL the available components (including Oracle Data Provider for .NET) but still I keep getting the same error message.
I did other EPM installations with the same configuration and never had this kind of problem. What else can I check?