ORACLE 12C FOR MAC DRIVER

stats graphics grDevices utils datasets methods base

LAPACK: /Library/Frameworks/R.framework/Versions/4.0/Resources/lib/libRlapack.dylib Platform: x86_64-apple-darwin17.0 (64-bit)īLAS: /System/Library/Frameworks/amework/Versions/A/Frameworks/amework/Versions/A/libBLAS.dylib I run the following connection script to produce the error. Install_name_tool -rpath '/usr/local/lib' libsqora.dylib.12.1 Install_name_tool -change '/usr/local/oracle/libodbcinst.2.dylib' libsqora.dylib.12.1 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.

ORACLE 12C FOR MAC DRIVER

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 12c for mac