how to check version of ORE installed in the Oracle database

Kevin Zhang

Hi All:

I am using Oracle BigDataLite VM4.7 and the VM is already has Oracle R Enterprise (ORE) installed in the database 12c packaged with this VM.

My question is: what command I can run (either in database or R) to tell me the version of the ORE that has been installed?

I am looking for a systematic way to confirm/check the version of the ORE.

Thanks!

Kevin

rtiran

Hi Kevin,

there are several ways that I'm aware of:

• from the shell on the database server:

[email protected]: /home/oracle [HODBA04D1_1]# ORE --version | head -1

Oracle Distribution of R version 3.2.0  (--) -- "Full of Ingredients"

[email protected]: /home/oracle [HODBA04D1_1]#

• from within ORE (on the database server):

> version$version.string

[1] "Oracle Distribution of R version 3.2.0  (--)"

>

or

> paste(version$major,".",version$minor,sep="")

[1] "3.2.0"

>

• from an R client (Open source R or Oracle R Distribution) connected to database server with ore.connect:

> ore.doEval(function() print(paste(version$major,".",version$minor,sep="")))

[1] "3.2.0"

>

or

> ore.doEval(function() print(version$version.string))

[1] "Oracle Distribution of R version 3.2.0  (--)"

>

Also, to get ORE package version:

> packageVersion("ORE")

[1] ‘1.5’

>

Regards,

Raphaël

rtiran

Hi Kevin,

there are several ways that I'm aware of:

• from the shell on the database server:

[email protected]: /home/oracle [HODBA04D1_1]# ORE --version | head -1

Oracle Distribution of R version 3.2.0  (--) -- "Full of Ingredients"

[email protected]: /home/oracle [HODBA04D1_1]#

• from within ORE (on the database server):

> version$version.string

[1] "Oracle Distribution of R version 3.2.0  (--)"

>

or

> paste(version$major,".",version$minor,sep="")

[1] "3.2.0"

>

• from an R client (Open source R or Oracle R Distribution) connected to database server with ore.connect:

> ore.doEval(function() print(paste(version$major,".",version$minor,sep="")))

[1] "3.2.0"

>

or

> ore.doEval(function() print(version$version.string))

[1] "Oracle Distribution of R version 3.2.0  (--)"

>

Also, to get ORE package version:

> packageVersion("ORE")

[1] ‘1.5’

>

Regards,

Raphaël

Kevin Zhang

Hi Raphaël:

Thanks for the help! I believe the "packageVersion("ORE")" is what I am looking for.

Regards,

Kevin Zhang

Sherry Lamonica-Oracle

Kevin,

One can also find this information in SQL:

SQL> select * from sys.rq_config;

NAME

--------------------------------------------------------------------------------

VALUE

--------------------------------------------------------------------------------

R_HOME

/usr/lib64/R

R_LIBS_USER

/u01/app/oracle/product/12.1.0.2/dbhome_1/R/library

VERSION

1.5

....

Sherry

Kevin Zhang

Hi Sherry:

I like your solution best given this is directly queried from DB.

FYI: below is from my BigDataLite VM V4.7.0 ....

SQL> select * from sys.rq_config;  
NAME                       VALUE 
------------------------- --------------------------------------------- 
R_HOME            /usr/lib64/R 
R_LIBS_USER       /u01/app/oracle/product/12.1.0.2/dbhome_1/R/library 
VERSION           1.5 
MIN_VSIZE         32M 
MAX_VSIZE         4G 
MIN_NSIZE         2M 
MAX_NSIZE         20M  


7 rows selected. 

Thank you!

Kevin