Forum Stats

  • 3,757,774 Users
  • 2,251,265 Discussions
  • 7,869,914 Comments

Discussions

how to check version of ORE installed in the Oracle database

Kevin Zhang
Kevin Zhang Member Posts: 251 Bronze Badge
edited Sep 20, 2017 2:55PM in R Technologies

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

Christos Iraklis Tsatsoulis

Best Answer

  • rtiran
    rtiran Member Posts: 74 Bronze Badge
    edited Sep 15, 2017 5:08AM Accepted Answer

    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

    Christos Iraklis Tsatsoulis

Answers

  • rtiran
    rtiran Member Posts: 74 Bronze Badge
    edited Sep 15, 2017 5:08AM Accepted Answer

    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

    Christos Iraklis Tsatsoulis
  • Kevin Zhang
    Kevin Zhang Member Posts: 251 Bronze Badge
    edited Sep 15, 2017 7:43AM

    Hi Raphaël:

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

    Regards,

    Kevin Zhang

  • Sherry Lamonica-Oracle
    Sherry Lamonica-Oracle Posts: 437 Employee
    edited Sep 20, 2017 12:52PM

    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
  • Kevin Zhang
    Kevin Zhang Member Posts: 251 Bronze Badge
    edited Sep 20, 2017 2:55PM

    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

This discussion has been closed.