# Oracle-oci8.2.0 **URL:** \ **Category:** Ruby\ **Created:** [November 30, 2009, 12:08pm UTC](https://www.ruby-forum.com/t/oracle-oci8-2-0/179609 "2009-11-30T12:08:51Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![vetrivel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/dc4da7/32.png) [@vetrivel](https://www.ruby-forum.com/u/vetrivel)\ **Post date:** [November 30, 2009, 12:08pm UTC](https://www.ruby-forum.com/t/oracle-oci8-2-0/179609/1 "2009-11-30T12:08:51Z")
Problem in oci8.2.0.1.gem I installed oci8 using gem1.8 command . Then i required that file using oci8.But I got the error . require ‘oci8’ LoadError: /usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.7-x86-mswin32-60/ext/oci8/oci8lib.so: invalid ELF header - /usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.7-x86-mswin32-60/ext/oci8/oci8lib.so from /usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.7-x86-mswin32-60/ext/oci8/oci8lib.so from /usr/local/lib/site\_ruby/1.8/rubygems/custom\_require.rb:31:in `require' from /usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.7-x86-mswin32-60/lib/oci8.rb:20 from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:36:in`gem\_original\_require’ from /usr/local/lib/site\_ruby/1.8/rubygems/custom\_require.rb:36:in `require’ from (irb):3 ---
**Author:** ![vetrivel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/dc4da7/32.png) [@vetrivel](https://www.ruby-forum.com/u/vetrivel)\ **Post date:** [November 30, 2009, 1:27pm UTC](https://www.ruby-forum.com/t/oracle-oci8-2-0/179609/2 "2009-11-30T13:27:15Z")
On Nov 30, 8:08 am, Vetrivel V. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > ``` > from > from (irb):3 > > ``` > > – You installed a Windows binary gem on a Linux operating system: “x86-mswin32-60” is the platform of the gem. Please check the project page of the gem and look for build instructions for Linux. [http://ruby-oci8.rubyforge.org/en/](http://ruby-oci8.rubyforge.org/en/) ---
**Author:** ![vetrivel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/dc4da7/32.png) [@vetrivel](https://www.ruby-forum.com/u/vetrivel)\ **Post date:** [November 30, 2009, 2:43pm UTC](https://www.ruby-forum.com/t/oracle-oci8-2-0/179609/3 "2009-11-30T14:43:06Z")
Luis L. wrote: > On Nov 30, 8:08�am, Vetrivel V. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) > wrote: > > > ## � � � � from � � � � from (irb):3 > > You installed a Windows binary gem on a Linux operating system: > > “x86-mswin32-60” is the platform of the gem. > > Please check the project page of the gem and look for build > instructions for Linux. > > [http://ruby-oci8.rubyforge.org/en/](http://ruby-oci8.rubyforge.org/en/) Thanks for your reply. But I have installed gem1.8 install ruby-oci8-1.0.6.gem Successfully installed ruby-oci8-1.0.6 1 gem installed Installing ri documentation for ruby-oci8-1.0.6… Installing RDoc documentation for ruby-oci8-1.0.6… require ‘oci8’ . I got following errors . LoadError: /usr/local/lib/site\_ruby/1.8/i486-linux/oci8lib.so: invalid ELF header - /usr/local/lib/site\_ruby/1.8/i486-linux/oci8lib.so from /usr/local/lib/site\_ruby/1.8/i486-linux/oci8lib.so from /usr/local/lib/site\_ruby/1.8/rubygems/custom\_require.rb:31:in `require' from /usr/local/lib/site_ruby/1.8/oci8.rb:20 from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem\_original\_require’ from /usr/local/lib/site\_ruby/1.8/rubygems/custom\_require.rb:31:in `require’ from (irb):2 ---
**Author:** ![vetrivel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/dc4da7/32.png) [@vetrivel](https://www.ruby-forum.com/u/vetrivel)\ **Post date:** [November 30, 2009, 5:05pm UTC](https://www.ruby-forum.com/t/oracle-oci8-2-0/179609/4 "2009-11-30T17:05:40Z")
On Nov 30, 10:43 am, Vetrivel V. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Installing ri documentation for ruby-oci8-1.0.6… > from > /usr/local/lib/site\_ruby/1.8/rubygems/custom\_require.rb:31:in > `gem_original_require' from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:31:in `require’ > from (irb):2 Somehow you have a oci8lib.so inside your site\_ruby, which indicates something got installed as extension inside your Ruby installation and not as a gem. Please check back any previous attempt of installation of OCI8 you tried in your system, or check your Linux distribution for a package OCI for Ruby, which could be interfering. Without more information about your environment, how you reached that point, what distro of linux, how you installed Ruby and so on, we can’t help you. Help us help you. ---
**Author:** ![vetrivel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/dc4da7/32.png) [@vetrivel](https://www.ruby-forum.com/u/vetrivel)\ **Post date:** [December 1, 2009, 6:48am UTC](https://www.ruby-forum.com/t/oracle-oci8-2-0/179609/5 "2009-12-01T06:48:19Z")
Luis L. wrote: > On Nov 30, 10:43�am, Vetrivel V. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) > wrote: > > > Installing ri documentation for ruby-oci8-1.0.6… > > � � � � from > > /usr/local/lib/site\_ruby/1.8/rubygems/custom\_require.rb:31:in > > `gem_original_require' � � � � from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:31:in `require’ > > � � � � from (irb):2 > > Somehow you have a oci8lib.so inside your site\_ruby, which indicates > something got installed as extension inside your Ruby installation and > not as a gem. > > Please check back any previous attempt of installation of OCI8 you > tried in your system, or check your Linux distribution for a package > OCI for Ruby, which could be interfering. > > Without more information about your environment, how you reached that > point, what distro of linux, how you installed Ruby and so on, we > can’t help you. > > Help us help you. Thanks for your help , ``` I have written a simple program to connect with oracle . But ``` I faced the below error . In this program i have mentioned the gem path . So I am saying that , it is taking from the /usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.5/lib path . The program $LOAD\_PATH.unshift(“/usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.5/lib/”) require ‘oci8’ $LOAD\_PATH.unshift(“/usr/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/”) require ‘dbi’ ; dbd\_dr = DBI::DBD.const\_get(:OCI8) dbd\_dr::Driver.new DBI.connect(‘dbi:OCI8:database\_name:20.1.65.132:1521’, ‘username’, ‘password’) But I got following error env.c:257:in oci8lib.so: ORA-12154: TNS:could not resolve the connect identifier specified (DBI::DatabaseError) from /usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.5/lib/oci8.rb:229:in `initialize' from /usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.5/lib/dbd/OCI8.rb:182:in `new’ from /usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.5/lib/dbd/OCI8.rb:182:in `connect' from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/dbi/handles/driver.rb:33:in `connect’ from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/dbi.rb:143:in `connect’ from test.rb:13 Then I tried like this OCI8.new(“username”,“password”,‘//ipaddress:port’,:SYSDBA) ; But I got below error server.c:48:in oci8lib.so: ORA-12504: TNS:listener was not given the SERVICE\_NAME in CONNECT\_DATA (OCIError) from /usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.5/lib/oci8.rb:219:in `initialize' from /usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.5/lib/oci8.rb:142:in `do\_ocicall’ from /usr/lib/ruby/gems/1.8/gems/ruby-oci8-1.0.5/lib/oci8.rb:219:in `initialize' from test.rb:14:in `new’ from test.rb:14 I am using ruby1.8