Cannot Locate A 64-bit Oracle Client Library Mac

| Posted on by

Needless to say, you would have restarted the BizTalk host instances after the modification to the config files? Are you running the adapter in a 32-bit host or 64-bit host and which versions of the Oracle Runtime is running. On various deployments I have different degrees of success with the 32 bit and 64 bit versions. It is installed successfuly but when i typed sqlplus in terminal to login into oracle. It show dyld library loaded. Can I install Oracle client on Mac os X version.

  1. Cannot Locate A 64-bit Oracle Client Library Macos
  2. Cannot Locate A 64-bit Oracle Client Library Macro
  3. Dpi-1047 Cannot Locate A 64-bit Oracle Client Library Mac
  4. Cannot Locate A 64-bit Oracle Client Library Mac Os
  5. Cannot Locate A 64-bit Oracle Client Library Mac Download

sqlplus or sqlplus64 tools are used to connect and manage Oracle Databases. sqlplus64 is 64 bit version of the sqlplus. After installating these tools successfully when we try to run sqlplus command we may get an shared object file or library error.

sqlplus command shared library error full definition is like below. Keep in mind that for 64 bit version it will be sqlplus64

We can understand that shared library libsqlplus.so can not be found in the defined library path. Library path is stored in bash environment variable LD_LIBRARY_PATH . So first we will check this environment variable.

We can see that there is no path in LD_LIBRARY_PATH. So there will be no library to load.

In order to load sqlplus library we will add libsqlplus.so path to the LD_LIBRARY_PATH. By default libsqlplus.so will stored in /usr/lib/oracle/18.3/client64/lib/ where version 18.3 will be set according to your version. We will use export command to add this path to the LD_LIBRARY_PATH.

If we can not find libsqlplus.so in the default paths we may need to search for. We can use locate command in order to find the path of the libsqlplus.so.

Oracle

First we will update the file database with the updatedb command.

Cannot Locate A 64-bit Oracle Client Library Macos

And then we will search for the library.

Now everything seems OK. We can run sqlplus command without problem like below.

Cannot Locate A 64-bit Oracle Client Library Macro

If you are working on Oracle database either as developer or DBA, you need a good front-end to manage your database.

In the old days, one of the popular option was Toad.

But, now, there is even a better and robust option; SQL Developer.

SQL Developer is an oracle product. It is free.

It is a very good IDE for developers who write lot of PL/SQL code.

It is also an excellent DBA tool to manage your database. You can also uset it to run reports, create data model, and also to migrate database.
It is certified for all Windows, Applet MAC, Linux Operating Systems against certain JDK versions.

Install Option#1: SQL Developer as part of Oracle Client Install

SQL Developer comes as part of the Oracle Database Client installation when Administrator mode has been chosen.

For example, oracle 11g client 11.2.0.1.0 installer installs SQL Developer version 1.5.5 when Administrator mode is chosen as shown below.

Oracle Instant Client can be downloaded from here.

This SQL Developer shortcut is getting created under Application Development in the Oracle – OraClient11g_home1 shortcut.

The SQL Developer client looks for JDK 1.8 and above to launch it. If you don’t have the correct JDK version, it will download and install it.

Install Option#2: Standalone SQL Developer Install

To overcome this fat installation of SQL developer, go for the stand-alone SQL Developer version. This SQL Developer standalone version can be downloaded from here.

After the download, unzip the file into a directory. Then Click the sqldeveloper.exe to get started.

While launching, it copies the data from the existing SQL Developer version if any.

Windows 64-bit installer has been bundled with JDK 1.8 but other installers require JDK 1.8 to be installed.

Setup TNSNAMES for SQL Developer

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

Point the Oracle Client Home to SQL Developer by setting appropriate tnsnames directory as shown below:

Tools menu -> Preferences -> Database -> Advanced -> TNSNAMES Directory -> Click the browser and select the path somethink like this: C:xyzproduct11.2.0client_1networkadmin

After launching SQL Developer, it will now know where to get the list of TNS entries for db connection. From the list, select the database where you want to connect it. Once connected, it will list all the db objects for the connected schema as shown below.

SQL Developer Features

This latest SQL Developer has powerful features for developers and DBAs which are listed here. As you see from the following view menu, there are several power features available for developers.

Any existing SQL Developer connection can be added to the DBA panel, available under the View menu. This allows users with administrative privileges to access features across the following areas:

  1. Database Confiugration – Init parameters, Usuage Reports etc
  2. Data pump – Wizards to data export/import etc
  3. RMAN – Backup jobs, Image Copies etc
  4. Resource Manager – Plan, Settings, statistics etc
  5. Security – Users, profiles, roles etc
  6. Storage – Archive Logs, Control Files, Data files etc
Dpi-1047 cannot locate a 64-bit oracle client library mac

Refer to this: How to backup Oracle DB using RMAN, and restore oracle using RMAN.

SQL Developer Extensions

SQL developer leverages the JDeveloper IDE. This gives developers the option to write extension.

JDeveloper Database Navigator emulates the same UI similar to SQL Developer after performing the below change in SQL Navigator:

Tools menu -> Preferences -> Database -> User Defined Extension -> Click Add Row

Select Type as Navigator and Location of the XML which has the queries and nodes are configured.

Cannot Locate A 64-bit Oracle Client Library Mac Os

Then register this same XML document as a user defined extension to the SQL Developer component in JDeveloper:

First, restart JDeveloper to have the registration take effect. Next, open the database navigator for a database connection to see the new extension in action

> Add your comment

If you enjoyed this article, you might also like..



Next post: How to Deploy Node.js Script on Linux Using Upstart and Monit

Cannot Locate A 64-bit Oracle Client Library Mac Download

Previous post: How to Disable Same Origin Policy on Chrome and IE browser