2 Replies Latest reply: Jan 27, 2013 6:48 PM by Joshua Davis RSS

    ore.connect gives me ORA-06512: at "RQSYS.RQEVALIMPL", line 47

    Joshua Davis
      I am installing Oracle Enterprise R, and I am at the "Start the Oracle R Enterprise Client on Linux" step in the installation guide. My output is as follows:
      $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
      $ore.connect(user="josh", sid="orcl", host="cascade", password=********, port=1521, all=TRUE)
      Loading required package: ROracle
      Loading required package: DBI
      Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch, :
      ORA-20000: RQuery internal error [rqetPrepare, 2, 24323, 0]
      ORA-06512: at "RQSYS.RQEVALIMPL", line 47
      ORA-06512: at "RQSYS.RQEVALIMPL", line 43
      ORA-06512: at line 4
      I looked at the code for RQSYS.RQEVALIMPL, and line 47 is the start of a static function called StubTablePrepare, which looks like it is calling rqetNilPrepare from rqeLib. I doublechecked, and my $LD_LIBRARY_PATH contains librqe.so, and librqe.so contains a function named rqetNilPrepare.

      It's entirely possible I missed a step while installing, but I'm not sure what it could be. Is there a way that I can get more detailed diagnostics that tells me why StubTablePrepare seems to be failing?

      Here is my environment details:
      Oracle version: 11.2.0.1.0 Enterprise Edition for Linux x64
      R version: Oracle Distribution of R version 2.15.1 (--) -- "Roasted Marshmallows"
      Oracle Enterprise R version: 1.3_R_x86_64

      The client is installed on the same machine as the server. I can connect to the database as the user "josh" through SQL Developer. The user "josh" has the following grants:
      EXECUTE ANY PROCEDURE
      CREATE TABLE
      EXECUTE ANY TYPE
      CREATE SESSION
      CREATE MINING MODEL
      CREATE PROCEDURE
      CREATE SEQUENCE
      CREATE VIEW
      RQADMIN
      CONNECT
      EXECUTE ON RQSYS.RQEVALIMPL

      Thanks,
      Josh Davis