- Oracle Client 10.1 Download Free
- Oracle Client Downloads
- Oracle Client Software Download
- Oracle Client 10.2 Download
Do not perform this step if you are installing Oracle BI EE Release 10.1.3.3.1 or later. In the 10.1.3.3.1 and later releases, the installer automatically places the client executable file in the deployed analytics/analytics/client directory. Thanks Bryce. I was trying to download the Mac 10.1, but this link helpfully revealed that all versions are put on the download page, so I was able to figure out that the version I was having a hard time locating was never built for mac! – Mark Harrison Mar 23 '12 at 16:50. On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1. Find out with our feature matrix. Then, get your free, 30-day trial of Toad® to save hours, increase accuracy and enjoy easier workdays. If you are a licensed customer and are looking to upgrade to our latest version of Toad, please visit the support portal.
Active3 months ago
How to uninstall / completely remove Oracle 11g (client)?
deinstall.bat doesn't work.
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,7621212 gold badges4545 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.8k77 gold badges6969 silver badges8888 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 locked 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.
27.6k44 gold badges3535 silver badges6464 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.
Install an Oracle client on the ArcGIS client machine, set environment variables that reference the Oracle client, and connect to the database from the ArcGIS client.
To use your Oracle data in services published to ArcGIS Server, you must also register the database with ArcGIS Server.
Connect from ArcGIS for Desktop
To connect to a database or geodatabase in Oracle from ArcGIS for Desktop, install an Oracle client on the ArcGIS for Desktop computer, set the PATH environment variable to the location of the Oracle client, and create a connection file in the Catalog tree.
Install the Oracle client
To make a connection from a client machine to an Oracle database, you must install the Oracle client application on the client machine. Be sure you install a release of the Oracle client application that is compatible with the release of the database to which you want to connect.
Note:
If you are connecting from a 32-bit ArcGIS client, you must install a 32-bit Oracle client. This is true even if you install the ArcGIS client application on a computer with a 64-bit operating system (OS) and the database and server OS are 64-bit. If you are connecting from a 64-bit ArcGIS client, you must install a 64-bit Oracle client.
You can obtain the Oracle Instant, Runtime, or Administrator Client from Oracle, and install it on the client computer, following the directions in your Oracle documentation.
Set the PATH variable
Set the PATH environment variable on ArcGIS for Desktop to the location of the Oracle Client installation. See Microsoft Windows documentation if you need instructions for setting the PATH environment variable.
Note:
If both ArcGIS for Desktop and ArcGIS for Server are installed on the same Windows computer, set the PATH variable to read the 64-bit client before the 32-bit client. For example, if your 32-bit Oracle Instant Client is installed to c:Program Files (x86)Oracle and your 64-bit Oracle Instant Client is installed to c:Program FilesOracle, add the following to the beginning of your PATH variable value on Windows: C:Program FilesOracle;C:Program Files (x86)Oracle;.
If ArcGIS for Desktop was running on the machine before you set the PATH variable, restart ArcGIS for Desktop to pick up the new setting.
Connect to the database
You can connect to a database or geodatabase in Oracle by adding a database connection under the Database Connections node in the Catalog tree in ArcGIS for Desktop.
Tip:
If you have connection files that were created prior to ArcGIS 10.1, they will still work. However, if you need to create a connection to a 10.2.2 or older release geodatabase using an ArcSDE service, use the Create ArcSDE Connection File geoprocessing tool.
- Expand Database Connections in the Catalog tree in ArcMap or ArcCatalog and double-click Add Database Connection.
- Choose Oracle from the Database Platform drop-down list.
- When connecting to Oracle, either type the Oracle TNS name in the Instance text box, or provide one of the following Oracle Easy Connect strings:
- The name of the Oracle server/Oracle service name or IDFor example, if Oracle is installed on myserver and myosvc is the Oracle service name, type the following:The headphones, which ar.In the run-up to Microsoft’s Surface event next month, Microsoft is running a big sale on the whole Surface range, from the Surface Go to the Surface Book. Microso.You can now get a Surface Go from Microsoft Store and get a free HEX Surface Go sleeve ($44.95 value). The Windows 10 S 2-in-1 detachable comes with integrated 4G LTE for seamless connectivity, meaning you.A month after the last discount, Microsoft’s well-received Surface Headphones are once again $100 off. The headphones, which are appealing especially to developers and other office wor.If you are a regular Xbox Live subscribers there is now an amazing deal available to you which will give you access to more than a hundred games on your Xbox or PC for only a dollar. Download android sms to pc. The Surface Go range is seei.Lenovo’s Miix 630 is one of the first Qualcomm Snapdragon-based Windows devices.myserver/myosvc
- The name of the Oracle server:Oracle port number/Oracle service name or IDIn this example, Oracle is installed on myserver, is listening on port 60000, and myoservice is the Oracle service name.myserver:60000/myoservice
- The URL of the Oracle server The URL for the same instance shown in the last example would be://myserver:60000/myoservice
- The name of the Oracle server (You can use this if the Oracle listener on the server is configured to point to a default instance.)
- The IP address of the Oracle server/Oracle service name or IDFor example, if the address of the server is 10:10:10:10, and the Oracle service name is orasvc, type 10:10:10:10/orasvc.For IPV6 addresses, place brackets around the address, for example, [4000:ab5:0:0:f666:d191:77f5:e2bd]/orasvc.
- The IP address of the Oracle server:Oracle port number/Oracle service name or IDIn this example, the IP address is 10:20:30:40, port is 59999, and Oracle service is myomy1: 10:20:30:40:59999/myomy1.An IPV6 address for the same port and service would look like the following: [6543:ef4:0:1:f587:l249:12f9:a3cd]:59999/myomy110:20:30:40:59999/myomy1.
Be sure your Oracle instance is configured to allow Easy Connect. If you have the full Oracle client installed but want to use Easy Connect syntax to connect, be sure the sqlnet.ora file on the client is configured to allow the use of Easy Connect and the Oracle server is configured to allow Easy Connect syntax. Also note that if your Oracle instance is not listening on the default Oracle port number, you must use connection syntax that includes the port number. - The name of the Oracle server/Oracle service name or ID
- Choose the type of authentication to use when connecting to the database: Database authentication or Operating system authentication.
- If you choose Operating system authentication, you do not need to type a user name and password—the connection is made using the login name and password used to log in to the operating system. If the login used for the operating system is not a valid database login, the connection fails. Be aware that you cannot use operating system authentication if you are using the Oracle instant client.
Note:
When you use operating system authentication in Oracle, the operating system login is prefixed with an os_authent_prefix string (by default, OPS$) and stored in the USERNAME table. The maximum number of characters allowed for the user name when connecting to the geodatabase is 30. In these specific cases, ArcGIS will place quotes around your user name to pass it to the database. Those quotes count toward the 30-character total. - If you choose Database authentication, you must provide a valid database user name and password in the User name and Password text boxes, respectively. User names can be a maximum of 30 characters.Uncheck Save user name and password if you prefer not to save your login information as part of the connection; doing this can help maintain the security of the database. However, if you do this, you will be prompted to provide a user name and password every time you connect. Also note that Save user name and password must be checked for connection files that provide ArcGIS services with access to the database or geodatabase, or if you want to use the Catalog search to locate data accessed through this connection file.
In the following example, a connection is made to the oracl/dbdata Oracle instance using database authentication. - If you choose Operating system authentication, you do not need to type a user name and password—the connection is made using the login name and password used to log in to the operating system. If the login used for the operating system is not a valid database login, the connection fails. Be aware that you cannot use operating system authentication if you are using the Oracle instant client.
- Click OK to connect.
A file is created in <computer_name>Users<user_name>AppDataRoamingESRIDesktop<release#>ArcCatalog. If you encounter any problems with the connection, check the sdedc_Oracle.log file in the %TEMP% directory for extended error messages.
You can move the connection to another location, but be sure users and applications that need to make a connection have read access to the directory where you place the connection file.
If you use the data from this connection as the source for a service, such as a geoprocessing or geocoding service, you may need to place the connection file in a shared location on your network. See Preparing resources for publishing as services for more information about sharing a connection file.
Connect to a user-schema geodatabase or different version
You are connected to the DEFAULT version of the master sde geodatabase when you initially connect using the Database Connection dialog box. If you want to connect to a user-schema geodatabase, a transactional version other than DEFAULT, or an historical version, use the Geodatabase Connection Properties dialog box. Note that user-schema geodatabases are listed as transactional versions in this dialog box. For more information, see Connect to a specific geodatabase version.
Connect from ArcGIS for Server
If Oracle and ArcGIS for Server are running on separate servers, install a 64-bit Oracle client on the ArcGIS for Server computer.
Oracle Client 10.1 Download Free
If ArcGIS for Server is installed on a Linux server, edit the init_user_param.sh script to include information about the Oracle client and instance and restart ArcGIS for Server.
If you want the services you publish to ArcGIS Server to use the data in your database or geodatabase in Oracle, you must register the database with ArcGIS Server.
Install the Oracle client
If ArcGIS for Server and Oracle are installed on different servers, you must install the Oracle client application on the ArcGIS for Server machine. Be sure you install a release of the Oracle client application that is compatible with the release of the database to which you want to connect.
You can obtain the Oracle Instant, Runtime, or Administrator Client from Oracle, and install it on the client computer, following the directions in your Oracle documentation.
Set the PATH environment variable (Windows only)
Set the PATH environment variable on the ArcGIS for Server Windows server to the location of the Oracle Client installation. See Microsoft Windows documentation if you need instructions for setting the PATH environment variable.
Note:
Oracle Client Downloads
If both ArcGIS for Server and ArcGIS for Desktop are installed on the same Windows computer, set the PATH variable to read the 64-bit client before the 32-bit client. For example, if your 32-bit Oracle Instant Client is installed to c:Program Files (x86)Oracle and your 64-bit Oracle Instant Client is installed to c:Program FilesOracle, add the following to the beginning of your PATH variable value on Windows: C:Program FilesOracle;C:Program Files (x86)Oracle;.
If ArcGIS Server was running before you configured the Oracle client and set the PATH variable, you must restart ArcGIS Server. You can restart ArcGIS Server from the Windows Services interface.
Alter the init_user_param.sh script (Linux only)
Once you have installed the database client files, alter the init_user_param.sh script to reference them. You can access this script by browsing to the <ArcGIS Server installation directory>/arcgis/server/usr directory.
Note:
Oracle Client Software Download
If your user profile references the Oracle client, ArcGIS Server should still connect to the database. However, if the client information differs between the user profile and init_user_param.sh, you may experience problems when attempting to connect to the database. To alleviate connection issues, remove the reference information from your user profile and re-reference your database client libraries using the following steps.
- Ensure that the ArcGIS Server installation owner has at least read and execute permissions on the database client libraries.
- Open the init_user_param.sh script in a text editor.
- Remove the comment marks (#) from the lines beginning with export.If you installed the Oracle Administrator, Developer, or Runtime client, remove comment marks from all the Oracle lines beginning with export.If you are using the Oracle database Instant client libraries, you only need to uncomment and set the $LD_LIBRARY_PATH, for example
- Set values for the export variables.
- For Oracle Administrator, Developer, or Runtime clients, uncomment and set the following variables using information specific to your implementation:
- The <Oracle_Installdir> is the path to and name of the top-level directory where the Oracle client is installed.
- This is the path to the Oracle client library files. Set ORACLE_HOME to the directory where these reside. By default, the directory name is client_1, but your installation my have a different directory name.
- If you will be using an Oracle system ID (SID) to connect, set ORACLE_SID= to the Oracle system ID of your database. If you will be using an Easy Connect string to connect, comment out this line.
- Set TNS_ADMIN= to the location of your Oracle client TNS administration files. If you will be using an Easy Connect string to connect, you do not need to set this value and must comment out this line.
- For Oracle Instant clients, uncomment and set only the LD_LIBRARY_PATH variable, replacing <Location_to_instantclient> with the path to and directory name where the Oracle Instant client files are located.
- If ArcGIS for Server and Oracle are installed on the same server, uncomment and set the following variables:
- The <Oracle_Installdir> is the path to and name of the top-level directory where Oracle is installed.
- This is the path to the Oracle library files. Set ORACLE_HOME to the directory where these reside. By default, the directory name is db_<n>, but your installation my have a different directory name.
- If you will be using an Oracle system ID (SID) to connect, set ORACLE_SID= to the Oracle system ID of your database. If you will be using an Easy Connect string to connect, comment out this line.
- Set TNS_ADMIN= to the location of your Oracle client TNS administration files. If you will be using an Easy Connect string to connect, you do not need to set this value and must comment out this line.
- For Oracle Administrator, Developer, or Runtime clients, uncomment and set the following variables using information specific to your implementation:
- Save and close the script.
- Restart each GIS server in your ArcGIS Server deployment by running the startserver.sh script.
Register the database
Oracle Client 10.2 Download
If you want your web services to use the data in your Oracle database or a geodatabase in Oracle, register it with ArcGIS Server. See About registering your data with the server for information on registration options and links to topics with instructions for registering your database.