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@xxxxxxxxxxx]
Sent: Wednesday, 28 June 2006 8:46 AM
To: kevin@xxxxxxxxxxxxxxxxxxx; dbi-users@xxxxxxxx
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@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: :Oracle install problem On Solaris 8
    ... I tried to reinstall the Oracle client. ... To: Hemanth Kumar; Michael Nhan ... Subject: RE::Oracle install problem On Solaris 8 ...
    (perl.dbi.users)
  • RE: Oracle with ActiveState build 8xx
    ... > 8.1.7.4 client lib, ... I have near zero Oracle ... > libs and the OCI ... > they do install ...
    (perl.dbi.users)
  • Re: Running oracle 8 or oracle 9 on RedHat9.x
    ... > because php doesn't work with the oracle 9 client. ... But I know for sure that PHP *does* work with Oracle9 client, ... ./runInstaller again and click "Install client" or something like that. ...
    (RedHat)
  • Getting DBD::Oracle tests working
    ... Attached is the output from one install attempt. ... I'm having trouble finding your Oracle version number... ... You can use "perl Makefile.PL -V X.Y.Z" to specify a your client version. ... all skipped: no reason given ...
    (perl.dbi.users)
  • Re: DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch wont install
    ... Currently all my Oracle inst client files are user oracle group oinstall yet lib bin and other dirs have 755 permission so root should be able to access and execute these softlibs. ... As I have written, I have installed DBD::Oracle-1.19 many times with a full client without problem, yet with the limited instant client it does not find the mk file, and the one mk file that the instant client installs does not work. ... It also gives me a makefile for DBD::Oracle but install and test fail ...
    (perl.dbi.users)