This discussion is archived
7 Replies Latest reply: Apr 10, 2012 6:56 PM by Sherry LaMonica RSS

problem with Oracle R install

740052 Newbie
Currently Being Moderated
i have installed the Oracle R packages on one of my machines and am getting the error below. it seems to mostly work but when doing class(IRIS_TABLE) i get object nor found. also the NARROW table is not installed in the RQUSER that was created... i followed all of the instructions in the install guide...

bill,

demo(basic)
demo(basic)
---- ~~~~~

Type <Return> to start :
#
# O R A C L E R E N T E R P R I S E S A M P L E L I B R A R Y
#
# Name: basic.R
# Description: Demonstrates basic connectivity to database
#
#
#

## Set page width
options(width = 80)
# List all accessible tables and views in the Oracle database
ore.ls()
character(0)
# Create a new table called IRIS_TABLE in the Oracle database
# using the built-in iris data.frame

# First remove previously created IRIS_TABLE objects from the
# global environment and the database
if (exists("IRIS_TABLE", globalenv(), inherits = FALSE))
+ rm("IRIS_TABLE", envir = globalenv())
ore.drop(table = "IRIS_TABLE")
# Create the table
ore.create(iris, table = "IRIS_TABLE")
# Show the updated list of accessible table and views
ore.ls()
[1] "IRIS_TABLE"
# Display the class of IRIS_TABLE and where it can be found in
# the search path
class(IRIS_TABLE)
Error in eval.with.vis(expr, envir, enclos) :
object 'IRIS_TABLE' not found
  • 1. Re: problem with Oracle R install
    Sherry LaMonica Journeyer
    Currently Being Moderated
    Hi Bill,

    This a bug in the 'basic' demo. Thank you for bringing this problem to our attention. Fortunately, it's easy to fix the error.
    You must first attach the database to provide access to views and tables, so they can be manipulated from a local R session.

    Here is the revised code:

    ore.create(iris, table = "IRIS_TABLE")
    ore.attach() # attach the database
    class(IRIS_TABLE)
    [1] "ore.frame"
    attr(,"package")
    [1] "OREbase


    I hope this helps!

    Best Regards,

    Sherry
  • 2. Re: problem with Oracle R install
    Denis Mukhin Journeyer
    Currently Being Moderated
    Bill,

    Alternatively, you could have done ore.attach() before running the demo. Then the attach after ore.create() is not needed since ore.create() re-attaches the environment but only if has been attached before. In general the assumption is that before running the demo you have done ore.connect(), ore.sync() and ore.attach(). In the next release we will try to clarify the assumptions and make the demos more robust for the cases where those assumptions are not met. Thank you for reporting this problem.

    Denis
  • 3. Re: problem with Oracle R install
    740052 Newbie
    Currently Being Moderated
    awesome guys, works like a charm. i was just worried i had messed something up in the install...

    ty again! sure i will have more questions at some point ;)

    bill,
  • 4. Re: problem with Oracle R install
    740052 Newbie
    Currently Being Moderated
    i ran into another another error and wonder if it is related. i was running the crosstab demo
    demo(crosstab)
    ...
    x = x[, c("Petal.Length", "Species", "ORE$FREQ")]
    Error in x[, c("Petal.Length", "Species", "ORE$FREQ")] :
    undefined columns selected

    is there something i can run to grant permissions that are missing? is it related?

    ty!

    bill waddington,
  • 5. Re: problem with Oracle R install
    Sherry LaMonica Journeyer
    Currently Being Moderated
    Hi Bill,

    Can you post the output returned after running these commands at the R console?

    x
    names(x)

    This will help us narrow down the cause of the error you are seeing.

    Best Regards,

    Sherry
  • 6. Re: problem with Oracle R install
    740052 Newbie
    Currently Being Moderated
    here is what i get

    x
    Species ORE$FREQ ORE$STRATA ORE$GROUP
    1 setosa 73.1 1 1
    2 versicolor 213.0 1 1
    3 virginica 277.6 1 1
    names(x)
    [1] "Species" "ORE$FREQ" "ORE$STRATA" "ORE$GROUP"

    bill,
  • 7. Re: problem with Oracle R install
    Sherry LaMonica Journeyer
    Currently Being Moderated
    Hi Bill,

    The behavior you are seeing is a bug in the Oracle R Enterprise 1.0 crosstab demo script, which has been fixed for Oracle R Enterprise 1.1.
    As we discussed, I sent you the updated crosstab demo script, which runs to completion in either version.

    Let us know if you have questions with the Oracle R Enterprise server installation.

    Best Regards,

    Sherry

Legend

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