Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Best Way to Access remote Oracle 10.2.0.1.0 DB from a Linux server
On 20 Nov., 00:46, Johan <johang..._at_yahoo.com> wrote:
> 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
If it's about languages also have a look at python :-) Received on Wed Nov 21 2007 - 03:02:02 CST
![]() |
![]() |