Oracle Data Access Components (ODAC) is a library of components that provides native connectivity to Oracle for both 32-bit and 64-bit platforms. Its one of the important components of GINESYS. While installing GINESYS, ODAC is installed automatically. Retail Management Ginesys Web Reports, SMS Notification and Import Excel features depends on ODAC so it is necessary that ODAC is always up and running. Now, it may happen that the ODAC stops working or gets corrupted, which would affect the Retail Managementabove modules. This article is all about installing ODAC (1112.21.0.2.1) in both 32-bit and 64-bit machines.
Warning | ||
---|---|---|
| ||
Note: In a 32-bit machine, ODAC is installed through a guided GUI (Graphical User Interface) and following the process correctly ensures proper installation of ODAC. |
Step-by-step guide
Follow the steps below to know what system type is windows running on -
...
Location:
...
PRE-REQUISITES
The pre-installation checks for installing ODAC in a 64-bit machine are given below.
...
- <%System Root%\system32> path in the Environmental Variable. (More)
- <%SystemRoot%> path in the Environmental Variable.
- Power shell in the root drive - e.g. C:\WINDOWS\system32\WindowsPowerShell\v1.0
- The value of the Promotable Transaction Key - <Local>
STEPS FOR ODAC INSTALLATION
32-bit Operating System
- Open the 32 bit folder.
- Double click and run the Setup file.
64-bit Operating System
- Open the 64 bit folder.
- Copy the folder into one of the system drives. For example the D:\
- Open the Command Prompt and remember to run it as Administrator.
- In the Cmd window, open the copied folder.
- To change the drive to D: type the D:\ and hit enter
- Now, type CD 64BIT which is the name of the folder we copied. The cursor would change to D:\64BIT as we have selected the 64BIT folder.
- Type the command install.bat all [drive]\[folder] odac, this would install the .bat file in the this folder. for example install.bat all c:\ODAC64 odac
- Once the process is completed GINESYS can be used normally.
...
Step-by-step guide
Follow the steps below to know what system type is windows running on -
- Click the Start button.
- Right click Computer, select Properties.
- The Properties window opens up.
- Under System check out the System Type. It would either be a 32-bit operating system or a 64-bit operating system
STEPS FOR ODAC INSTALLATION
- Find the ODAC for your machine at <Ginesys installed drive>\GSL\GINESYS12\Shared\Dumps\ODAC12c
- for 64 bit it is - x64
- for 32 bit it is - x86
- Open cmd (command prompt), right click it and select Run as Administrator. Now put in the following command and press Enter -
cd <path of the file given in Step 1> In the next line of the cmd, type in the following command and press Enter -
install.bat all C:\ODAC64 odac or install.bat all C:\ODAC32 odac
Tip title Important Note: Please remember that the name of the folder where the .bat folder would be installed should be named "ODAC64" for 64bit systems and "ODAC32" for 32bit systems.
...
...
Installing the
...
ODAC64 or ODAC 32 in the root directory will ensure easy operations and search for the required files.
- Open regedit and look for HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ODP.NET\2.121.2.0 and HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ODP.NET\4.121.2.0 and double click the Promotable Transactions in both cases and change the value from promotable to local.
Now in regedit, look for Software\Wow6432Node\ODP.NET\2.121.2.0 and Software\Oracle\ODP.NET\4.121.2.0 and double click the Promotable Transactions in both cases and change the value from promotable to local.
Now your ODAC will be successfully installed.
For more information on ODAC, follow the link: Ginesys cannot be started due to an ODAC error.
...