Oracle Client For Mac Sierra

 

Join GitHub today

GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.

Steps to Use macOS 10.12 Sierra on VirtualBox on Windows, VirtualBox macos sierra, VirtualBox on Sierra, install mac os Sierra on vmware, install VirtualBox on Sierra, VirtualBox Sierra Mac.

Sign up New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Comments

commented Jul 23, 2018•
edited

Answer the following questions:

  1. What is your version of Python? Is it 32-bit or 64-bit?
    Python 2.7.15
  2. What is your version of cx_Oracle?
    cx_Oracle 6.4.1
  3. What is your version of the Oracle client (e.g. Instant Client)? How was it
    installed? Where is it installed?
    instantclient_12_2 64 bits
    Unzipped
    /Users/USER_X/opt/oracle/instantclient_12_2
  4. What is your version of the Oracle Database?
    instantclient_12_2
  5. What is your OS and version?
    macOS High Sierra 10.13.5
  6. What compiler version did you use? For example, with GCC, run
    gcc --version.
    Apple LLVM version 9.1.0 (clang-902.0.39.2)
  7. What environment variables did you set? How exactly did you set them?
    export ORACLE_HOME=/Users/USER_X/Applications/oracle/instantclient_12_2
    export DYLD_LIBRARY_PATH=$ORACLE_HOME
    export LD_LIBRARY_PATH=$ORACLE_HOME
    export PATH=$ORACLE_HOME:$PATH
  8. What error(s) you are seeing?
    cx_Oracle.DatabaseError: DPI-1047: 64-bit Oracle Client library cannot be loaded: 'dlopen(libclntsh.dylib, 1): image not found'. See https://oracle.github.io/odpi/doc/installation.html#macos for help

I've been dealing with it for hours but I can not figure out how to solve it. I've installed 32-bit and 64-bit Oracle database versions without any effect.

changed the titleDPI-1047: 64-bit Oracle Client library cannot be loadedJul 23, 2018

added the install & configuration label Jul 23, 2018

commented Jul 23, 2018

Did you follow all of the instructions noted in the documentation? For instant client you do not need to set ORACLE_HOME and setting DYLD_LIBRARY_PATH and $LD_LIBRARY_PATH are not effective in most macOS installations. See the installation instructions for more details.

commented Jul 24, 2018

I followed the instructions from the beginning to the end.
I've changed /Users/USER_X/opt/oracle/instantclient_12_2 path to /opt/oracle/instantclient_12_2 but still have the same problem. Also I've unsetted the ORACLE_HOME, DYLD_LIBRARY_PATH and LD_LIBRARY_PATH variables.
I don't know how to continue. I really appreciate any help.

commented Jul 24, 2018

Saying you followed them doesn't help us identify if something was missed or where the problem is.

Here's my ~/lib directory:

That's it. It was: unzip, create symlink, done.

commented Jul 24, 2018

Don't forget the first line of the installation instructions: 'Make sure you are not using the bundled Python. This has restricted entitlements and will fail to load Oracle client libraries. Instead use Homebrew or Python.org.'

commented Jul 24, 2018

That was my error, I was using the bundled Python. I've changed it by the homebrew version and now works fine.
Many thanks guys!!!

commented Feb 22, 2019

How to check if I'm using bundled python ?

commented Feb 22, 2019

If you haven't explicitly installed Python, then you will be using the bundled python. You can also check like:

commented Feb 22, 2019

I'm using anaconda and the command$which pythongives this /anaconda3/bin/python.I keep getting the below error when I try connecting to Oracle databasethrough python:DatabaseError: DPI-1047: 64-bit Oracle Client library cannot be loaded:'dlopen(libclntsh.dylib, 1): image not found'. Seehttps://oracle.github.io/odpi/doc/installation.html#macos for helpAs far as I understand, anaconda or python has no knowledge of where thedynamic libraries are, in order to make a connection.Can you point me in the right direction?Thanks for your help,Deekshith.
…
On Thu, Feb 21, 2019 at 10:53 PM Christopher Jones ***@***.***> wrote: If you haven't explicitly installed Python, then you will be using the bundled python. You can also check like: $ which python /usr/bin/python — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#206 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ApoXCc_Pb8OrnevbNI1zYXCfftH4qi1qks5vP3e1gaJpZM4Va72G> .

commented Feb 22, 2019

Follow the installation instructions https://cx-oracle.readthedocs.io/en/latest/installation.html#installing-cx-oracle-on-macos regarding Instant Client set up.

Open a new issue if you still have problems.

Sign up for freeto join this conversation on GitHub. Already have an account? Sign in to comment

Last updated on APRIL 18, 2019

Applies to:

Content and Experience Cloud Service - Version 14.1.0.0.0 and later
Content and Experience Cloud Classic - Version 18.1.2 and later
Content and Experience Cloud - Version 18.2.5 and later
Information in this document applies to any platform.

Symptoms

After upgrading my Mac operating system to MacOS High Sierra, the CEC Sync app either crashes consistently or stopped syncing due to the following error:

Changes

Upgrade to Mac OS X 10.13 (High Sierra)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Oracle
Changes
Cause
Solution

Oracle Mac Download

References

Oracle 11g For Mac


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.