IBM Support

Oracle client and networking components were not found, when configuring an Oracle based RequisitePro project

Troubleshooting


Problem

This technote identifies a possible cause and resolution to Oracle error such as "Oracle client and networking components were not found", and "Driver's SQLAllocHandle on SQL_HANDLE_ENV Failed", which might occur when configuring a Oracle based IBM® Rational® RequisitePro® Project.

Cause

The full error message is as follows:

The Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3(or greater) client software installation.
You will be unable to use this driver until these components have been installed


ODBC Error: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on
SQL_HANDLE_ENV Failed - Unable to connect to the database.

A common cause for these errors is that the Oracle \Ora92\bin directory is not set in the Microsoft® Windows® PATH environment variable.

Environment

This can been seen in a Windows 32 bit enviornment and 64 bit windows environments

Resolving The Problem

To resolve this issue add the full path to <Full Path>\Ora92\bin directory into the Windows PATH variable.

By default the full path to the Ora92\bin directory is C:\Oracle\Ora92\bin



[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database: Oracle","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2002.05.00;2002.05.20;2003.06.00;2003.06.01;2003.06.10;2003.06.12;2003.06.13;2003.06.14;2003.06.15;2003.06.16;7.0;7.0.0.1;7.0.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21218792

Page Feedback