Installing Oracle R on Database VM Image

Download the Oracle Pre-Built Database Developer VMs from OTN.image
Import the extracted VM into Virtual Box and bootup the Virtual Machine. After starting the VM, the following screen is presented witin Virtual Box:
image
check the Linux Version of the Downloaded Virtual Machine with below command:

# uname -r

For this VM it is: 4.1.12-61.1.27.el7uek.x86_64, thus: Oracle Enterprise Linux 7.

Install R (distribution) for Oracle R Enterprise

Afterwards, switch user to root (Password is “oracle”) and navigate to the yum Repository configuration:
image
using the vi (i command for – – inserting- – Mode and Esc for exiting the insert Mode, save with :wq) update the following sections within the repo file:

[ol7_latest]
enabled=1

[ol7_addons]
enabled=1
[ol7_optional_latest]
enabled=1

e.g.:
image
Install R with the following command
image
this automatically downloads and performs the installation:
image
image
image

Installing Oracle R Enterprise Server

Add the Oracle Home Lib to the Library Path environment variable:
image
This can also be added to the ~/.bashrc
image
As next step, download the Oracle R Enterprise software from OTN.
image
And store to a installation directory e.g. /u01/ORE_Inst_Dir
image
and unzip the files:
image
Start the installation by running the installer:
image

Installing Oracle R Client

Unzip the Client zip files:
image
switch to root user and install all unzipped files:
image
Start Oracle R Client with the ORE command and load the Oracle R libaries with library(ORE). When loading the R libaries, the following error is thrown:

Loading required package: OREembed
Error in dyn.load(file, DLLpath = DLLpath, …) :
   unable to load shared object ‘/u01/app/oracle/product/12.1.0.2/db_1/R/library/png/libs/png.so’:
   libpng12.so.0: cannot open shared object file: No such file or directory
Error: package ‘OREembed’ could not be loaded


image

Since, the file libpng12.so.0 is not available it needs to be installed:
image
image
[Thanks to the following article which features the same issue]

After installing the missing file, the ORE Libaries are loaded successfully within R:
image

Further references:

http://rajiv-kuriakose.blogspot.de/2016/03/how-to-install-oracle-r-enterprise-on.html

Official Oracle Documentation:

https://docs.oracle.com/cd/E57012_01/doc.141/e57007/install_oreserver.htm#BGBJIIAG

Advertisements

Oracle BI 12c: fixing wlst.sh installation issue

While trying to install Oracle BI 12c we were facing an Issue during the Configuration of the Oracle BI Domain on the Weblogic Server. This is typically the last step of the Installation where the Domain is configured and started.

During the Installation we received the following Error Message:

BI Configuration
Error
Config Action BI Configuration failed

Configure BI Failed with Execution of [/opt/biee/oracle_common/common
/bin/wlst.sh, /opt/biee/bi/modules/oracle.bi.configassistant/
complete_domain.py,
/opt/biee, /opt/biee/user_projects/domains/bi, weblogic, Expanded,
serverhostname.lasg, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver,
jdbc:oracle:thin:@//hostname:1521/DBservice.world, DEV,
jdbc:oracle:thin:@//hostname:1521/DBservice.world, ]
failed with exit value 1

When checking the detailed log files at the following location:

/home/Linuxuser/oraInventory/logs/config2017-03-06_03-26-26PM/biee.log

The log file also didn’t reveal much more:

Failed single shot step: Complete domain with: Execution of [/opt/
biee/oracle_common/common/bin/wlst.sh, /opt/biee/bi/modules/oracle.bi.
configassistant/complete_domain.py, /opt/biee, /opt/biee/user_project
s/domains/bi, weblogic, Expanded, serverhostname.lasg, 9502, 9503,
ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//hostname:1530/
DBservice.world, DEV, jdbc:oracle:thin:@//hostname:1530/DBservice.
world, ] failed with exit value 1

After verifying that the ports are not blocked by the firewall we found some similar Issue with the Oracle BI 12c Installation. By adding the following Parameter to the wlst.sh file we were able to fix this Issue, too.

JVM_ARGS="<strong>-Djava.security.egd=file:///dev/urandom</strong>
${WLST_PROPERTIES} ${JVM_D64} ${UTILS_MEM_ARGS} ${CONFIG_JVM_ARGS}"

<span style="font-family: Courier New;">if [ -d "${JAVA_HOME}" ]; then
eval '"${JAVA_HOME}/bin/java"' ${JVM_ARGS} weblogic.WLST '"$@"'
else
exit 1
fi

image

After deleting the Domain Installation files within the User Project (Domain Folder):

e.g. /opt/biee/user_projects/domains/bi

And dropping the Internal Repository Tables using the RCU routine the Domain Installation step “Configure Domain” succeeded without the above error.

image