Fbomg

The Oracle Database Client software is available on Oracle Technology Network website. This chapter describes the following sections:

Getting your dev environment setup to connect to an Oracle DB can sometimes be a real pain. This tip covers setting up the client, and installing the ruby oci8 gem. The default is the ‘Instant Client’ which will allow for Oracle connections to one Oracle database at a time. If your users need the Toad Data Point ‘cross connection query’ feature (most will) DO NOT install the ‘Instant client’.

3.1Downloading and Installing the Oracle Database Client Software

Download and install Oracle Database Client 11g Release 2 by completing the following steps:

1. Download the Instant Client for Mac OS X (Intel) (32-bit and 64-bit) package from the Instant Client Downloads page on Oracle Technology Network at

2. Create a directory on your computer, for example, instantclient. Choose a directory to install the Oracle Instant Client and unzip the downloaded zip file in that directory. The unzipped file creates the instantclient_11_2 directory.

3. Set the DYLD_LIBRARY_PATH and the NLS_LANG environment variables to the full path of the instantclient_11_2 directory. For example, if you unzipped the Instant Client zip file in the /bin/oracle directory, then set the DYLD_LIBRARY_PATH environment variable to /bin/oracle/instantclient_11_2.

   Refer to 'Instant Client Light Requirements' for information about setting the NLS_LANG environment variable to the required character set.

   This completes the installation of Oracle Database Client. To connect to the Oracle Database server, run your client from the Oracle Database Instant Client environment.

3.2Removing the Oracle Database Client Software

To remove the Oracle Database Client software, delete the instantclient_11_2 directory.

I have been trying casually for a couple of weeks now to set up the oracle client so that I can use cx_oracle with Python programs. However, I can't for the life of me set up the client that cx_oracle requires.

I set my DYLD_LIBRARY_PATH with 'export DYLD_LIBRARY_PATH=/Applications/oracle/instantclient_11_2' where I have the oracle client file.

When I run 'pip install cx_oracle', I get the following error message:

e.o -DBUILD_VERSION=5.2.1 cx_Oracle.c:10:10: fatal error: 'oci.h' file not found

1 error generated. error: command 'gcc' failed with exit status 1

Failed building wheel for cx-oracle Failed to build cx-oracle

Oracle 11g Download For Windows

Any help would be greatly appreciated.

Oracle Client For Mac

Thank you.

Oracle 11g For Mac

Edit: I just wanted to thank everyone again for their thoughtful responses. This subreddit has been particularly helpful.

Instant Client For Oracle 11g Mac Os X