![]() Keep in mind that Apple hardware product serial numbers may sometimes contain the number "0" (zero), but never the letter "O". You can find your serial number in several places. You can use command prompt or you can navigate/explore to the oracle home location and then cd to bin directory to lauch sqlplus which will give you the client version information.Learn how to find the serial number of your iPod nano, iPod shuffle, or iPod touch. Registry location variable in windows is INST_LOC Start > Run > regedit > HKLM > Software > OracleĬheck the Inst_loc entry value which will be the software installed location. In the above example, the version of Oracle client is 11.2.0.1 In Windows Once you know the install location export ORACLE_HOME=full path to install locationĮxport ORACLE_HOME=/export/oracle/product/11.2.0.2Ī simple "sqlplus" will give you the version of the client installed. Here look for a file inventory.xml > cat inventory.xml Inventory_loc=/export/oracle/oraInventory **-> Inventory location** If you don’t know the location or version of installed Oracle product, you can find it from the inventory which is usually recorded in /etc/oraInst.loc > cat /etc/oraInst.loc I just don't have a Windows 12c client to play with yet. It should work with 12c, since I see there is such a file oraclient12.dll that gets installed. If you are running 8i/9i, then there's a good chance you are on an old OS as well and don't have PowerShell and Heaven help you. If you have XP (which you shouldn't any more) you can easily install PowerShell. This obviously requires PowerShell, which is standard in Windows 7+ and Server 2008 R2+. You can see that some of them are 32-bit and others are 64-bit: FileVersion FileNameġ1.2.0.3.0 Production C:\NoSync\app\oracle\product\11.2\client_1\bin\oraclient.ġ1.2.0.3.0 Production C:\oracle\product\11.2.0\client_1\bin\oraclient11.dllġ1.2.0.3.0 Production C:\oracle64\product\11.2.0\client_1\bin\oraclient11.dllĪnother system, this one has 10g client on the D:\ FileVersion FileNameġ0.2.0.4.0 Production D:\oracle\product\10.2\BIN\oraclient10.dll This bad citizen has 3 Oracle 11.2.0.3 clients. Here's some outputs from some of my systems. Supposing you're already in a PowerShell: gci C:\,D:\ -recurse -filter 'oraclient*.dll' -ErrorAction Silentl圜ontinue | % | ft -Property FileVersion, FileName -AutoSize" Here's the one-liner (sorry about the right scroll, but that's the nature of one-liners, eh?). So you could do this programatically or even remotely. PowerShell is amazing at this and can do it in one line, reminds me of home sweet Unix. So let's traverse the hard disk to find them and extract their version info. One thing that the Instant client and the full client have in common is a DLL file called oraclient10.dll, oraclient11.dll, generally: oraclient*.dll. Obvious case, there will be no ODBC or JDBC readme's to scrape version info from. Issue #3: Client was installed using "Custom", and ODBC, OLEDB, ODP.Net, and JDBC were not installed. Furthermore, the Instant Client is sometimes installed as an unzip-and-go solution, so there's no Oracle Inventory and nothing in HKLM. So can't rely on those tools being there. If a computer has the Oracle Instant Client (not the full client), then TNSPING is not included, and SQLPLUS is an optional-addon. Issue #2: Instant Client doesn't have TNSPING, and sometimes doesn't include SQL*Plus. or, the PATH didn't resolve the executable, and you get no results.Įither way, you are blind to possibly multiple client installations.either your PATH successfully resolves the executable and you get ONE version result. ![]() If you are relying on the PATH and running a utility like SQLPLUS or TNSPING you'll have one of two unacceptable results: Issue #1: Multiple Oracle clients are installed.Ī 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |