My Oracle Support Banner

WI:connectivity Issues With Oracle R Enterprise (Doc ID 1495916.1)

Last updated on OCTOBER 17, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Goal

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
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.