To connect Oracle R Enterprise Client to Oracle R Enterprise Server, start R using the ORE script:
% ORE R> library(ORE)
The following examples connect as user RQUSER
with password RQUSERpsw
:
For a remote database, specify the Oracle Database service identifier (SID), the host name, and the port for the connection.
ore.connect(user="RQUSER", sid="orcl", host="SVR3", password="RQUSERpsw", port=1521, all=TRUE)
Note:
To avoid specifying the password and other connection details in embedded R scripts, you can use Oracle Wallet. See Creating an Oracle Wallet for an Oracle R Enterprise Connection.
For a local database, specify the connection as follows:
ore.connect("RQUSER", password="RQUSERpsw", conn_string="", all=TRUE)
See Also:
Oracle R Enterprise User's Guide for details about connecting to Oracle R Enterprise Server