Oracle Database Client and ODAC Installation

SPMS Application Clients and SPMS Web Servers are database clients. They need to connect to the SPMS Database to operate. As such, the installation of Oracle Full Client and ODAC setup is required.

Where to download Oracle Database Client

  1. For instructions, download a copy of the installation manual from the official Oracle Help Center website at https://docs.oracle.com/en/database/ and refer to the manual for steps to install.

  2. Similarly, to install the Oracle Database Setup file, refer to the website at https://www.oracle.com/database/technologies/instant-client/downloads.html and download the appropriate Microsoft Windows installation file.

  3. Alternatively, you could obtain a specific setup file from Oracle Support/DBA. For example, these are some of the installers made available:

    • OracleClientSetup_12201_FULL.exe and ODTwithODAC122011, or

    • OracleClientSetup_12201_FULL_ODAC_v1.exe; or

    • Oracle Client 19c

How to register Oracle Database Client DLLs to the Local Environment

The Oracle Database Setup file downloaded from the Oracle website will not automatically register the above DLLs to the local client. Oracle provides a tool (OraProvCfg.exe) to help you to register the DLLs.

For example:

  • Navigate to %ORACLE_CLIENT_HOME%\ODP.NET\bin\2.x.

  • Run the following command: oraprovcfg.exe/action:gac/providerpath:Oracle.DataAccess.dll

The specific Setup file from Oracle Support/DBA will normally register DLLs automatically.

For SPMS to be able to connect to the Oracle Database, the Oracle Database Client DLLs must be registered to the local client. The DLLs that must be registered are:

  • Oracle.DataAccess.dll

    • Folder: ORACLE_HOME\odp.net\bin\2.x

  • All DLLs under PublisherPolicy folder: Policy.X.XXX.Oracle.DataAccess.dll

    • Folder: ORACLE_HOME\odp.net\PublisherPolicy\2.x

  • Oracle.ManagedDataAccess.dll

    • Folder: ORACLE_HOME\odp.net\managed\common
  • All DLLs under PublisherPolicy folder: Policy.X.XXX.Oracle.ManagedDataAccess.dll
    • Folder: ORACLE_HOME\odp.net\managed\PublisherPolicy\4

Note:

To establish a Database connection using Oracle Net Manager, use the following steps:

  1. Once the Oracle Client installation is successful, launch the Oracle Net Manager to establish the connection between the Database Client and Database Server.

  2. When installing the ODAC, ensure the following components for Oracle 19c are installed:

    • Oracle Data Provider for .NET

    • Oracle Providers for ASP.NET

    • Oracle Services For Microsoft Transaction Server