Install_name_tool -change '/usr/local/oracle/libclntsh.dylib.12.1' libsqora.dylib.12.1 Install_name_tool -id '/usr/local/oracle/instantclient/libsqora.dylib.12.1' libsqora.dylib.12.1 Following this post change relative paths to absolute paths.USER DATA SOURCES.: /Users/matt/.odbc.iniĭescription = Oracle ODBC driver for Oracle 12cĭriver = /usr/local/oracle/instantclient/libsqora.dylib.12.1ĭriver=/usr/local/oracle/instantclient/libsqora.dylib.12.1 SYSTEM DATA SOURCES: /usr/local/etc/odbc.iniįILE DATA SOURCES.: /usr/local/etc/ODBCDataSources Running odbcinst -j returns unixODBC 2.3.7ĭRIVERS.: /usr/local/etc/odbcinst.ini Fix the bug in /usr/local/oracle/odbc_update_ini.sh by changing line 120 from.Xattr -r -d -s instantclientĮxport ORACLE_HOME=/usr/local/oracle/instantclientĮxport OCI_INCLUDE_DIR=$OCI_HOME/sdk/include # change to the parent directory and remove all quarantine attributes # change all the permissions so that you can alter the file attibutes Sudo mv ~/Downloads/instantclient /usr/local/oracle/instantclient instantclientĬp -a instantclient_12_2-5/. instantclientĬp -a instantclient_12_2-4/. instantclientĬp -a instantclient_12_2-3/. Combine all the instant client files into one and move that file.Ĭp -a instantclient_12_2-2/.I have recreated the error on a vm using the following stepsĭownload instant client files from Oracle I have found similar problems on RStudio's github page, and here and here on RStudio Community, but have not been able to resolve the issue with their solutions. I can successfully query the database from isql, but cannot from R (command line) or RStudio. The error I am receiving is Error: nanodbc/nanodbc.cpp:983: 00000: Can't open lib '/usr/local/lib/libsqora.dylib.12.1' : file not found I am trying to connect to an Oracle database with the odbc and DBI packages on a Mac.

Oracle database for mac os