This discussion is archived
8 Replies Latest reply: Apr 11, 2013 9:24 AM by Sherry LaMonica RSS

Oracle R Enterprise installation ERROR: cannot copy dll file

user13667036 Newbie
Currently Being Moderated
This is bit strange, I posted this message in 2 forums but surprisingly can't find it anymore!! Anyways, I would appreciate if anyone can help me a bit on this issue:

I am having trouble installing ORE 1.3 on my windows 7 (home premium, personal notebook) 64 bit. I strictly followed the installation note and made sure all the path variables are defined properly. My R version is 2.15.1. My Windows user is a member of ora_dba group as can be seen below.
C:\Users\sourabh>net localgroup ora_dba
Alias name        ora_dba
Comment         Oracle DBA Group

Members
-----------------------------------------------------------------------------------------
NT AUTHORITY\SYSTEM
sourabh
The command completed successfully.
Now when I try to install.bat (bare with me as I try to include the whole path as I believe there may be the problem. Note that my oracle and R installation is in H:\ drive, not in C:\. Can that be an issue about some windows permission? I off-course tried many ways, gave the user full permission, but no luck.)
C:Users\sourabh>H:\ORACLE\OracleREnterprise\ORE\ore-server-win-x86_64-1.3\server\install.bat

Oracle R Enterprise 1.3 Server Installation.
Copyright (c) 2013, Oracle and/or its affiliates. All rights reserved.

Checking R ...................................
Pass
Checking R libraries ........................
Pass
Checking ORACLE_HOME ...............
Pass
Checking ORACLE_SID ..................
Pass
Checking sqlplus ...........................
Pass
Checking ORE ..............................
Pass
Current configuration
  R_HOME            = H:\ORACLE\OracleREnterprise\R\R-2.15.1
  R_LIBS_USER     = H:\ORACLE\Oracle11g\product\11.2.0\dbhome\R\library
  ORACLE_HOME  =  H:\ORACLE\Oracle11g\product\11.2.0\dbhome
  ORACLE_SID      = SINHA
Do you wish to install ORE? [yes]

Choosomg RQSIS tablespace
PERMANENT tablespace to use for RQSYS [SYSAUX]:
  Using default SYSAUX
TEMPORARY tablespace to use for RQSYS [TEMP]:
  Using default TEMP
  Tablespace summary
  PERMANENT tablespace = SYSAUX
  TEMPORARY tablespace = TEMP

Installing libraries ..............
Fail
  ERROR: cannot copy "rqe.dll" to "H:\ORACLE\Oracle11g\product\11.2.0\dbhome\bin"

C:Users\sourabh>
Now here is the default group/user and permissions structures for C:\ and H:\ installation directories on my computer:
C:\program files : 

        Group or user names                                    Permissions
        --------------------------------------------------------------------------------                                            
        CREATOR OWNER                                          Special Permissions
        SYSTEM                                                 FULL control
        Administrators (Win7\administrators)                   FULL control                
        Users (Win7\Users)                                     Read & execute, List folder contents, Read
        TrustedInstaller                                       List folder contents, Special Permissions


H:\%ORACLE_HOME% :

        Group or user names                                    Permissions
        --------------------------------------------------------------------------------                                            
        Authenticated Users                                    Special Permissions
        SYSTEM                                                 FULL control
        Administrators (Win7\administrators)                   FULL control                
Now noticed that there is no user called sourabh (Win7\Users) or Users (Win7\Users) on H:\, so I created and gave them "Full control" permission before running install script, but still no luck.... Any help please?

Thanks,
Sourabh
  • 1. Re: Oracle R Enterprise installation ERROR: cannot copy dll file
    user13667036 Newbie
    Currently Being Moderated
    This is an update, actually a test to check whether I can write in %ORACLE_HOME% -- suggested By Sherry LaMonica (member of this forum). She suggested to check if I can create any folder there. I checked -- I can create folder, read, write, copy delete files for all these directories: %ORACLE_HOME%, %ORACLE_HOME%\BIN and %ORACLE_HOME%\R\library (created during ORE installation -- though nothing is there).

    ~Sourabh
  • 2. Re: Oracle R Enterprise installation ERROR: cannot copy dll file
    Sherry LaMonica Journeyer
    Currently Being Moderated
    Sourabh,

    The installer is failing when copying libraries to $ORACLE_HOME/bin. Here's the exact point in the script that fails:

    @echo Installing libraries .........
    set ORE_FILES=^
    "rqe.dll" ^
    "ore.dll" ^
    "libiomp5md.dll" ^
    "%R_HOME%\bin\x64\R.dll" ^
    "%R_HOME%\bin\x64\Rblas.dll" ^
    "%R_HOME%\bin\x64\Rlapack.dll" ^
    "%R_HOME%\bin\x64\Rgraphapp.dll" ^
    "%R_HOME%\bin\x64\Riconv.dll" ^
    "%R_HOME%\bin\x64\Rzlib.dll"
    for %%f in (!ORE_FILES!) do (
    call:filename %%f
    set f="%ORACLE_HOME%\bin\!RET!"
    if exist !f! (
    @echo. WARNING: already exists !f!
    )
    copy /Y %%f "%ORACLE_HOME%\bin" >null
    if errorlevel 1 (
    @echo.Fail
    @echo. ERROR: cannot copy %%f to "%ORACLE_HOME%\bin"
    goto exit
    )
    )

    You've confirmed that you are logged in as user sourabh when installing ORE, and that user sourabh is in the ORA_DBA group and has write permission to $ORACLE_HOME/bin on drive H. Satisfying these requirements typically ensures a successful installation, so it's not yet clear why you are experiencing problems on your Windows 7 machine. Please try manually copying the 9 DLLs mentioned above to $ORACLE_HOME/bin and then try running the installer again.

    Sherry
  • 3. Re: Oracle R Enterprise installation ERROR: cannot copy dll file
    user13667036 Newbie
    Currently Being Moderated
    Sherry,
    Thanks for your reply, in fact if I remember correctly I did copy the req.dll to %ORACLE_HOME%\bin and it showed the warning (dll already exists) and came up with the error (I don't remember what exactly - probably for the next dll). I will try to install tonight and update.
    Oh, by the way it just occurred to me that while installing ORE, my database is always up and running. Can that be an issue? I always start the DB because the manual says I need to create R user after installing...

    Thanks,
    Sourabh

    Edited by: user13667036 on Apr 8, 2013 7:07 AM
  • 4. Re: Oracle R Enterprise installation ERROR: cannot copy dll file
    user13667036 Newbie
    Currently Being Moderated
    Hi all,
    I have finally solved the problem, it seems somehow on my windows home premium I can't run the install script (on H:\ ) from the command line. I manually ran the batch script by double clicking on it, it ran fine and I was finally able to install ORE (server + supported + client) on my laptop. Now the connection -- followed through the manual, created user and granted all the roles. Now that I want to test the connection, I open R console and below are the input and output error message though it seems I can connect to the database:
    R>
    R> library(ORE)
    Loading required package: OREbase
    
    Attaching package: ‘OREbase’
    
    The following object(s) are masked from ‘package:base’:
    
        cbind, data.frame, eval, interaction, order, paste, pmax, pmin, rbind, table
    
    Loading required package: OREstats
    Loading required package: MASS
    Loading required package: OREgraphics
    Loading required package: OREeda
    Loading required package: OREdm
    Loading required package: lattice
    Loading required package: OREpredict
    Loading required package: ORExml
    R>
    R>
    R>
    R> ore.connect(user = 'scott', sid = 'sinha', host = 'win7', password = 'tiger', port = 1521, all = T)
    Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch,  : 
      ORA-06520: PL/SQL: Error loading external library
    ORA-06522: Unable to load DLL
    ORA-06512: at "RQSYS.RQEVALIMPL", line 17
    ORA-06512: at "RQSYS.RQEVALIMPL", line 14
    ORA-06512: at line 4
    R> 
    R> 
    R> ore.is.connected()
    [1] TRUE
    R> 
    I get the exact same error when I try to use even the ORE user "rquser". Any suggestion how to resolve this error?

    Thanks,
    Sourabh
  • 5. Re: Oracle R Enterprise installation ERROR: cannot copy dll file
    user13667036 Newbie
    Currently Being Moderated
    Sherry suggested:
    - This may be an issue with extproc on your system.   
    - Configure EXTPROC by altering the extproc.ora file located in the ORACLE_HOME\hs\admin directory by setting the EXTPROC_DLLS environment variable:
    - EXTPROC_DLLS=ONLY
    - Then restart the database and try ore.connect() again.
    My Followup:

    "EXTPROC_DLL=ONLY" in extproc.ora results:
    R> ore.connect(user = 'scott', sid = 'sinha', host = 'win7', password = 'tiger', port = 1521, all = T)
    Loading required package: ROracle
    Loading required package: DBI
    Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch,  : 
      ORA-28578: protocol error during callback from an external procedure
    ORA-06512: at "RQSYS.RQEVALIMPL", line 17
    ORA-06512: at "RQSYS.RQEVALIMPL", line 14
    ORA-06512: at line 4
    "EXTPROC_DLL=ANY" in extproc.ora results (same as before):
    R> ore.connect(user = 'scott', sid = 'sinha', host = 'win7', password = 'tiger', port = 1521, all = T)
    Loading required package: ROracle
    Loading required package: DBI
    Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch,  : 
      ORA-06520: PL/SQL: Error loading external library
    ORA-06522: Unable to load DLL
    ORA-06512: at "RQSYS.RQEVALIMPL", line 17
    ORA-06512: at "RQSYS.RQEVALIMPL", line 14
    ORA-06512: at line 4
  • 6. Re: Oracle R Enterprise installation ERROR: cannot copy dll file
    Denis Mukhin Journeyer
    Currently Being Moderated
    What is in your <tt>tnsnames.ora</tt> and <tt>listner.ora</tt>?
  • 7. Re: Oracle R Enterprise installation ERROR: cannot copy dll file
    user13667036 Newbie
    Currently Being Moderated
    Hi Denis,
    Below are my listner.ora and tnsnames.ora. My oracle version is 11.2, and it is pointed out by Sherry LaMonica that for ORE to work properly Oracle version needs to be 11.2.0.3. Is there any way out other than applying the patch or upgrading to 11.2.0.3.

    listner.ora:
    # listener.ora Network Configuration File: H:\ORACLE\Oracle11g\product\11.2.0\dbhome\network\admin\listener.ora
    # Generated by Oracle configuration tools.
    
    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = CLRExtProc)
          (ORACLE_HOME = H:\ORACLE\Oracle11g\product\11.2.0\dbhome)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:H:\ORACLE\Oracle11g\product\11.2.0\dbhome\bin\oraclr11.dll")
        )
      )
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = Win7)(PORT = 1521))
        )
      )
    
    ADR_BASE_LISTENER = H:\ORACLE\Oracle11g 
    tnsnames.ora:
    # tnsnames.ora Network Configuration File: H:\ORACLE\Oracle11g\product\11.2.0\dbhome\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.
    
    ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
        (CONNECT_DATA =
          (SID = CLRExtProc)
          (PRESENTATION = RO)
        )
      )
    
    SINHA =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = Win7)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = sinha.168.0.100)
        )
      )
    Thanks,
    Sourabh
  • 8. Re: Oracle R Enterprise installation ERROR: cannot copy dll file
    Sherry LaMonica Journeyer
    Currently Being Moderated
    Sourabh, exptroc is configured correctly in your database.

    As we discussed, in order for embedded R to work properly, Oracle Database must include the patch that fixes bug number 11678127. Oracle Databse 11.2.0.3 includes this fix. If you cannot upgrade to Oracle 11.2.0.3, you can use Oracle 11.2.0.1 or 11.2.0.2 if you install the patch that fixes bug number 11678127.

    Until you patch or upgrade, you can only use Oracle R Enterprise in non-embedded mode.

    Sherry

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points