Download binary from oracle: http://www.oracle.com/technetwork/database/database-technologies/r/roracle/downloads/index.html
The run the following command in r, substituting the file path:
setwd('xxxxx') # set to path of download
install.packages('ROracle_1.1-11.zip', repos = NULL)
Then load the library and use the package - you may have to change XXXX to whatever is in your TNS Names:
library('ROracle')
drv <- dbDriver("Oracle")
# NOTE: never store passwords in a saved script!!
con <- dbConnect(drv, "USER GOES HERE", "PASSWORD GOES HERE", dbname='XXX')
test connection:
dbReadTable(con, 'DUAL')
I am getting exactly the same message. Any update on what is causing this problem. I have SQL Developer installed and it is working. OCI_INC set to C:\Oracle\Product\11.2.0\client_1\oci\include , I tried setting OCI_LIB64 too, but didn't work.