Re: Best Way to Access remote Oracle 10.2.0.1.0 DB from a Linux server

On Nov 19, 12:48 am, Lodewicus Maas <linux.oracle...._at_googlemail.com> wrote:
> Johan wrote:
> > I want to use a perl or unix script running on a linux server to
> > access an Oracle v. 10.2.0.1.0 database on a remote machine, and
> > process the output with the script. What is the best way to do this?
> > I'm thinking some possible options are: install Oracle 11 cllient
> > (assume it is backwards compatible), install the entire Oracle
> > database v.11, or install Oracle express. Appreciate your comments.
>
> > Johan
>
> 11g client will do the trick, using the correct tnsnames.ora file
> pointing to the remote database - Have done this before without
> problems. You can only install thew client, no need for a full database
> install, except if you want to connect via a dblink using a local
> database, to get to the remote database, but from what I understand, you
> don't have a local database, so the client will do
>
> Lodewicus Maas

Thanks Lodewicus and everyone. I think I will try going for the whole enchilada and load up the full db version 11!

I definitely agree with the Perl comments, but I've been hearing a lot about Ruby on Rails and am thinking of giving that a try!

Johan Received on Mon Nov 19 2007 - 17:46:28 CST