You definitely need to install the Oracle Client Interface (OCI) software on the Domino server that runs DECS and serves your Notes application. You will also want to install the OCI on your development system, so that you can perform PL/SQL queries and metadata mapping. Having the vendor's interface software installed is required for all the Lotus connectors -- they provide a common gateway, by complying with the connector API, for DECS and LEI to communicate with a vendor's API. Think of the connector as the name implies -- it connects the Lotus product (DECS or LEI) to the vendor's product (in your case, that's Oracle). Please note that Lotus differentiates between Oracle 7 (-) and Oracle 8 (+) by providing two different connectors for each. Ensure that you choose the correct connector when defining your connection documents.
Dig Deeper on LEI and DECS for Lotus Notes Domino
Related Q&A from Scott Lemieux
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.