Configure Oracle Data Handler

Before connecting to Oracle Database 18c or 19c using the Database Connection option, you should install Oracle Client on your machine and configure AVEVA Work Tasks Oracle data handler as follows:

1. Copy TNSNAME.ORA from <Oracle Installation path>\NETWORK\ADMIN folder to

   • <AVEVA Work Tasks Installation Path>\Bin folder

   • <AVEVA Work Tasks Installation Path>\Web\EnterpriseConsole folder

   • <AVEVA Work Tasks Installation Path>\Web\EnterpriseConsole\Bin folder

2. Include TNSNAME configuration in the Enterprise Console web.config file (this is applicable for all Enterprise Consoles where Oracle data access is required).

   </system.web.extensions>

   <oracle.manageddataaccess.client>

   <version number="*">

   <dataSources>

   <dataSource alias= "<Connection name/SID> descriptor="(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = < Fully qualified host name as in TNSNAME.ORA>)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = < Fully qualified service name as in TNSNAME.ORA>)))" />

   </dataSources>

   <edmMappings>

   <edmMapping dataType="number">

   <add name="bool" precision="1"/>

   <add name="byte" precision="2" />

   <add name="int16" precision="5" />

   </edmMapping>

   </edmMappings>

   </version>

   </oracle.manageddataaccess.client>

   </configuration>

If the above configuration gives error while loading Enterprise Console, then include the following configuration in the Enterprise Console web.config file:

<configSections>

    <section name="oracle.manageddataaccess.client"

     type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342"/>

  </configSections>

Note:
- In case of multiple Enterprise Consoles or the Enterprise Server, ensure you configure for each Enterprise Console and Server.

- When you upgrade the product from earlier versions to AVEVA Work Tasks 2023 R2, copy TNSNAME.ORA file to the folder:
- C:\Program files\AVEVA\Work Tasks\Bin
- C:\Program files\AVEVA\Work Tasks\Web\EnterpriseConsole
- C:\Program Files\AVEVA\Work Tasks\Web\EnterpriseConsole\Bin