This content has been marked as final. Show 6 replies
Did you install the ORE client and ORE client supporting packages on your client machine? The Oracle R Enterprise client installation procedure is described in the ORE Installation and Administration Guide:
I have already done that. I am able to execute ore.pull outside of doEval. It is only when started trying the examples using doEval I ran into this issue. Can you think of anything else that could be missing.
Try adding ore.connect() inside ore.doEval().
mod<-lm(Total_Volume ~ Promo_Volume, dat)
ORE 1.0 relied on the setup of .RProfile or .RProfile.site for embedded R execution, and this requirement was removed in ORE 1.1. As such, you need to add the additional ore.connect() function to your code in ORE 1.1. Also, OREbase is loaded as a dependency of ORE, so I removed the explicit 'library(OREbase)' call in your example.
I tried the change you had recommended, but it gave me the same message.
Error in .oci.GetQuery(conn, statement, ...) :
ORA-29400: data cartridge error
Error : package 'ROracle' required by 'OREbase' could not be found
ORA-06512: at "RQSYS.RQEVALIMPL", line 57
Let me know if I should check anything with the install of the OREServer. I just got to know from my admin that they had run into a permission issue while installing the supporting packages post which they set the environment variable R_LIBS_USER to a different path and proceeded with the install. Could this be the reason?
This is the reason embedded R cannot find the ORE supporting packages (ROracle, DBI, and png). The simplest way to fix this is to copy these packages to the same directory as the ORE packages ($ORACLE_HOME/R/library) since they presumably had write access to this location or they would not have been able to install the ORE packages. You can also confirm this directory is in the list of paths your R searches for packages by typing at the R console:
Please try this and let me know if this resolves the problem.
It worked thanks for your help on this issue.