ORE = Oracle R Enterprise
To use ORE, we need to install
- ORE Client
- ORE Server
Here is my test:
1. ORE Client
It allows you to connect to Oracle database from a R console.
The special R console is a command line executable with the name ore.
ore library(ORE) ore.connect("","orcl","localhost","",type="ORACLE", all=TRUE)
Here orcl=SID, the port is 1521 if you do not specify.
Here is the link to the documentation:
Installing Oracle R Distribution on Microsoft Windows
Installing Oracle R Enterprise Client
2. ORE Server
The remote database need to have the R Enterprise server.
Installing Oracle R Enterprise Server
Otherwise, you will get the error:
Error: Oracle R Enterprise Server is not available