WI:connectivity Issues With Oracle R Enterprise
(Doc ID 1495916.1)
Last updated on OCTOBER 17, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2]
Information in this document applies to any platform.
Qn1: Can you connect Oracle - R Enterprise - using Service Name?
In our tests we have seen that the "ore.connect" procedure has a SID parameter, however, we connect to our Oracle platform by Service Name.
To skip this parameter we have tried to override the ore.connect function (please, see the attached R script).
At the beginning it seems to be working well because it returns some basic information such as the server version but after the connection, we try to use other basic functions to work with the database objects and it is not possible because it throws an error that indicates there is no connection established.
Error in dbGetQuery(.ore.con(), OREbase:::ore.dlogq(qry), ...) : error in evaluating the argument 'conn' in selecting a method for function 'dbGetQuery': Error in .ore.con() : not connected to ORE
Using R version 2.13.2 (2011-09-30) with RStudio (0.96.316) and Oracle R Enterprise client 1.0 for Windows on Windows 7.
Qn2: Oracle - R Enterprise - Execution in the server side
Why do we encounter the following when trying to execute a simple tutorial level statement?
- The execution of "ore." functions inside the "doEval" function, the script attached ("AAP - doEval.R") contains a tiny piece of code which tries to use "ore.lm" to apply a linear model in the server side but in such case it throws another error:
Error in .oci.GetQuery(conn, statement, ...) :
ORA-29400: data cartridge error
Error in function () : could not find function "ore.lm"
ORA-06512: at "RQSYS.RQEVALIMPL", line 57
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document