PDA

View Full Version : DBI install for Oracle


casa
12-19-02, 10:51
I need to have the DBI.pm module installed on a UNIX server.

My situation:
I have some perl scripts that was running successfully on an NT server, but because of a serious security breech, have been moved to a UNIX server. This server has the standard Perl install, but not DBI. The Oracle database will not be moved and resides on a different server. It was not on the breeched NT server either.

My Question:
Exactly what needs to be installed on my UNIX server in order to access this remote Oracle database with my Perl scripts?

elango
12-20-02, 05:46
Just try like this..

Go to http://search.cpan.org/ and search for the following modules:

1. CGI, 2.DBI, 3.DBD::Oracle

download, uncompress and install.

To install each module, change the directory contains uncompressed files and
issue the following commands

1. perl Makefile.PL 2. make

su #make install.

change the directory to cgi-bin or the script directory, modify the cgi/perl scripts
by adding SID name with NT server address.
(DBI:Oracleracle_sid@ntserver_address)

run the scripts at command line, debug and try running the scripts via http server !

Any problem, please post again ..

Elango Palchamy
p_elango@yahoo.com