Conection to Oracle DB

[carlos_rc24]

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

[andresrcs]

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

[carlos_rc24]

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 -> 
tryCatchList -> tryCatchOne -> <Anonymous> Execution halted

Thank you

[andresrcs]

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.

[josh]

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.