What's the best way to determine which version of Oracle client I'm running? Issue #1: Multiple Oracle clients are installed. A very common issue I see in my environment is that I see both workstations and (app) servers with multiple Oracle clients, sometimes as many as four, and possibly with different versions and architectures. If you are relying on the PATH and running a utility like SQLPLUS or TNSPING you'll have one of two unacceptable results: either your PATH successfully resolves the executable and you get ONE version resultor, the PATH didn't resolve the executable, and you get no results. Either way, you are blind to possibly multiple client installations. Issue #2: Instant Client doesn't have TNSPING, and sometimes doesn't include SQL*Plus. If a computer has the Oracle Instant Client (not the full client), then TNSPING is not included, and SQLPLUS is an optional- addon. ODAC xcopy downloads and ODAC downloads without Oracle Developer Tools for Visual Studio. The subject says it all: What is the best way to determine the exact version of the oracle client I'm running? Our clients are all running Windows. I found one. So can't rely on those tools being there. Furthermore, the Instant Client is sometimes installed as an unzip- and- go solution, so there's no Oracle Inventory and nothing in HKLM.
Issue #3: Client was installed using "Custom", and ODBC, OLEDB, ODP. Net, and JDBC were not installed. Obvious case, there will be no ODBC or JDBC readme's to scrape version info from. Solution: One thing that the Instant client and the full client have in common is a DLL file called oraclient. So let's traverse the hard disk to find them and extract their version info. Power. Shell is amazing at this and can do it in one line, reminds me of home sweet Unix. So you could do this programatically or even remotely.Here's the one- liner (sorry about the right scroll, but that's the nature of one- liners, eh?).Supposing you're already in a Power.Shell: gci C: \,D: \ - recurse - filter 'oraclient*.Error. Action Silently.Continue | %{ $_. Acronis True Image Home V 16 2013 Set Up Keyboard on this page. Version. Info } | ft - Property File. Version, File. Name - Auto. Size. And if you're not in Power. Shell, i. e. you're simply in a CMD shell, then no problem, just call powershell " .. C: \,D: \ - recurse - filter 'oraclient*. Error. Action Silently. Continue | %{ $_. Version. Info } | ft - Property File. Version, File. Name - Auto. Size". Example Outputs. Here's some outputs from some of my systems. This bad citizen has 3 Oracle 1. You can see that some of them are 3. File. Version File. Name. - -- -- -- -- -- - -- -- -- -. Production C: \No. Sync\app\oracle\product\1. Production C: \oracle\product\1. Production C: \oracle. Another system, this one has 1. D: \File. Version File. Name. - -- -- -- -- -- - -- -- -- -. Production D: \oracle\product\1. BIN\oraclient. 10. Caveats/Issues. This obviously requires Power. Shell, which is standard in Windows 7+ and Server 2. R2+. If you have XP (which you shouldn't any more) you can easily install Power. Shell. I haven't tried this on 8i/9i or 1. If you are running 8i/9i, then there's a good chance you are on an old OS as well and don't have Power. Shell and Heaven help you. It should work with 1. I see there is such a file oraclient. I just don't have a Windows 1. Offline Installer Apps - Offline Installer Apps, Install all your apps offline, guide for Offline Installer. Visual Studio Offline Installer For Windows PCVisual Studio Offline Installer is a Microsoft which is an integrated development environment from Microsoft. Download Visual Studio Offline Installer. It is used to develop computer programs for Microsoft Windows, like websites, web apps, web services and mobile apps. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Windows Store and Microsoft Silverlight. It can produce both native codes and managed code. Visual Studio Offline Installer includes a code editor supporting Intelli. Sense the code completion component as well..
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |