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.
- oracle probe
How to check if your Oracle CLIENT software is 32-bit or 64-bit
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.
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.
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.
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.
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 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
If you have NO "64bit" string in V$VERSION it means Oracle 32-bit is running.
Run the command:
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.