Oracle Driver: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
|||
| (11 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
== Install Oracle Driver on UMS backend server == | ==Install Oracle Driver on UMS backend server== | ||
Download latest (known compatible) version of the "Oracle Instant Client" from http://downloads.inlogic.dk/Oracle%20Instant%20client.zip | Download latest (known compatible) version of the "Oracle Instant Client" from http://downloads.inlogic.dk/Oracle%20Instant%20client.zip | ||
| Line 11: | Line 11: | ||
[[File:Oracle Command line install.png|none|thumb|979x979px]] | [[File:Oracle Command line install.png|none|thumb|979x979px]] | ||
=== TNS_ADMIN variable not found === | ==Uninstall Oracle Driver on UMS backend server== | ||
*Uninstall the drivers using the "c:\oracle\UMS uninstall.bat" (IMPORTANT! Run as administrator) | |||
*close command prompt | |||
*delete c:\oracle directory | |||
*Execute GetStudents - if it fails, follow the next step | |||
*Open C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config (IMPORTANT! Run Notepad as administrator) | |||
**Remove all entries with has something to do with Oracle | |||
**Save file | |||
*Execute GetStudents - if it fails, follow the next step | |||
If you by accident have deleted the c:\oracle folder without using the uninstall feature, then you have to remove Oracle from Windows Registry | |||
*Open Windows Registry by typing regedit in the Start menu's Search box | |||
*When the Registry Editor opens, back it up by clicking File > Export... and save the file | |||
*Locate the following registry entries: | |||
*#in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\, delete VGER folder | |||
*#in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources, delete VGER REG_SZ entry | |||
*#in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Oracle\, delete KEY_OraClient10g_home folder | |||
*#in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI, delete everything EXCEPT ODBC Data Sources | |||
*#in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources, delete all entries except (Default) | |||
*#in HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources, delete VGER REG_SZ entry | |||
*#in HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\, delete VGER folder | |||
*Reboot the PC | |||
<br /> | |||
==FAQ== | |||
===TNS_ADMIN variable not found=== | |||
In some cases the UMS install bat are not allowed to set the default environment path for TNS_ADMIN. | In some cases the UMS install bat are not allowed to set the default environment path for TNS_ADMIN. | ||
In this case it must be added manually. Open windows Environment Variables | In this case it must be added manually. Open windows Environment Variables | ||
[[File:Environment Variables.png | [[File:Environment Variables.png|thumb|470x470px|none]] | ||
Add a new variable with the following information | Add a new variable with the following information | ||
[[File:Oracle Environment Variable.png|left|thumb|841x841px]] | [[File:Oracle Environment Variable.png|left|thumb|841x841px]] | ||
Latest revision as of 12:37, 28 February 2019
Install Oracle Driver on UMS backend server
Download latest (known compatible) version of the "Oracle Instant Client" from http://downloads.inlogic.dk/Oracle%20Instant%20client.zip
Extract zip folder to c:\temp
Note: UMS Configurator must not be open when installing Oracle (results in "sharing violation")
Open command prompt as administrator and navigate to c:\temp
Run "UMS install.bat"
Uninstall Oracle Driver on UMS backend server
- Uninstall the drivers using the "c:\oracle\UMS uninstall.bat" (IMPORTANT! Run as administrator)
- close command prompt
- delete c:\oracle directory
- Execute GetStudents - if it fails, follow the next step
- Open C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config (IMPORTANT! Run Notepad as administrator)
- Remove all entries with has something to do with Oracle
- Save file
- Execute GetStudents - if it fails, follow the next step
If you by accident have deleted the c:\oracle folder without using the uninstall feature, then you have to remove Oracle from Windows Registry
- Open Windows Registry by typing regedit in the Start menu's Search box
- When the Registry Editor opens, back it up by clicking File > Export... and save the file
- Locate the following registry entries:
- in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\, delete VGER folder
- in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources, delete VGER REG_SZ entry
- in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Oracle\, delete KEY_OraClient10g_home folder
- in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI, delete everything EXCEPT ODBC Data Sources
- in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources, delete all entries except (Default)
- in HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources, delete VGER REG_SZ entry
- in HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\, delete VGER folder
- Reboot the PC
FAQ
TNS_ADMIN variable not found
In some cases the UMS install bat are not allowed to set the default environment path for TNS_ADMIN.
In this case it must be added manually. Open windows Environment Variables
Add a new variable with the following information
