Oracle Driver: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Sva (talk | contribs)
No edit summary
Sva (talk | contribs)
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:
    1. in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\, delete VGER folder
    2. in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources, delete VGER REG_SZ entry
    3. in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Oracle\, delete KEY_OraClient10g_home folder
    4. in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI, delete everything EXCEPT ODBC Data Sources
    5. in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources, delete all entries except (Default)
    6. in HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources, delete VGER REG_SZ entry
    7. 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