Hello,
After install r studio(using the free edition), I continue to run into issues where I am able to make connections using isql but fail to make a oracle connection using r studio. The following is the current configuration on the server itself:
bashrc file:
#env
export LD_LIBRARY_PATH=/opt/oracle/instantclient_12_1
export ODBCINI=/etc/odbc.ini
export TNS_ADMIN=/opt/oracle/instantclient_12_1
export ORACLE_HOME=/opt/oracle/instantclient_12_1
/etc/odbc.ini:
[Oracle 12c ODBC driver]
Description = Oracle ODBC driver for Oracle 12c
Driver = /opt/oracle/instantclient_12_1/libsqora.so.12.1
Setup =
FileUsage =
CPTimeout =
CPReuse =
Trace = yes
TraceFile = ~/driver.log
/etc/odbcinst.ini:
[Oracle Driver OCI]
Driver = /opt/oracle/instantclient_12_1/
[Oracle 12c ODBC driver]
Description = Oracle ODBC driver for Oracle 12c
Driver = /opt/oracle/instantclient_12_1/libsqora.so.12.1
Setup =
FileUsage =
CPTimeout =
CPReuse =
Trace = yes
TraceFile = ~/driver.log
With the current configuration I am able to successfully make a connection to the oracle cluster using isql.
/opt/oracle/instantclient_12_1$ isql -v RServer
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
But when I try to make the connection in r studio I get this error. Here is the error, along with the query output in r studio.
library(odbc)
odbcListDrivers()
name attribute value
1 Oracle Driver OCI Driver /opt/oracle/instantclient_12_1/
2 Oracle 12c ODBC driver Description Oracle ODBC driver for Oracle 12c
3 Oracle 12c ODBC driver Driver /opt/oracle/instantclient_12_1/libsqora.so.12.1
4 Oracle 12c ODBC driver Setup
5 Oracle 12c ODBC driver FileUsage
6 Oracle 12c ODBC driver CPTimeout
7 Oracle 12c ODBC driver CPReuse
8 Oracle 12c ODBC driver Trace yes
9 Oracle 12c ODBC driver TraceFile ~/driver.log
error: when making a new connection in r studio
Error: nanodbc/nanodbc.cpp:950: 01000: [unixODBC][Driver Manager]Can't open lib '/opt/oracle/instantclient_12_1/libsqora.so.12.1' : file not found
if anyone has any idea as to where I am going wrong with configuration or in r studio that would be great.
regards