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@xxxxxxxxxxx :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

________________________________

From: LLC [mailto:kevin@xxxxxxxxxxxxxxxxxxx]
Sent: 27 June 2006 23:34
To: dbi-users@xxxxxxxx
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

.

Relevant Pages

  • Re: Cant get Oracle OLE DB provider to work from SSIS on a 64-bit environment
    ... The project I'm trying to get running, consists of approx 25 seperate packages where 3-4 of them gets data from different Oracle sources, but I'm not even got to the point where I'm trying to run the whole lot. ... There are two issues in the topic that could be an issue, and that is to switch the whole project to 32-bit mode and then the part that says that the Designer only shows 32-bit versions of the provider. ... What I think I'll try now, it to install the 32-bit version of the Oracle ODAC to see if that makes any difference. ... uninstall ODAC and when I uninstall the regular Oracle Client with the ...
    (microsoft.public.sqlserver.dts)
  • Re: Linux flavor
    ... creation of an testing oracle database. ... prefer to do that on Linux, my advice wold be to just use the Linux ... Oracle 9i and were a bit of a pain to install on ... Linux distro, as long as your using a recent version of that distro and ...
    (comp.databases.oracle.server)
  • Re: Components to install Linux
    ... scan for viruses. ... Here's a table of "equivalents of Windows software in Linux": ... Oracle only officially supports it on certain versions of certain ... that explain how to install it on various versions of Red Hat ...
    (comp.os.linux)
  • Re: OT: Paging the Linux Jihadi
    ... will install & work fine on one distro but not another. ... I know Derek 'Linux evangalist & Bill Gates despiser extraordinaire' ... I would have thought that if you where running Oracle then nothing else would be running on the box. ...
    (uk.rec.motorcycles)
  • Re: Questions related to DBI and DBD::Oracle
    ... You can use the Oracle Instant client for free and you can get it here ... If I install oracle.pm will that solve my problem or do I need to install oracle client on the unix box to make it work. ... so far you only have DBI or th Data Base Interface you need a Data Base ...
    (perl.dbi.users)