# Oracle driver doesn't want to load

**URL:** <https://www.ruby-forum.com/t/oracle-driver-doesnt-want-to-load/90722>\
**Category:** Ruby\
**Created:** [March 31, 2007, 2:21pm UTC](https://www.ruby-forum.com/t/oracle-driver-doesnt-want-to-load/90722 "2007-03-31T14:21:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mary](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e99b99/32.png) [@mary](https://www.ruby-forum.com/u/mary)\
**Post date:** [March 31, 2007, 2:21pm UTC](https://www.ruby-forum.com/t/oracle-driver-doesnt-want-to-load/90722/1 "2007-03-31T14:21:50Z")

</div>

Hello,

I hope someone can give a hint what is going wrong here.

I have a Ruby program that connects to an Oracle database using the DBI  
module. This is the code for the connecting:

dbh = DBI.connect(“DBI:Oracle:db:host”, “user”, “pw”)

I would use the OCI8 driver, but only DBD::Oracle is installed here, and  
I won’t get OCI8 before Monday 😉

My program raises following exception while connecting that I don’t  
understand:

/usr/lib/ruby/vendor\_ruby/1.8/dbi.rb:344:in `load_driver': Could not load driver (no such file to load -- oracle) (DBI::InterfaceError) from /usr/lib/ruby/vendor_ruby/1.8/dbi.rb:227:in`\_get\_full\_driver’  
from /usr/lib/ruby/vendor\_ruby/1.8/dbi.rb:213:in `connect' from GeoDatabaseController.rb:35:in`connect\_to\_oracle’  
from GeoDatabaseController.rb:339:in `main’  
from GeoDatabaseController.rb:350

What is going wrong here? I have looked at dbi.rb for a while trying to  
understand, but I still have no clue.

Thanks,  
Maria

---

<div class="post-metadata">

**Author:** ![mary](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e99b99/32.png) [@mary](https://www.ruby-forum.com/u/mary)\
**Post date:** [April 1, 2007, 9:44am UTC](https://www.ruby-forum.com/t/oracle-driver-doesnt-want-to-load/90722/2 "2007-04-01T09:44:54Z")

</div>

On Sat, Mar 31, 2007 at 09:21:51PM +0900, Ma Ha wrote:

> I hope someone can give a hint what is going wrong here.
> 
> I have a Ruby program that connects to an Oracle database using the DBI  
> module. This is the code for the connecting:
> 
> dbh = DBI.connect(“DBI:Oracle:db:host”, “user”, “pw”)
> 
> I would use the OCI8 driver, but only DBD::Oracle is installed here, and  
> I won’t get OCI8 before Monday 😉

You can’t use Oracle from Ruby without ruby-oci8.

Even the DBD::Oracle module is supplied as part of the ruby-oci8  
package. (I  
don’t know if it’s _also_ included with some other package or available  
separately, but it definitely won’t work without ruby-oci8 being  
installed)

> /usr/lib/ruby/vendor\_ruby/1.8/dbi.rb:344:in `load_driver': Could not load driver (no such file to load -- oracle) (DBI::InterfaceError) from /usr/lib/ruby/vendor_ruby/1.8/dbi.rb:227:in`\_get\_full\_driver’

That implies to me that DBD::Oracle isn’t available either.

Anyway, your solution is to go install ruby-oci8 🙂

Brian.