Oracle-oci8.2.0

V

Vetrivel Vetrivel

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
 
L

Luis Lavena

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
--

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/
 
V

Vetrivel Vetrivel

Luis said:
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/



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
 
L

Luis Lavena

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

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.
 
V

Vetrivel Vetrivel

Luis said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,780
Messages
2,569,611
Members
45,284
Latest member
NicholeDum

Latest Threads

Top