How to uninstall / completely remove Oracle 11g (client)?
deinstall.bat doesn't work.
The password is totally correct, since we could logon database via 11.2.0.3 (or above version) client. Here's my questions: We want to upgrade our DB from 11gR2 to 12cR2, do we have to change our instant client from elder version to newer one? Considering that we have plenty of clients with version 11.2.0.1, that would be a big action.
Edit: Further discussion related to why this question was closed and deleted: https://meta.stackexchange.com/questions/190441/why-was-this-question-related-to-uninstalling-the-oracle-database-client-deleted
Community♦
YvesYves4,5621212 gold badges4343 silver badges5757 bronze badges
4 Answers
Assuming a Windows installation, do please refer to this:
- Uninstall all Oracle components using the Oracle Universal Installer (OUI).
- Run regedit.exe and delete the HKEY_LOCAL_MACHINESOFTWAREORACLE key. This contains registry entires for all Oracle products.
- Delete any references to Oracle services left behind in the following part of the registry:
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesOra*
It should be pretty obvious which ones relate to Oracle. - Reboot your machine.
- Delete the 'C:Oracle' directory, or whatever directory is your ORACLE_BASE.
- Delete the 'C:Program FilesOracle' directory.
- Empty the contents of your 'C:temp' directory.
- Empty your recycle bin.
Calling additional attention to some great comments that were left here:
- Be careful when following anything listed here (above or below), as doing so may remove or damage any other Oracle-installed products.
- For 64-bit Windows (x64), you need also to delete the
HKEY_LOCAL_MACHINESOFTWAREWow6432NodeORACLE
key from the registry. - Clean-up by removing any related shortcuts that were installed to the Start Menu.
- Clean-up environment variables:
- Consider removing
%ORACLE_HOME%
. - Remove any paths no longer needed from
%PATH%
.
- Consider removing
This set of instructions happens to match an almost identical process that I had reverse-engineered myself over the years after a few messed-up Oracle installs, and has almost always met the need.
Note that even if the OUI is no longer available or doesn't work, simply following the remaining steps should still be sufficient.
(Revision #7 reverted as to not misquote the original source, and to not remove credit to the other comments that contributed to the answer. Further edits are appreciated (and then please remove this comment), if a way can be found to maintain these considerations.)
Community♦
ziesemerziesemer24.5k77 gold badges6868 silver badges8484 bronze badges
There are some more actions you should consider:
- Remove Registry Entries for MS Distributed Transaction Coordinator (MSDTC)Note: on the Internet I found this step only at a single (private) page. I don't know if it is required/working or if it breaks anything on your PC.
- Open Regedit
- Navigate to
HKEY_LOCAL_MACHINESoftwareMicrosoftMSDTCMTxOCI
- Add an x before each string for
OracleOciLib
,OracleSqlLib
, andOracleXaLib
- Navigate to
HKEY_LOCAL_MACHINESoftwareWow6432NodeMicrosoftMSDTCMTxOCI
- Add an x before each string for
OracleOciLib
,OracleSqlLib
, andOracleXaLib
Otherwise these files, if they exist, will still be in use next time you reboot, and unable to be deleted. - Remove environment variable
ORACLE_HOME
,ORACLE_BASE
,TNS_ADMIN
,NLS_LANG
if existCheck also Oracle doc to find all Oracle related environment variables, however apart from variables listed above they are very rarely used on Windows Client: Oracle Environment Variables - Unregister oci.dll
- Open a command line window (Start Menu -> Run... -> cmd)
- Enter
regsvr32 /u oci.dll
, resp.%windir%SysWOW64regsvr32 /u oci.dll
- In some cases the file
%ORACLE_HOME%binoci.dll
is looked and you cannot delete it. In such case rename the file (e.g. to oci.dll.x) and reboot the PC, afterwards you can delete it.
- Remove Oracle .NET assemblies from Global Assembly Cache (GAC). You do this typically with the gacutil utility, if available on your system. Would be like this:
- Entry
System.Data.OracleClient
should not be removed, this one is installed by Microsoft - not an Oracle component! - Instead of
gacutil /u ...
you can also useOraProvCfg /action:ungac /providerpath:...
if OraProvCfg is still available on your system. You may find it at%ORACLE_HOME%odp.netmanagedx64OraProvCfg.exe
.
- With a text editor, open XML Config file
%SYSTEMROOT%Microsoft.NETFramework64v4.0.30319Configmachine.config
and delete branch<oracle.manageddataaccess.client>
, if existing.- Do the same with:
Instead of editing the XML Config file manually you can also run (if OraProvCfg.exe is still available on your system): - Check following Registry Keys and delete them if existing
- Delete the Inventory folder, typically
C:Program FilesOracleInventory
andC:Program Files (x86)OracleInventory
- Delete temp folders
%TEMP%deinstall
,%TEMP%OraInstall
and%TEMP%CVU*
(e.g%TEMP%CVU_11.1.0.2.0_domscheit
) if existing.
26k44 gold badges3232 silver badges6161 bronze badges
Do everything suggested by ziesemer.
You may also want to remove from the registry:
So they no longer appear in the 'ODBC Drivers that are installed on your system' in ODBC Data Source Administrator
ranni rabadiranni rabadi
Do everything suggested by ziesemer.
You may also want to :
- Stop the Oracle-related services (before deleting them from theregistry).
- In the registry, look not only for entries named 'Oracle'but also e.g. for 'ODP'.
Pascal SartorettiPascal Sartoretti
protected by Community♦Jun 3 '14 at 16:10
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged oracleoracle11g or ask your own question.
I'm from MySQL background and am new to Oracle. I want to know
- What is meant by Oracle Client?
- What is its use?
- What is its equivalent in MySQL ?
Thanks
Zacky112Zacky1123,78988 gold badges2929 silver badges3636 bronze badges
3 Answers
What is meant by Oracle Client?
and
What is its use?
In this context, a client is a class library (DLL) that allows you to connect remotely to the underlying database of an application. A client, always within the same context, can also be called a
.NET Data Provider
.You may have multiple data providers based on the underlying database engine with which you're working.
There was
System.Data.OracleClient
(deprecated), provided by Microsoft.There is
Oracle.Data.Client
, which is actually the best ever built Oracle Client, or Oracle .NET Data Provider. You may also download the latest Oracle 11g Data Provider for .NET
.So, when accessing the Oracle underlying database, make sure your work with this provider, proper for your version of Oracle, and start doing
ADO.NET
with your favorite database! =PThere are also some other tools that you can work with that will ease your data access code pain, such as
Enterprise Library
or NHibernate
, both are frameworks to basically accessing databases.Enterprise Library
can do even more then that!And
NHibernate
is an ORM (Object/Relation Mapping)
tool that can work just very fine with Oracle.Remember though, always use
Oracle.Data.Client
namespace in the Oracle.DataAccess.dll
assembly.What is its equivalent in MySQL ?
As the equivalence for MySQL, I guess it would be
Will MarcouillerMySQL Connector/NET
.Will Marcouiller
18.3k1515 gold badges7979 silver badges133133 bronze badges
It is the Oracle binaries installed that allow communication with the Oracle database. It can be using SQL*Plus, JDBC (type II or IV) or OCI (Oracle Call Interface).
StelliosStellios
Its a piece of software that allows a remote computer to talk to Oracle. If you were to write a piece of software that communicated with the database, you would use the Oracle Client to facilitate that communication
Greg OlmsteadGreg Olmstead