RE: Oracle question

Installing an Oracle client and compiling DBD::Oracle against that is
probably your best bet, particularly on Linux.

Oracle have a package called Instant Client which is the libraries in a zip
file; much lighter than the full client install. It's available on
otn.oracle.com. You'll need the "Basic" and "SDK" packages, and preferably
the "SQL*Plus* package too.

More info in the DBD::Oracle README file and manual page.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

________________________________

From: LLC [mailto:kevin@kevinkempterllc.com]
Sent: 27 June 2006 23:34
To: dbi-users@perl.org
Subject: DBD:Oracle question


Hi List;

I have needs to write a perl DBI script on a Linux host which will pull data
from an instance of Oracle on a second Linux host.

Can I grab an Oracle ODBC Driver and reference the driver in my DBI_>Connect
call or do I have to download and install the Oracle client?

If ODBC works, any tips on where to get an Oracle ODBC driver for linux ?

Finally, In either case what should my connect string look like? Here's what
I have so far, is this correct?


# for a box with Oracle client installed for acess to an oracle database
named testdb on hostname myhost.mydomain.com:
my $dbh = DBI->connect("dbi:Oracle:myhost.mydomain.com:testdb", 'username',
'passwd' );

# for a box with a local Oracle ODBC driver & connection (via .odbc.ini)
with the DNS entry name of ORADB1

my $dbh = DBI->connect("dbi:Oracle:server=ORADB1", 'username', 'passwd' );

Thanks in advance for your help

RE: Oracle question

Alternatively you can install DBD::Oracle on the DB server (which will
presumably have all the relevant Oracle bits) and install and use DBD::Proxy
on your client machine.

Even if you use ODBC, you still need the Oracle client underneath it.

Cheers,

Steve

> -----Original Message-----
> From: Andy Hassall [mailto:andy@andyh.co.uk]
> Sent: Wednesday, 28 June 2006 8:46 AM
> To: kevin@kevinkempterllc.com; dbi-users@perl.org
> Subject: RE: Oracle question
>
> Installing an Oracle client and compiling DBD::Oracle against that is
> probably your best bet, particularly on Linux.
>
> Oracle have a package called Instant Client which is the libraries in a
> zip
> file; much lighter than the full client install. It's available on
> otn.oracle.com. You'll need the "Basic" and "SDK" packages, and preferably
> the "SQL*Plus* package too.
>
> More info in the DBD::Oracle README file and manual page.
>
> --
> Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
> http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
>
> ________________________________
>
> From: LLC [mailto:kevin@kevinkempterllc.com]
> Sent: 27 June 2006 23:34
> To: dbi-users@perl.org
> Subject: DBD:Oracle question
>
>
> Hi List;
>
> I have needs to write a perl DBI script on a Linux host which will pull
> data
> from an instance of Oracle on a second Linux host.
>
> Can I grab an Oracle ODBC Driver and reference the driver in my
> DBI_>Connect
> call or do I have to download and install the Oracle client?
>
> If ODBC works, any tips on where to get an Oracle ODBC driver for linux ?
>
> Finally, In either case what should my connect string look like? Here's
> what
> I have so far, is this correct?
>
>
> # for a box with Oracle client installed for acess to an oracle database
> named testdb on hostname myhost.mydomain.com:
> my $dbh = DBI->connect("dbi:Oracle:myhost.mydomain.com:testdb",
> 'username',
> 'passwd' );
>
> # for a box with a local Oracle ODBC driver & connection (via .odbc.ini)
> with the DNS entry name of ORADB1
>
> my $dbh = DBI->connect("dbi:Oracle:server=ORADB1", 'username', 'passwd'
> );
>
> Thanks in advance for your help