We now have an Oracle12c 12.0.1.0 DB installation and all the ORE client/server stuff set up.
However, I'm running into a problem when I try to enable ore.parallel. When I do not enable ore.parallel things seem to be working.
Here is a client-side R console trace showing the problem. I've highlighted the error message in red and then show in blue that by turning off ore.parallel that the same command works.
-------------
Oracle Distribution of R version 3.2.0 (2015-04-16) -- "Full of Ingredients"
Copyright (C) 2015 The R Foundation for Statistical Computing
Platform: sparc-sun-solaris2.10 (64-bit)
R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.
R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.
Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.
You are using Oracle's distribution of R. Please contact
Oracle Support for any problems you encounter with this
distribution.
> options(STERM='iESS', str.dendrogram.last="'", editor='emacsclient', show.error.locations=TRUE)
> library(ORE)
Loading required package: OREbase
Loading required package: OREcommon
Attaching package: 'OREbase'
The following objects are masked from 'package:base':
cbind, data.frame, eval, interaction, order, paste, pmax, pmin,
rbind, table
Loading required package: OREembed
Loading required package: OREstats
Loading required package: MASS
Loading required package: OREgraphics
Loading required package: OREeda
Loading required package: OREmodels
Loading required package: OREdm
Loading required package: lattice
Loading required package: OREpredict
Loading required package: ORExml
> ore.connect(user = "SCOTT", sid="pwuodb", host="sca-t72-005", password ="oracle123",port = 1521,all=TRUE)
> options("ore.parallel" = TRUE)
> options("ore.parallel")
$ore.parallel
[1] TRUE
> oldfit <- ore.lm(total_spc ~ .,data=KDF)
Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch, :
ORA-12801: error signaled in parallel query server P02A
ORA-06520: PL/SQL: Error loading external library
ORA-06522: ld.so.1: extproc: fatal: libR.so: open failed: No such file or directory
ORA-06512: at "RQSYS.RQROWEVALIMPL", line 91
ORA-06512: at "RQSYS.RQROWEVALIMPL", line 87
> options("ore.parallel" = FALSE)
> options("ore.parallel")
$ore.parallel
[1] FALSE
> oldfit <- ore.lm(total_spc ~ .,data=KDF)
> summary(oldfit)
Call:
ore.lm(formula = total_spc ~ ., data = KDF)
Residuals:
Min 1Q Median 3Q Max
NA NA NA NA NA
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 3.7960364 0.0008737 4344.783 <2e-16 ***
ICD 1.8223367 0.0010157 1794.207 <2e-16 ***
ICD_W 1.3780865 0.0088131 156.368 <2e-16 ***
ICD_BYPASS 1.4738895 0.0153952 95.737 <2e-16 ***
SEL_RD 2.1395738 0.0012400 1725.435 <2e-16 ***
SEL_WR 0.6713528 0.0012040 557.586 <2e-16 ***
SEL_WREN_CNT_OR -0.0240932 0.0001500 -160.621 <2e-16 ***
SEL_DOUT_CNT_OR -2.1293364 0.0009706 -2193.762 <2e-16 ***
SEL_RD_STALL -0.1562068 0.0008240 -189.566 <2e-16 ***
ARF_W 0.0969948 0.0003554 272.950 <2e-16 ***
WRF_W_OR 0.2489047 0.0005884 423.022 <2e-16 ***
PKU_WR 0.1053876 0.0002746 383.744 <2e-16 ***
LSU_LOAD 0.4568071 0.0123981 36.845 <2e-16 ***
SB_CAM 0.4318369 0.0124039 34.815 <2e-16 ***
RSU_CAM_OR 0.5243173 0.0009870 531.229 <2e-16 ***
DCA_WR 0.7317484 0.0018213 401.772 <2e-16 ***
L2D_F1RST_PASS_delay 0.4499524 0.0010892 413.086 <2e-16 ***
LSU_DTAG_WREN -0.0078698 0.0031140 -2.527 0.0115 *
DTLB_CAM_LOOKUP 0.7418698 0.0123827 59.912 <2e-16 ***
FGU_MUL_CLK 0.3943377 0.0009374 420.667 <2e-16 ***
FGU_VIS_CLK 0.9990996 0.0017691 564.746 <2e-16 ***
FGU_DIV_CLK 0.0759916 0.0009229 82.341 <2e-16 ***
WRF_ONLY_R 0.0617309 0.0004442 138.968 <2e-16 ***
WRF_ARF_R_OR 0.2274591 0.0003315 686.094 <2e-16 ***
EXU2_I2 0.2583317 0.0011534 223.969 <2e-16 ***
EXU3_I2 0.4623283 0.0011474 402.949 <2e-16 ***
TLU_CM_CNT 0.2591759 0.0003437 754.138 <2e-16 ***
TLU_THREAD_CNT 0.1010813 0.0001114 907.502 <2e-16 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 0.6738 on 8821796 degrees of freedom
Multiple R-squared: 0.9502, Adjusted R-squared: 0.9502
F-statistic: 6.229e+06 on 27 and 8821796 DF, p-value: < 2.2e-16