search cancel

Check if your Oracle client software version is 32-bit or 64-bit


Article ID: 34674


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM) Unified Infrastructure Management for Mainframe CA Unified Infrastructure Management SaaS (Nimsoft / UIM)


Sometimes clients run into compatibility issues with Oracle clients and UIM. Usually, this has to do with the bit-level of the OS and the bit-level of the Oracle client not being the same/matching.

Below are instructions to validate the bit-level of the Oracle client you are running.


Component: UIMORC

- oracle probe


How to check if your Oracle CLIENT software is 32-bit or 64-bit

On Windows:

Option 1:

If you're logged into SQL Plus, the banner will tell you 64-bit if the 64-bit version is installed. If it does not specify 64-bit, then it is 32-bit (even though it does not explicitly say so).

Open a Windows command (cmd) prompt and run:

sqlplus / as sysdba

If nothing is found on your the machine, then the client is not installed.


Rt-Click on Computer ---> Properties --> Advanced system settings -->Advanced Tab ---> Environment Variables --> then check Path Option in the System variables to see Oracle client HOME dir.

Option 2:

Bring up a command line prompt.
cd into the Oracle client directory. In the Oracle client directory, there should be a bin folder. In the bin folder, there should be an executable called tnsping.exe

If you run this utility without any command line options it will tell you what version is installed. The bit level shown is the bit level of the Oracle client. This will display client information and should note 64-bit or 32-bit.

Option 3:

If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib are existing then it is 64-bit. If there is only an ORACLE_HOME/lib directory then it is a 32-bit client.

*Note: In newer versions of the client, the library is not included and this directory may not exist.

Option 4:

a. Open the Registry by selecting Start | Run and entering REGEDIT

b. Go to HKEY_LOCAL_MACHINE/Software

c. Check for an Oracle node. Verify the ORACLE_HOME variable.
-- If found this indicates that the client specified here is 64bit. Note the path of the ORACLE_HOME variable and the name.

d. Further, check to see if there's a WOW6432Node node. If so, does that have an Oracle node within it? Verify if there is also an ORACLE_HOME variable also.

-- If found, this indicates that the client specified here is 32-bit.? Note the path of the ORACLE_HOME variable and the name.

When accessing the Oracle client, make sure you're accessing the correct client based off the HOME name and the PATH.

On UNIX/Linux:

Option 1:

If you see the "64bit" string in V$VERSION it means Oracle 64-bit is running.

SQL> select * from v$version;

Oracle Database 10g Release - 64bit Production
PL/SQL Release - Production
CORE Production
TNS for Linux: Version - Production
NLSRTL Version - Production

If you have NO "64bit" string in V$VERSION it means Oracle 32-bit is running.

Option 2:


Run the command:

file sqlplus


file sqlldr


file expdp

Note: As the Oracle client should always match the Oracle database server bit level if it says 32-bit and you are running a 64-bit OS you can expect problems.