Conection to Oracle DB

shiny
1

Hi, can anyone tell me how to make the connection from shinyapps.io to a oracle database, I have used this string connection but I get a error

 dbconnection <- dbConnect(odbc::odbc(),
           Driver = "Oracle",
           Database = "costos", 
           UID = "npowerxxx",
           PWD = "UZWVMxxxx",
           Server = "216.xxx.xxx.xxx",
           Port = 1523
 )

Thank in advance

2

What's the error? That can give us a clue about your problem

3

Hi, this is the error:

Error in value[[3L]](cond) : nanodbc/nanodbc.cpp:950: 01000: [unixODBC]
[Driver Manager]Can't open lib '/opt/rstudio-drivers/oracle/bin/lib
/liboracleodbc_sb64.so' : file not found Calls: local ... tryCatch -&gt; 
tryCatchList -&gt; tryCatchOne -&gt; &lt;Anonymous&gt; Execution halted

Thank you

4

It seems that there is no driver for oracle databases installed on the shinyapps.io server, this has to be fixed on their side, if you have a paid account maybe you can get in touch with customer support, because of the holidays I think is very unlikely that they read this here.

5

Oracle drivers require user click through acceptance as well as an Oracle Account in order to download.
So while the Oracle professional driver is actually present in /opt/rstudio-drivers/oracle/bin/lib /liboracleodbc_sb64.so, two shared libraries are not present (libocci.so.12.1 and libclntsh.so.12.1) which prevent the driver from loading.

I will share this post with colleagues who work on the drivers who might be able to add more context.

6

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.