Geek Answers Handbook

Installing ROracle on Mac OS X - What Does Oracle Need?

I tried installing ROracle today, after I managed to install RPostgreSQL and RMySQL on my Mac OS X. Unfortunately, the Oracle website is driving me crazy. I just can't figure out what minimum package I need to install in order to use ROracle. Intuitively, I thought I just needed a client and downloaded the instant client.

is that enough? Where should I put an unzipped instant client? I also tried SQLDeveloper, but it seems to me that I don't have some kind of Oracle installation. If I start compiling anyway:

R CMD INSTALL Roracle.tar.gz

I get the following error:

You must set the ORACLE_HOME shell variable in the directory where Oracle is located and re-starts R CMD INSTALL for example, (using the Bourne shell syntax):

  export ORACLE_HOME=/opt/oracle
  R CMD INSTALL ROracle

So my simple question is: which package do I need to install and what location do you recommend? Setting the compiler is not a problem here (at least so far :))

Note. I just want to connect to some database that DOES NOT belong to my system, so I really only need a client (if ROracle does this).

+2
source share
1 answer

Oracle, Oracle Instant Client. . Mac OS X (Intel x86). , , . , . .

ORACLE_HOME (/Application/oracle/product/client/10.2) lib , ORACLE_HOME/ dylib ORACLE_HOME/lib. ORACLE_HOME =/////10.2 DYLD_LIBRARY_PATH = $ORACLE_HOME/: $DYLD_LIBRARY_PATH PATH = $ORACLE_HOME/: $PATH

, , , $ORACLE_HOME, . jdbc, jdbc, sqlplus, sqlplus. , $ORACLE_HOME/bin/

+3

More articles:


All Articles