Oracle Driver: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 11: | Line 11: | ||
[[File:Oracle Command line install.png|none|thumb|979x979px]] | [[File:Oracle Command line install.png|none|thumb|979x979px]] | ||
== Uninstall Oracle Driver on UMS backend server == | ==Uninstall Oracle Driver on UMS backend server== | ||
* Remove the drivers using Control Panel\Manage programs and features | *Remove the drivers using Control Panel\Manage programs and features | ||
* Reboot the server | *Reboot the server | ||
[[File:Oracle driver uninstall.png|none|thumb|775x775px]] | [[File:Oracle driver uninstall.png|none|thumb|775x775px]] | ||
In some cases you have to clean up from registry database, use this method: | In some cases you have to clean up from registry database, use this method: | ||
* Delete any Oracle folders in the PC's C:\ drive (i.e. C:\Oracle, C:\Oracle10g, C:\Oracle9i) | *Delete any Oracle folders in the PC's C:\ drive (i.e. C:\Oracle, C:\Oracle10g, C:\Oracle9i) | ||
* Open Windows Registry by typing regedit in the Start menu's Search box | *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 | *When the Registry Editor opens, back it up by clicking File > Export... and save the file | ||
* Locate the following registry entries: | *Locate the following registry entries: | ||
*# in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\, delete VGER folder | *#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\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\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, 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_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\ODBC Data Sources, delete VGER REG_SZ entry | ||
*# in HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\, delete VGER folder | *#in HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\, delete VGER folder | ||
* Reboot the PC | *Remove the TNS_ADMIN environment variable from System Properties | ||
*Reboot the PC | |||
<br /> | <br /> | ||
== FAQ == | ==FAQ== | ||
===TNS_ADMIN variable not found=== | ===TNS_ADMIN variable not found=== |
Revision as of 12:46, 14 January 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
- Remove the drivers using Control Panel\Manage programs and features
- Reboot the server
In some cases you have to clean up from registry database, use this method:
- Delete any Oracle folders in the PC's C:\ drive (i.e. C:\Oracle, C:\Oracle10g, C:\Oracle9i)
- 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
- Remove the TNS_ADMIN environment variable from System Properties
- 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