RWS/ISHServer

Add support for the installation of ODAC 19c Release 3 for Microsoft Windows 32-bit

beutepa opened this issue · 0 comments

Add support for installing the Oracle Database 19c Release 3 ODAC (19.3.0.0.0) for Microsoft Windows 32-bit using the 'xopy' deployment

Zip package required/to use: ODAC193Xcopy_32bit.zip
source: https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html
ODAC XCopy section - 32-bit ODAC 19.3

(Manual) Steps to automate (might need some more details):

  • Extract to a temporary directory like C:\Temp\ODAC193Xcopy32bit
  • Open a 32-bit Command Prompt as administrator
    and Type: \Windows\SysWOW64\cmd and right click and choose run as administrator
  • cd C:\Temp\ODAC193Xcopy32bit
  • execute: install.bat oledb C:\Oracle\product\19.0.0\ODAC ODAC
  • Open Control Panel - System - Advanced system settings - Environment Variables
    Go to System variables - path and click Edit
  • Add 2 new lines and make sure that these are on top (Move Up):
    C:\Oracle\product\19.0.0\ODAC
    C:\Oracle\product\19.0.0\ODAC\bin
  • Extra environment variable TNS_ADMIN --> .NET connectionstring to tnsnames.ora
  • After this reboot the server OR command prompt as administrator and execute: iisreset /restart ((https://stackoverflow.com/questions/43321731/iis-cannot-get-my-environment-variable))