Cannot Locate A 64-bit Oracle Client Library Mac

Posted on by admin

Troubleshooting


Problem

Subject: 'LD: CAN NOT FIND OR OPEN LIBRARY FILE: -LM' ERROR ON AIX Doc ID: Note:1015781.6 Problem Description: When linking the listener executable on systems running AIX, you receive the following error: ld:0706-006 can not find or open library file: -l m ld: open file or dir path does not exist Problem Explanation:. Your search did not match any results. We suggest you try the following to help find what you’re looking for: Check the spelling of your keyword search. Use synonyms for the keyword you typed, for example, try “application” instead of “software.” Try one of the popular searches shown below. Start a new search. Trending Questions. For installing Instant Client from Oracle Universal Installer, invoke the Oracle Universal Installer, select the Instant Client option and then install the Instant Client shared libraries to an empty directory, such as instantclient193, for Oracle Database release 19c, version 19.3.

Cannot Locate A 64-bit Oracle Client Library Mac Os

Testing an Oracle data source defined within IBM Cognos Server Administration results in the following error for the Dynamic Query Mode(DQM) connection test:

Symptom

  • ORACLE sqlplus header output shows 64-bit designation. Compare this with db2level output. If DB2 is 64-bit, then ORACLE client should also be 64-bit. C) On Windows, the system environment Path variable does not include the directory that contains the libraries of the data source client.
  • If you have a 64-bit OS you are running the probe on. Then the Oracle client must be 64-bit as well. Also, you will need to double check the items below after logging in with the oracle user (you must be logged in as the oracle user instead of root) 1.

JDBC/OCI connection failed with error: XQE-GEN-0002 An unexpected exception occurred: ocijdbc11 Not found in java.library.path.

Cause

This error occurs on any 64-bit IBM Cognos 10 install that uses both the 32-bit Compatible Query Mode(CQM) and the 64 bit DQM against an Oracle data source, where the DQM data source connection type is set to TNS Names Alias. The cause of the problem is that the TNS Names Alias DQM connection type setting requires the 64 bit Oracle client libraries whereas CQM requires the 32 bit Oracle client libraries. The OS library loader will automatically pick up the first one defined on the PATH statement. .

Resolving The Problem

/key-generator-for-keil-uvision4.html. The following steps resolve the error and allow both CQM and DQM to connect to the Oracle data source. These steps need to be performed on every IBM Cognos Application Server component within a single Environment that performs Oracle data access.

Locate the cognos_install/configuration/xqe.config.xml file and make a back up copy.

Open the xqe.config.xml file using a text editor.

Add the envar tags below for the appropriate operating system.

For AIX, search for os name='AIX'. then add a new line:


<envvar name='LIBPATH' value='your LIBPATH which include the Oracle 64 bit libraries'/>
For Solaris, search for os name='SunOS', then add a new line:
<envvar name='LD_LIBRARY_PATH' value='your LD_LIBRARY_PATH which include the Oracle 64bit libraries'/>
For Linux, search tag <environment override='true'> , then add these lines:
<os name='Linux'>
<envvar name='LD_LIBRARY_PATH' value
='your LD_LIBRARY_PATH which include the Oracle 64bit libraries'/>
</os>
For Windows, you will need to add an entry:
<os name='Windows'>
<envvar name='PATH' value='Your PATH variable which includes the path to the Oracle 64-bit libraries.'/>Cannot locate a 64-bit oracle client library mac download
</os>
Please note, that the ocijdbc12 file exists in the Oracle client bin directory.

Cannot Locate A 64-bit Oracle Client Library Macos

Save the changes and close the file.
Locate the databaseDriverLocations.properties.sample file located within the cognos_installv5dataserver folder.
Rename this file to databaseDriverLocations.properties.
Open this file using a text editor.

Cannot Locate A 64-bit Oracle Client Library Macro

Update the databaseJNIPATH to point to the Oracle 64 bit libraries.
Ex) databaseJNIPath=/home/oracle11/app/oracle/product/11.2.0/dbhome_1/lib
On Windows, you will need to ensure that the backslash ' is escaped by adding a second backslash '.
For example:
C:oracleproductclient 12.064-bitlib;C:oracleproductclient 12.0 64-bitbin
Save the changes and close the file.

Dpi-1047 Cannot Locate A 64-bit Oracle Client Library Mac


Cannot Locate A 64-bit Oracle Client Library Mac Osx

Stop and re-start the IBM Cognos Service.
.

Cannot Locate A 64-bit Oracle Client Library Mac Download

[{'Product':{'code':'SSEP7J','label':'Cognos Business Intelligence'},'Business Unit':{'code':'BU053','label':'Cloud & Data Platform'},'Component':'Cognos Connection','Platform':[{'code':'PF002','label':'AIX'},{'code':'PF010','label':'HP-UX'},{'code':'PF016','label':'Linux'},{'code':'PF027','label':'Solaris'}],'Version':'10.2.2;10.2.1;10.2;10.1.1','Edition':'All Editions','Line of Business':{'code':'LOB10','label':'Data and AI'}}]

Document Information

Modified date:
15 June 2018