Skip to Main Content
Forums

Data Science & Machine Learning

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error in .ore.odm.chk.dbver() : DB version 19.0 is not supported

Penny CooksonAug 2 2020 — edited Sep 9 2020

Hi

We are evaluating Oracle R In a proof of concept R environment:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.7.0.0.0

MS Windows server on Azure.

Connection is to a Pluggable database.

Oracle Distribution of R version 3.3.0 (2016-05-03)

ORE odm version 1.5.1

A number of the ore.odm functions result in the error:

Error in .ore.odm.chk.dbver() : DB version 19.0 is not supported

see examples below

Can you tell me whether this is expected, and if so when a version of the packages that works with DB 19 will be available, will this work with the Oracle R 3.6.1 release coming soon?

and if it is not expected is there something obvious we have done wrong?

Regards

Penny Cookson

Example:

data(titanic3, package = "PASWR")

t3 <- ore.push(titanic3)

t3$survived <- ifelse(t3$survived ==1, "Yes", "No")

n.rows <- nrow(t3)

set.seed(seed = 6218945)

random.sample <- sample(1:n.rows,

                        ceiling(n.rows/2))

t3.train <- t3[random.sample,]

t3.test <- t3[setdiff(1:n.rows, random.sample),]

priors <- data.frame(

TARGET_VALUE = c("Yes","no"),

PRIOR_PROBABILITY = c(0.1, 0.9))

nb <- ore.odmNB(survived ~ pclass + sex + age + fare + embarked,

                t3.train, class.priors = priors)

Error in .ore.odm.chk.dbver() : DB version 19.0 is not supported

Example 2:

example("ore.odmAI")

or.dAI>   IRIS <- ore.push(iris)

or.dAI>   ore.odmAI(Species ~ ., IRIS)

Error in .ore.odm.chk.dbver() : DB version 19.0 is not supported

Comments

Hi Penny,

This is a known issue.  Please connect with me directly for the fix.

Thank you,

Sherry

Hasnur Ramadhan

Hi Sherry,

Error in .ore.odm.chk.dbver() : DB version 19.0 is not supported

---

How to connect with you directly to get the fix?

Currently I am doing a POC using ORE Oracle 19c for a prospective customer.

TIA.

Hasnur R.

Hasnur Ramadhan

Solved with Oracle R Distribution 3.6.1, and re-download OML for R library 1.5.1 (the latest one, dated August 24, 2020).

1 person found this helpful
Sherry Lamonica-Oracle

Thank you for the update, Hasnur. Oracle R Distribution 3.6.1 is now available.  Refer to this blog post for details and a pointer to installation instructions with Oracle Machine Learning for R 1.5.1, which contains the fix for the OREdm bug discussed in this thread.

Sherry

1 person found this helpful
1 - 4

Post Details

Added on Aug 2 2020
#r-technologies
4 comments
556 views