Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Best Way to Access remote Oracle 10.2.0.1.0 DB from a Linux server

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

From: Lodewicus Maas <linux.oracle.dba_at_googlemail.com>
Date: Mon, 19 Nov 2007 07:48:18 +0200
Message-ID: <6o6dnVg65_o_vtzaRVnygAA@saix.net>


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 Received on Sun Nov 18 2007 - 23:48:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US