Installing Oracle R Enterprise
3/20/2012 07:02:00 PM
Gönderen Mete Karar
Oracle has integrated popular statistical package R as a component of database's Advanced Analytics Option. Oracle R Enterprise comes with Big Data integrated too. It also can be installed separately to 11 R2 databases on Oracle Linux 5 64-bit and naturally to Exadata. I'll try to briefly explain how you can install it.
Prerequites:
1. If not already enabled, enable yum repos for Oracle. You can find out how from Oracle public yum site.
2. Install R
$ yum install R.x86_64
Installing Client on Windows:
1. Next thing to be done is installing client tool. Download R for Windows from R Project and install it.
2. Download Oracle R Enterprise Client Packages and Client Supporting Packages for Windows from OTN and unzip them.
3. To install packages; run R from All Programs as administrator, from the menu: Packages -> Install package(s) from local zip files:
a. Navigate to <unzip_dir>\ore-supporting-windows-1.0\bin\windows\contrib\2.13
b. Select; DBI_0.2-5.zip, png_0.1-4.zip and ROracle_1.1-1.zip
c. Click open:
package 'DBI' successfully unpacked and MD5 sums checked
package 'png' successfully unpacked and MD5 sums checked
package 'ROracle' successfully unpacked and MD5 sums checked
d. Repeat the step for client packages. Navigate to <unzip_dir>\ore-windows-1.0\bin\windows\contrib\2.13
e. Select; ORE_1.0.zip, OREbase_1.0.zip, OREeda_1.0.zip, OREgraphics_1.0.zip, OREstats_1.0.zip, ORExml_1.0.zip
f. Click open:
package 'ORE' successfully unpacked and MD5 sums checked
package 'OREbase' successfully unpacked and MD5 sums checked
package 'OREeda' successfully unpacked and MD5 sums checked
package 'OREgraphics' successfully unpacked and MD5 sums checked
package 'OREstats' successfully unpacked and MD5 sums checked
package 'ORExml' successfully unpacked and MD5 sums checked
Installing Server:
1. To install server download ore-server-linux-x86-64-1.0.zip from OTN.
2. Extract files
$ tar xzf ore-server-linux-x86-64-1.0.tar.gz
$ export R_HOME=/usr/lib64/R
$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
4. Install
$ cd ore-server-linux-x86-64-1.0/
$ ./install.sh
5. Enable R for the user:
SQL> grant rqrole to <user_name>
To connect your database through R run R client:
R> ore.connect(user="<user_name>", sid="<DB_SID>", host="<host_name>", password="<password>", port = 1521)
R> ore.sync
R> ore.attach()
R> ore.ls()
R> help(Startup)
Core Dumps After Upgrading Grid Infrastructure to 11.2.0.2
3/13/2012 11:52:00 AM
Gönderen Mete Karar
After upgrading Grid Infrastructure from 11.2.0.1 to 11.2.0.2 on a single instance, you may observe huge amount of increase in disk usage due to core dump creation. You will see that a directory named like core_123 created every 10 minutes in <Grid_Home>/log/<host_name>/diskmon.
There is a bug numbered 10283819 in MOS considers the problem , however no workaround is provided. There are two ways you can follow to handle situation. First one is upgrading to 11.2.0.3. And the other one is uninstalling 11.2.0.1 completely, even remove the empty home, and restart all Oracle services.