Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.3k views
in Technique[技术] by (71.8m points)

macos - Installing ROracle on Mac OS X - what is needed from Oracle?

I tried to install ROracle today, after having managed to install RPostgreSQL and RMySQL on my Mac OS X. Unfortunately, the Oracle website drives me crazy. I just cannot figure out which minimum package I need to install in order to use ROracle. Intuitively I thought I just need a client and downloaded the instant client.

Is this enough? Where should I put the unzipped instant client? I also tried SQLDeveloper but my setup seems lack some Oracle installation seems still. If I start compiling anyway:

R CMD INSTALL Roracle.tar.gz 

I end up with the following error:

You must set the shell variable ORACLE_HOME to the directory where Oracle resides and re-run R CMD INSTALL e.g., (using 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 which location do you recommend? Setting up the compiler is not the problem here (at least so far :) )

Note I just want to connect to some database which is NOT on my system, so I really should just need a client (if ROracle allows for that).

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

If you need an Oracle client installation you should be able to use the Oracle Instant Client. For documentation and download see Instant Client Downloads for Mac OS X (Intel x86) . Depending on what type of client you need you have a list of choices there. The Basic Client is allways needed and you could add a supplemental package to it depending on your needs. The basic client will work for many.

Choose a location to for ORACLE_HOME (/Application/oracle/product/client/10.2) create a lib directory in that ORACLE_HOME/ unzip the basic client and put the dylib files in ORACLE_HOME/lib. ORACLE_HOME=/Application/oracle/product/client/10.2 DYLD_LIBRARY_PATH=$ORACLE_HOME/bin:$DYLD_LIBRARY_PATH PATH=$ORACLE_HOME/bin:$PATH

If you need a more complete client, check wich supplemental installation you need and add it to the $ORACLE_HOME that you build here. If you need jdbc, add the jdbc supplement, if you need sqlplus, add the sqlplus supplement. Make sure that executables go to $ORACLE_HOME/bin/


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...