Forums | Admin Discussion Forums: open-discussion Start New Thread Nested Flat Threaded Ultimate Show 25 Show 50 Show 75 Show 100   By: Kubo Takehiro RE: How I install oci8 on Mac? [ reply ]   2005-10-24 14:34 > The instructions told me to just run make: Sorry. That is a documentation bug. > What syntax would I use to install it under > /opt/local > rather than > /usr/local > ? If the ruby is configured with --prefix=/opt/local, it is installed under /opt/local. By: Dan Bikle RE: How I install oci8 on Mac? [ reply ]   2005-10-23 22:07 Kubo, Thanks for the response. You offer excellent info. I did not run 'make install' The instructions told me to just run make: = How to make == Oracle Full Client (not Oracle Instant Client) 1. check the followings: - ruby and make (or nmake on MSVC) are in the environment variable PATH. - sqlplus runs correctly. 2. check library search path. If sqlplus runs correctly, the environments variables are okay in general. But if Oracle is 64-bit and ruby is 32-bit, make sure $ORACLE_HOME/lib32 in 32-bit library search path. (LD_LIBRARY_PATH_32 on Solaris, SHLIB_PATH on HP-UX PA-RISC.) 3. make and install gzip -dc ruby-oci8-0.1.xx.tar.gz | tar xvf - cd ruby-oci8-0.1.xx make # or nmake on MSVC. What syntax would I use to install it under /opt/local rather than /usr/local ? -Dan By: Kubo Takehiro RE: How I install oci8 on Mac? [ reply ]   2005-10-23 19:49 Did you run 'make install'? On my Linux box: $ make install ruby setup.rb install ---> lib mkdir -p /usr/local/lib/ruby/site_ruby/1.8/ install oci8.rb /usr/local/lib/ruby/site_ruby/1.8/ ---> lib/DBD mkdir -p /usr/local/lib/ruby/site_ruby/1.8/DBD ---> lib/DBD/OCI8 mkdir -p /usr/local/lib/ruby/site_ruby/1.8/DBD/OCI8 install OCI8.rb /usr/local/lib/ruby/site_ruby/1.8/DBD/OCI8 <--- lib/DBD/OCI8 <--- lib/DBD <--- lib ---> ext ---> ext/oci8 mkdir -p /usr/local/lib/ruby/site_ruby/1.8/i686-linux/. install oci8lib.so /usr/local/lib/ruby/site_ruby/1.8/i686-linux/. <--- ext/oci8 <--- ext By: Dan Bikle RE: How I install oci8 on Mac? [ reply ]   2005-10-22 22:31 To work around the problem, I did this: zmac11:/cd/rubythings/ruby-oci8-0.1.13/lib oracle$ ls ./ ../ DBD/ oci8.rb oci8.rb.in zmac11:/cd/rubythings/ruby-oci8-0.1.13/lib oracle$ tar cf - . | ( cd /opt/local/lib/ruby/site_ruby/1.8/; tar xvf -) zmac11:/cd/rubythings/ruby-oci8-0.1.13 oracle$ cd ext/oci8 zmac11:/cd/rubythings/ruby-oci8-0.1.13/ext/oci8 oracle$ ls ./ bind.c depend env.o handle.o oci8.o oranumber.o session.c ../ bind.o describe.c error.c lob.c oci8lib.bundle* param.c session.o MANIFEST const.c describe.o error.o lob.o oraconf.rb param.o stmt.c Makefile const.o descriptor.c extconf.h mkmf.log oradate.c post-config.rb stmt.o attr.c define.c descriptor.o extconf.rb oci8.c oradate.o server.c svcctx.c attr.o define.o env.c handle.c oci8.h oranumber.c server.o svcctx.o zmac11:/cd/rubythings/ruby-oci8-0.1.13/ext/oci8 oracle$ cp -p oci8lib.bundle /opt/local/lib/ruby/site_ruby/1.8/powerpc-darwin7.9.0/ zmac11:/cd/rubythings/ruby-oci8-0.1.13/ext/oci8 oracle$ I dont doing stuff like this by hand. I wish the Makefile would have done the right thing. -Dan By: Dan Bikle How I install oci8 on Mac? [ reply ]   2005-10-22 21:59 People, I'm having problems installing ruby-oci8-0.1.13 on my Mac. Here is a screen dump from Make: zmac11:~/CD/rubyThings/ruby-oci8-0.1.13 oracle$ make ruby setup.rb config ---> lib ---> lib/DBD ---> lib/DBD/OCI8 <--- lib/DBD/OCI8 <--- lib/DBD <--- lib ---> ext ---> ext/oci8 /opt/local/bin/ruby /Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8/extconf.rb setup.rb:476: warning: Insecure world writable dir /Users/oracle/CD, mode 040777 checking for gcc... yes checking for LP64... no Get the version of Oracle from SQL*Plus... 1010 try -I/Users/oracle/OraHome_5/rdbms/demo checking for oci.h... no try -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public checking for oci.h... yes checking for OCIInitialize()... yes checking for OCIEnvCreate()... yes checking for OCITerminate()... yes checking for OCIServerRelease()... yes checking for OCILobOpen()... yes checking for OCILobClose()... yes checking for OCILobGetChunkSize()... yes checking for OCILobLocatorAssign()... yes creating ../../lib/oci8.rb from /Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8/../../lib/oci8.rb.in creating extconf.h creating Makefile <--- ext/oci8 <--- ext ruby setup.rb setup ---> lib ---> lib/DBD ---> lib/DBD/OCI8 <--- lib/DBD/OCI8 <--- lib/DBD <--- lib ---> ext ---> ext/oci8 make setup.rb:476: warning: Insecure world writable dir /Users/oracle/CD, mode 040777 gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c oci8.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c handle.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c const.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c env.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c error.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c svcctx.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c server.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c session.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c stmt.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c define.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c bind.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c describe.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c descriptor.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c param.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c lob.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c oradate.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c oranumber.c gcc -fno-common -O -pipe -I/opt/local/include -fno-common -pipe -fno-common -I/Users/oracle/OraHome_5/rdbms/demo -I/Users/oracle/OraHome_5/rdbms/public -Wall -I. -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/opt/local/lib/ruby/1.8/powerpc-darwin7.9.0 -I/Users/oracle/CD/rubyThings/ruby-oci8-0.1.13/ext/oci8 -O -pipe -I/opt/local/include -c attr.c cc -dynamic -bundle -undefined suppress -flat_namespace -L/opt/local/lib -L"/opt/local/lib" -o oci8lib.bundle oci8.o handle.o const.o env.o error.o svcctx.o server.o session.o stmt.o define.o bind.o describe.o descriptor.o param.o lob.o oradate.o oranumber.o attr.o -lruby -L/Users/oracle/OraHome_5/lib -lclntsh -lpthread -ldl -lobjc <--- ext/oci8 <--- ext zmac11:~/CD/rubyThings/ruby-oci8-0.1.13 oracle$ ruby -r oci8 -e 'OCI8.new("scott", "tiger", "d6").exec("select sysdate from dual") do |r| puts r.join(","); end' ruby: No such file to load -- oci8 (LoadError) zmac11:~/CD/rubyThings/ruby-oci8-0.1.13 oracle$ which ruby /opt/local/bin/ruby zmac11:~/CD/rubyThings/ruby-oci8-0.1.13 oracle$ cd /opt/local zmac11:/opt/local oracle$ find . -name oci8.rb -print zmac11:/opt/local oracle$ The Make seemed to work okay but I dont think it did the right thing. I was expecting make to put oci8.rb somewhere in the LOADPATH. Can anyone give me any clues? -Dan