2.how to find the oraclehomename for the exisiting installation of oracle client/server. I am trying to upgrade client from one version to another, we have some issue on server end to get the GUI working. In the response file, its asking for oraclehomename. 3.Can patch sets be installed in non-interactive mode Thanks for your considerations. Do not install SQL Developer into any existing ORACLEHOME. You will not be able to uninstall it using Oracle Universal Installer. Also, do not install SQL Developer into an existing sqldeveloperfolder or directory. Connect to an Oracle database. After you install the matching Oracle client driver, you can connect to an Oracle database. To make the connection, take the following steps: From the Home tab, select Get Data. From the Get Data window that appears, select More (if necessary), select Database Oracle database, and then select Connect. I learnt that pl-sql developer doesn't work with oracle 64-bit client so now i have both 32-bit and 64-bit clients installed on my machine and my ORACLEHOME variable points to 64-bit client. I am not able to start pl/sql developer even i specify the 32-bit client in Tools-Preferences of pl-sql developer version 8.0.4. Ensure that the path to your Oracle client is listed here (the actual folder that contains the dlls above, e.g. C: oracle instantclient121). If SQL developer is open when you do this, close it and reopen 2. In SQL Developer, go to Preferences Database Advanced and select Configure under the client section.
If your application uses Oracle database, you will need to install the appropriate version of Oracle Client in your local machine. As this software keeps being updated, you may find yourself trying to uninstall old versions from your system after a while. The question is that how to find which versions of Oracle Client you have in Windows?
Finding out which Oracle Client you installed it’s not straightforward. You can check PATH variables or run some commands in SQLPLUS or TNSPING. Another approach is using OPatch Utility. In this post, I will talk about a much easier way to Oracle Client versions.
Oracle Client versions
Simply run the query below in the Command Prompt. It will call PowerShell first and search for oraclient*.dll files (Asterisk is used to represent the number such as 10, 11 or 12). Once the query is executed, a nicely formatted table will be displayed with the versions and their paths.
Make sure to add (or remove) hard disk drives if your system has more or less than 2 drives (C: and D:). In the command, only C: and D: drives are searched.
Alternative Way
You can use the query below in SQL Developer to list the versions of the client libraries used. Please note that this query may list the version which is used by SQL Developer only.
Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key Windows 10
Another approach is that querying v$version variable: select * from v$version