Add support for the installation of ODAC 19c Release 3 for Microsoft Windows 32-bit
beutepa opened this issue · 0 comments
beutepa commented
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))