Hi
Any help appreciated - trying to get Oracle Enterprise R working
I have installed R 3.3.0 with OML4R 1.5 on a Windows 10 server. I have not done the client install as I am just working on the server.
Oracle 19 database with the OML4R install done into a PDB called ORA19PDB.
I used the downloaded R-3.3.0-win.exe for R, and ran C:\orabase\ORA19c\WINDOWS\R\server\rqcfg/.ql for the server instal
Connection works fine:
> ore.connect(user="OML4R", conn_string="ORA19PDB", password="OML4R", all=TRUE)
> ore.is.connected()
[1] TRUE
Call to OML4SQL works fine:
> example("ore.odmAI")
or.dAI> IRIS <- ore.push(iris)
or.dAI> ore.odmAI(Species ~ ., IRIS)
Call:
ore.odmAI(formula = Species ~ ., data = IRIS)
Importance:
importance rank
Petal.Width 0.75224037 1
Petal.Length 0.50083423 2
Sepal.Length 0.04311746 3
Sepal.Width -0.09256225 4
Call to any library fails:
> example("ore.glm")
or.glm> ## Don't show:
or.glm> if (!interactive())
or.glm+ ore.connect(user = Sys.getenv("ORE_USERNAME", "rquser"),
or.glm+ sid = Sys.getenv("ORACLE_SID"),
or.glm+ host = Sys.getenv("HOST"),
or.glm+ password = Sys.getenv("ORE_PASSWORD", "rquser"),
or.glm+ port = if (.Platform$OS.type == "windows")
or.glm+ Sys.getenv("ORACLE_PORT")
or.glm+ else
or.glm+ Sys.getenv("TCPPORT"),
or.glm+ all = TRUE)
or.glm> ## End(Don't show)
or.glm> # Load libraries for examples
or.glm> library(OREstats)
or.glm> library(rpart) # kyphosis and solder data sets
or.glm> # Logistic regression
or.glm> KYPHOSIS <- ore.push(kyphosis)
or.glm> kyphFit1 <- ore.glm(Kyphosis ~ ., data = KYPHOSIS, family = binomial())
Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch, :
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at line 11
ORA-06512: at "RQSYS.RQEVALIMPL", line 17
ORA-06512: at "RQSYS.RQEVALIMPL", line 14
ORA-06512: at line 6
Listener has no entries for extproc:
------------------------------------------------------------------------------------------------------------------------------
c:\orabase\ORA19c\WINDOWS\network\admin\listener.ora
# listener.ora Network Configuration File: C:\orabase\ORA19c\WINDOWS\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN10VM1)(PORT = 1521))
)
)
------------------------------------------------------------------------------------------------------------------------------
Tnsnames has no entries for extproc:
c:\orabase\ORA19c\WINDOWS\network\admin and
c:\orabase\ORA19c\WINDOWS\hs\admin
------------------------------------------------------------------------------------------------------------------------------
# tnsnames.ora Network Configuration File: C:\orabase\ORA19c\WINDOWS\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORA19 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN10VM1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORA19)
)
)
ORA19PDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN10VM1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORA19PDB)
)
)
PDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN10VM1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDB2)
)
)
LISTENER_ORA19 =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN10VM1)(PORT = 1521))
------------------------------------------------------------------------------------------------------------------------------
Extproc.ora has the following entries:
SET EXTPROC_DLLS=ANY
SET TRACE_LEVEL=ON
I have removed any other older oracle folders from the path to avoid picking up and old tnsnames
Environment Variables:
ORACLE_HOME C:\orabase\ORA19c\WINDOWS
ORACLE_ID ORA19
Path C:\orabase\ORA19c\WINDOWS\bin;C:\Program Files\R\R-3.3.0\bin\x64;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;%SYSTEMROOT%\System32\OpenSSH\;
2 Trace files produced when getting the ORA-28575 error :
------------------------------------------------------------------------------------------------------------------------------
Oracle Corporation --- 2020-04-18 09:25:34.896000000
Heterogeneous Agent Release
19.0.0.0.0
Oracle Corporation --- 2020-04-18 09:25:34.895000000
Version 19.0.0.0.0
HOA 04/18 09:25:34.898000000: (horcrase_AllocStackElt) Entered!
HOA 04/18 09:25:34.898000000: (horcrase_AllocStackElt) Exiting...
HOA 04/18 09:25:34.899000000: (horcrpuoe_PushOciEnv) Entered!
HOA 04/18 09:25:34.899000000: (horcrpuoe_PushOciEnv) Exiting...
HOA 04/18 09:25:34.900000000: (horcries_InitExtprocSession) Exiting...
HOA 04/18 09:25:34.900000000: (hotkisc_InitSessionContext) Exiting...
HOA 04/18 09:25:34.901000000: (hotkec_EstablishConnection) Entered!
2020/04/18-09:25:34.902000000: Entered shorcsje_spawn_jssu_extproc
HS: Parent extproc received the IN param, flags_horrx = 0x1000
HS: Parent extproc is falling back to the old behavior with connect string = (ADDRESS=(PROTOCOL=BEQ)(PROGRAM=C:\orabase\ORA19c\WINDOWS\bin\extproc)(ARGV0=C:\orabase\ORA19c\WINDOWS\bin\extproc)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))
HS: Parent extproc called nsbequeath! status = 0
2020/04/18-09:25:34.964000000: Exiting shorcsje_spawn_jssu_extproc, rc=0
HS: Parent extproc is calling exit(0)!!!
HOA 04/18 09:25:34.965000000: (hotkec_EstablishConnection) Parent extproc called shorcsje_spawn_jssu_extproc, status = 0
------------------------------------------------------------------------------------------------------------------------------
second trace file
------------------------------------------------------------------------------------------------------------------------------
Oracle Corporation --- 2020-04-18 09:25:34.955000000
Heterogeneous Agent Release
19.0.0.0.0
Oracle Corporation --- 2020-04-18 09:25:34.955000000
Version 19.0.0.0.0
HOA 04/18 09:25:34.956000000: (horcrase_AllocStackElt) Entered!
HOA 04/18 09:25:34.957000000: (horcrase_AllocStackElt) Exiting...
HOA 04/18 09:25:34.957000000: (horcrpuoe_PushOciEnv) Entered!
HOA 04/18 09:25:34.958000000: (horcrpuoe_PushOciEnv) Exiting...
HOA 04/18 09:25:34.958000000: (horcries_InitExtprocSession) Exiting...
HOA 04/18 09:25:34.959000000: (hotkisc_InitSessionContext) Exiting...
HOA 04/18 09:25:34.959000000: (hotkec_EstablishConnection) Entered!
2020/04/18-09:25:34.961000000: Entered shorcppt_print_pid_tid
HS: extproc is writing [12988/12256] to stdout!
HS: Null stdout handle! extproc failed to write.
2020/04/18-09:25:34.962000000: Exiting shorcppt_print_pid_tid
HOA 04/18 09:25:34.964000000: (hotkec_EstablishConnection) Child extproc called nsinherit, status = 0
------------------------------------------------------------------------------------------------------------------------------