Hi,
There is a solution provided by this thread: https://java.databasedevelop.com/article/14153058/ORE+install+ERROR%3a+cannot+copy+server+ore.dll+to+%25ORACLE_HOME%25+b…
However, I have tried adopting the same method but could not resolve my problem.
I have installed ORE 1.5.1 and Oracle database 12c release 2.
My system is as follows:
C:\Windows\system32>C:\app\julia\virtual\product\12.2.0\dbhome_1\R\server.bat
Oracle R Enterprise 1.5.1 Server.
Copyright (c) 2012, 2017 Oracle and/or its affiliates. All rights reserved.
Could Not Find C:\Windows\system32\tmp*.sql
Checking platform .................. Pass
Checking R ......................... Pass
Checking R libraries ............... Pass
Checking ORACLE_HOME ............... Pass
Checking ORACLE_SID ................ Pass
Checking sqlplus ................... Pass
Checking ORACLE instance ........... Pass
Checking CDB/PDB ................... Fail
ERROR: cannot install ORE in a root container
PDB to use for ORE installation [list]: ORCLPDB
Checking CDB/PDB ................... Pass
Checking ORE ....................... Pass
Choosing RQSYS tablespaces
PERMANENT tablespace to use for RQSYS [list]: SYSAUX
TEMPORARY tablespace to use for RQSYS [list]: TEMP
Choosing ORE user
ORE user to use [list]: RQUSER
Choosing RQUSER tablespaces
PERMANENT tablespace to use for RQUSER [list]: SYSAUX
TEMPORARY tablespace to use for RQUSER [list]: TEMP
Choosing RQUSER password
Password to use for RQUSER: ******
Current configuration
R Version ........................ Oracle Distribution of R version 3.3.0 (2016-05-03)
R_HOME ........................... C:\PROGRA~1\R\R-33~1.0
R_LIBS_USER ...................... C:\app\julia\virtual\product\12.2.0\dbhome_1\R\library
ORACLE_HOME ...................... C:\app\julia\virtual\product\12.2.0\dbhome_1
ORACLE_SID ....................... orcl
PDB .............................. ORCLPDB
Existing R Version ............... None
Existing R_HOME .................. None
Existing ORE data ................ None
Existing ORE code ................ None
Existing ORE libraries ........... None
RQSYS PERMANENT tablespace ....... SYSAUX
RQSYS TEMPORARY tablespace ....... TEMP
ORE user type .................... New
ORE user name .................... RQUSER
ORE user PERMANENT tablespace .... SYSAUX
ORE user TEMPORARY tablespace .... TEMP
Grant RQADMIN role ............... No
Operation ........................ Install/Upgrade/Setup
Proceed? [yes] yes
Removing R libraries ............... Pass
Installing R libraries ............. Pass
Installing ORE libraries ........... Fail
ERROR: cannot copy "server\ore.dll" to C:\app\julia\virtual\product\12.2.0\dbhome_1\bin
I have tried setting the work directory to my database home, however i received the following error msg:
C:\Windows\system32>C:\app\julia\virtual\product\12.2.0\dbhome_1\R
'C:\app\julia\virtual\product\12.2.0\dbhome_1\R' is not recognized as an internal or external command,
operable program or batch file.
Hope anyone can kindly help. Thank You.