Connecting to Oracle8i

Hi All,
I have a problem in connecting to oracle and here is the steps i’ve been
going through (i’m using the regular oracle8 client, not the instant
one):

  1. i installed the one-click ruby installer (ruby184-16p3 windows.exe)
  2. i installed the rails-1.0.0 framework using gem successfully
  3. i tried connecting to oracle using all possible combination in the
    database.yml file (in the DATABASE and the HOST entry) but failed with
    the nonexistent oci adapter (ActiveRecord::AdapterNotFound)
    exception, for example :
  • blank in DATABASE, full tns name entry in HOST, and vice versa
  • blank in HOST, sid name entry in DATABASE, and vice versa
  • both field with full tns name
  • both field with only sid name
  1. so i tried re-installing only the activerecord (1.13.2) using gem and
    also the latest oci8 driver (ruby-oci8-0.1.14-mswin32.rb) again, but now
    everytime i tried to setup a new application, or start the webrick
    server : ruby script/server, an alert saying ‘The procedure entry point
    OCILobClose could not be located in the dynamic link library OCI.dll’
    occured.
  2. Still hoping that other person encountered this problem, I googled
    and found some people said you have to make sure the ORACLE_HOME
    variable is set right, and also the ORACLE_HOME/bin is added to the PATH
    variable. So i tried that also but still the same error occured.
  3. I googled again, and someone said, put the OCI.dll from your
    ORACLE_HOME/bin to the same folder as the ruby.exe file. So i did that
    again, but still the same error occured.
  4. I posted this mail, hoping someone maybe have experienced the same
    problem like me and provide some solutions i can try…
  5. to be continued…

Thanks 4 your time,
Yusuf.

On 3/16/06, Yusuf [email protected] wrote:

exception, for example :
5. Still hoping that other person encountered this problem, I googled
and found some people said you have to make sure the ORACLE_HOME
variable is set right, and also the ORACLE_HOME/bin is added to the PATH
variable. So i tried that also but still the same error occured.
6. I googled again, and someone said, put the OCI.dll from your
ORACLE_HOME/bin to the same folder as the ruby.exe file. So i did that
again, but still the same error occured.
7. I posted this mail, hoping someone maybe have experienced the same
problem like me and provide some solutions i can try…
8. to be continued…

I think you need to install the Oracle DBI driver. You can read all
about DBI drivers here (search the page for Oracle):

http://ruby-dbi.rubyforge.org/

Curt

On 3/16/06, Yusuf [email protected] wrote:

occured.
5. Still hoping that other person encountered this problem, I googled
and found some people said you have to make sure the ORACLE_HOME
variable is set right, and also the ORACLE_HOME/bin is added to the PATH
variable. So i tried that also but still the same error occured.
6. I googled again, and someone said, put the OCI.dll from your
ORACLE_HOME/bin to the same folder as the ruby.exe file. So i did that
again, but still the same error occured.

Are you using the latest version of 8i, or something older like 8.0.5?
Someone on this list had a very similar problem a few months ago, and
I seem to recall it being solved by updating to a newer 8i client. If
all else fails, the InstantClient works very nicely. Heh.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs