Hi, I have done a lot of searches but could not fix my problem. Please help! and thanks heaps in advance.
I have RStudio Server Pro V1 installed on RHEL7.0. R version is 3.3.1 and ROracle 1.2-2. I followed examples from here and below is my R script:
- library(ROracle)
- drv <- dbDriver("Oracle")
- host <- "dw.my.com"
- port <- "1521"
- sid <- "dwoa"
- connect.string <- paste( "(DESCRIPTION=", "(ADDRESS=(PROTOCOL=tcp)(HOST=", host, ")(PORT=", port, "))", "(CONNECT_DATA=(SERVICE_NAME=", sid, ")))", sep = "")
- con <- dbConnect(drv, username = "admin", password = "admin", dbname = connect.string)
From line 1 to 6, it can run without a problem, but it failed at line 7 when trying to establish a connection. The error message returned was:
Error in .oci.Connect(.oci.drv(), username = username, password = password, :
ORA-21561: OID generation failed
What I else have I tried:
- modified /etc/hosts to include database host
- modified Reviron file based on this thread
- tried uninstall R, RStudio Server and reinstall...