Luis Lavena 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
···
On Nov 30, 10:43�am, Vetrivel Vetrivel <vetrivel.bk...@gmail.com> > wrote:
--
Posted via http://www.ruby-forum.com/\.