First off, Mac 10.7 is currently incompatible with the 64-bit version of the Oracle instant client. Credit goes to the Only 4 Left blog for pointing me in the right direction.

Download the Asana mobile app for your iPhone, iPad, or Android device to plan your day, share ideas, and get team updates on the go. Google Drive. All apps, Made by Asana, Google, File Sharing. The Google Drive file chooser is built into the Asana task pane so you can easily attach My Drive files directly to tasks. Asana client for mac.

Active2 years, 7 months ago

I am looking for a way to run the Oracle database client on a Mac running OS X. The server will be on a remote host.

How to install Oracle Instant Client Version 12.1.0.2 (64-bit) on a Mac (OS X 10.11.5) I have downloaded version 12.1.0.2 (64-bit) version and unzipped the file.
Download oracle client for free. Development Tools downloads - Oracle Client by Oracle and many more programs are available for instant and free download.
Click to email this to a friend (Opens in new window) Click to share on Facebook (Opens in new window) Click to share on LinkedIn (Opens in new window).

Oracle Instant Client For Mac

There used to be a Mac version of Oracle 10gR2 Client, but now I can't find it on Oracle's site, they only have the newer 11g Client which has not been ported to OS X.

Not interested in virtualizing another OS.

Hennes

60k7 gold badges94 silver badges144 bronze badges

Marcus HedenströmMarcus Hedenström

1 Answer

Never tried it, just found this: MacSequel

MacSequel is Oracle Query tool written from the ground up for your Mac OSX. I made this because I was sick of all those bloated 'Java' based tools which takes minutes to load and consumes huge amount of memory. MacSequel is native Mac, starts quickly, runs smooth and is not bloated with thousands of features you will never use.

slhck

171k49 gold badges476 silver badges492 bronze badges

cagcowboycagcowboy

Not the answer you're looking for? Browse other questions tagged macos or ask your own question.

What is your version of Python? Is it 32-bit or 64-bit?
Python 2.7.10 64-bit
Mac OS X Sierra
What is your version of cx_Oracle?
6.0rc1
Server Setup (Ubuntu 10.10) /etc/exports /export *(rw,sync,no_root_squash,no_subtree_check) /export/fileserver *(rw,sync,no_root_squash,no_subtree_check) /export/fileserver2 *(rw,sync,no_root_squash,no_subtree_check) /etc/fstab /fileserver/a/root /export/fileserver none bind 0 0 /fileserver/b/root /export/fileserver2 none bind 0 0 Client Setup (Mac OS X 10.6.7) The key problem was that id -u tsigo on the server was 1000, and on Mac it was 501. I'll outline how below. https://brownhealth.amebaownd.com/posts/19585427. In order to change this I followed which -- be warned -- was fraught with potential disaster; follow directions closely.
What is your version of the Oracle client (e.g. Instant Client)? How was it
installed? Where is it installed?
Oracle Instant client Mac OS X 12.1
(actually I've installed it multiple times in multiple location)
I have followed the Oracle method to the letter:
http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html#ic_osx_inst
(and I tired a number of other options including putting dynlib files in /usr/local/lib with no luck)
What is your version of the Oracle Database?
N/A Torrent client for mac.
What is your OS and version?
Mac OS X Sierra 10.12.5
What compiler version did you use? For example, with GCC, run
gcc --version.

What environment variables did you set? How exactly did you set them?
Ok, so I tried a lot of environment variables.

I also tried setting PYTHONPATH and adding the Oracle client directory to sys.path using .pth and the site.py configuration options.

What exact command caused the problem (e.g. what command did you try to
install with)? Who were you logged in as?
python -c 'import cx_Oracle; print cx_Oracle.version'
What error(s) you are seeing?
No matter what I tried I would get this error:

So there are lots of antidotal references to this being related to SIP (System Integrity Protection), though I could find no specific technical note from Apple that says exactly what is causing the above error (inability to find dynamic linked library at run time).

So I did find a solution that did not require disabling SIP on Mac OS X. It is pretty simple, and seems to support the theory of SPI being an issue, and matches a lot of notes about discontinuing usage of the LD and DYLD paths.

From the source code download, I ran:
python setup.py build

once it is built I then modified the rpath of the cx_Oracle.so library to include the Oracle instant client location:
install_name_tool -add_rpath ~/instantclient_12_1 ./build/lib.macosx-10.12-intel-2.7/cx_Oracle.so

I could very it was added by using the otool command:
otool -l ./build/lib.macosx-10.12-intel-2.7/cx_Oracle.so

Now that it has been modified, I can do the normal install.

sudo python setup.py install

Openvpn client for mac. Are there any login scripts for the affected user that are pushing out once connected? Hi DataDudes, Are you running LDAP/SSO in the SonicWALL? If you can get on without issue on the same computer using a different account then its not a compatibility issue with your PC and GVC. If not then remove the user in SonicWALL and re-create them.

This puts the cx_oracle egg into the normal system path

Install Oracle On Mac

Post this modification I can now call python and use cx_Oracle on Mac OS X normally.

The biggest issues for this are:

having Oracle client directory in a 'known' location before building cx_Oracle
having to rebuild the cx_Oracle if you change Oracle client location (possibly due to version)

I beat my head on a wall for at least two days trying all the normal workarounds. This was the only model that worked.
Admiralty I didn't try any of this with Pip, I only did this from source code.
I also tied setting FORCE_RPATH=1 but on introspection it never updated the .so file correctly.

Oracle Instant Client 11g

Hope this helps some future install issues.
Thanks,
Gary