[Locomotive-users] OCI and Locmotive

[Lori M Olson]

It's been a while since I did the original install, so I'll try...

I installed the instant client before I ever installed locomotive, so  
it wasn't in my locobundle.  Not sure if that makes a difference.   
Make certain that sqlplus from the Instant client is working before  
attempting to do anything else.  If sqlplus doesn't work, then  
nothing else will.

 From our internal development wiki, I have these notes on installing  
the instant client:

Add the instantclient directory to your PATH.
Add the instantclient directory to DYLD_FALLBACK_LIBRARY_PATH
Create an environment variable called SQLPATH and point it at the  
instant client directory
If you want to use tnsnames.ora then:

create a tnsnames.ora or get a copy of one
place it in your home directory
Create an environment variable called TNS_ADMIN, and point it at your  
home directory
At this point, you should be able to use sqlplus, and connect to any  
database in your tnsnames.ora file

Ok, now on to OCI8.  You are installing an old version.  ruby- 
oci8-0.1.13.tar.gz.  There were serious Rails problems with older  
versions.  I recommend that you download the most recent release -  
0.1.16.

sudo ruby setup.rb config -- --with-instant-client=<this points to  
the instant client DIRECTORY, not a file>

Try this, and see if it works.

Regards, Lori

On 10-Oct-06, at 12:51 PM, Phillip Novess wrote:

> So I've installed Instant Client in Bundles/ 
> standardRailsSept2006.locobundle/powerpc/lib
>
> I've downloaded ruby-oci8-0.1.13.tar.gz. Un-tared it. cd into the  
> directory. I ran:
>
> ruby setup.rb config -- --with-instant-client=/Users/pnovess/ 
> Desktop/Locomotive2/Bundles/standardRailsSept2006.locobundle/ 
> powerpc/lib/libclntsh.dylib.10.1
>
> And I get
>
> can't find header files for ruby.
> 'system /usr/bin/ruby /Users/pnovess/Desktop/Locomotive2/ruby- 
> oci8-0.1.13/ext/oci8/extconf.rb --with-instant-client=/Users/ 
> pnovess/Desktop/Locomotive2/Bundles/ 
> standardRailsSept2006.locobundle/powerpc/lib/libclntsh.dylib.10.1'  
> failed
>
> What do I do now?
>
> Thanks,
> Phillip Novess
> http://primalart.net
>
>
>
>
>
> On Oct 9, 2006, at 2:00 PM, Lori M Olson wrote:
>
>> I set everything up on a Powerbook, using a PPC Locomotive  
>> bundle.  That bundle can then be used on a PPC or Intel Mac,  
>> through the magic of Rosetta, because the entire bundle, ruby and  
>> everything, is compiled as PPC, which it has to be, since Oracle  
>> hasn't released Intel Mac binaries.
>>
>> On 9-Oct-06, at 12:20 PM, Phillip Novess wrote:
>>
>>> Has anyone worked with an Oracle DB using Locomotive? If so how  
>>> do you set it up?
>>>
>>> Thanks,
>>> Phill
>>>
>>>
>>>
>>> _______________________________________________
>>> Locomotive-users mailing list
>>> Locomotive-users at lists.raaum.org
>>> http://lists.raaum.org/mailman/listinfo/locomotive-users
>>
>> _______________________________________________
>> Locomotive-users mailing list
>> Locomotive-users at lists.raaum.org
>> http://lists.raaum.org/mailman/listinfo/locomotive-users
>
> _______________________________________________
> Locomotive-users mailing list
> Locomotive-users at lists.raaum.org
> http://lists.raaum.org/mailman/listinfo/locomotive-users