How to know installed Oracle Client is 32 bit or 64 bit

Question

OS  Windows 2008 Server R2  Oracle Client  11 2  Many Thanks

User · Answer

For the Oracle 12 1 windows client  looking at the output from the TNSPING command seems to work   With 32 bit installed on 64 bit OS      C  tnsping      TNS Ping Utility for 32-bit Windows  Version 12 1 0 2 0 - Production   on 02-FEB-2 016 15 44 37      Copyright  c  1997  2014  Oracle   All rights reserved    With 64 bit installed on 64 bit OS       D  tnsping       TNS Ping Utility for 64-bit Windows  Version 12 1 0 1 0 - Production   on 02-FEB-2 016 16 00 23      Copyright  c  1997  2013  Oracle   All rights reserved

User · Answer

On 64-bit system   32-bit Driver  C  Windows SysWOW64 odbcad32 exe  64-bit Driver  C  Windows System32 odbcad32 exe  Go to Drivers Tab Version is shown there as well

User · Answer

For Unix grep  quot ARCHITECTURE quot   ORACLE HOME inventory ContentsXML oraclehomeproperties xml  And the output is   lt PROPERTY NAME  quot ARCHITECTURE quot  VAL  quot 64 quot   gt    For Windows findstr  quot ARCHITECTURE quot   ORACLE HOME  inventory ContentsXML oraclehomeproperties xml  And the output can be   lt PROPERTY NAME  quot ARCHITECTURE quot  VAL  quot 64 quot   gt

User · Answer

None of the links above about lib and lib32 folder worked for me with Oracle Client 11 2 0 But I found this on the OTN community      As far as inspecting a client install to try to tell if it s 32 bit or   64 bit  you can check the registry  a 32 bit home will be located in   HKLM Software WOW6432Node Oracle  whereas a 64 bit home will be in   HKLM Software Oracle

User · Answer

In Linux   1  find where is sqlplus located    oracle LINUX db 1    which sqlplus   app oracle product 11 2 0 db 1 bin sqlplus   2  Determine the file type    oracle LINUX db 1    file  app oracle product 11 2 0 db 1 bin sqlplus   app oracle product 11 2 0 db 1 bin sqlplus  ELF 64-bit LSB executable  x86-64  version 1  SYSV   dynamically linked  uses shared libs   For GNU Linux 2 6 18  not stripped

User · Answer

Go to  ORACLE HOME  inventory ContentsXML folder and open  comps xml file   Look for  lt DEP LIST gt  on  second screen  If following lines have  PLAT  NT AMD64  then this Oracle Home is 64 bit   PLAT  NT X86  then - 32 bit   You may have both 32-bit and 64-bit Oracle Homes installed

User · Answer

A simple way to find this out in Windows is to run SQLPlus from your Oracle homes s bin directory and then check Task Manager  If it is a 32-bit version of SQLPlus  you ll see a process on the Processes tab that looks like this   sqlplus exe  32   If it is 64-bit  the process will look like this   sqlplus exe

User · Answer

One thing that was super easy and worked well for me was doing a TNSPing from a cmd prompt   TNS Ping Utility for 32-bit Windows  Version 11 2 0 3 0 - Production on 13-MAR-2015 16 35 32

User · Answer

The following  taken from here  was not mentioned here      If the Oracle Client is 32 bit  it will contain a  lib  folder  but if it is a 64 bit Oracle Client it will have both  lib  and  lib32  folders       Also  starting in Oracle 11 2 0 1  the client version for 64-bit and the Oracle client for 32-bit are shipped separately  and there is an  ORACLE HOME lib64 directory        ORACLE HOME lib          32 bit    ORACLE HOME lib64      64 bit      Or       ORACLE HOME lib          64 bit    ORACLE HOME lib32      32 bit

[oracle] How to know installed Oracle Client is 32 bit or 64 bit?

Examples related to oracle

Examples related to 64-bit

Examples related to oracleclient