From: KUBO Takehiro <kubo@...>
Date: 2007-02-08T01:49:44+09:00
Subject: Re: ActiveRecord/Oracle without Rails

Hi,

On 2/8/07, Drew Olson <olsonas@gmail.com> wrote:
>
> ActiveRecord::Base::establish_connection(
>   :adapter=>"oci",
>   :host=>"hostaddress/schema",

It is not 'schema' but 'service_name'.
If your target database is Oracle Express Edition, it is 'XE'.

   :host=>"hostaddress/XE",

> c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:184:in `logon': ORA-12514:
> TNS:listener d
> oes not currently know of service requested in connect descriptor

The hostaddress's TNS listener doesn't know the service name.