Connecting to Oracle8i

Rails
1

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.

2

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

3

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.