ORE install ERROR: cannot copy server/ore.dll to %ORACLE_HOME%\bin - R Technologies

4178211

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.

Sherry Lamonica-Oracle

Does $ORACLE_HOME/bin, or C:\app\julia\virtual\product\12.2.0\dbhome_1\bin, have write permissions by the oracle user?  This is a requirement for the installation.