Ilya, Thank you for your help! This is undoubtedly old hat to you guys, but I was confused by installation instructions for other modules that refer to a PREFIX parameter that announces installation in nonstandard directories.
Anyway, I finally got DBI and DBD::Oracle installed successfully. During installation of DBD, I encountered a plethora of complaints over the lack of read permission to a series of Oracle files, mostly of the .h variety, mostly in directory /opt/oracle8.1.7/rdbms/demo/ . Perhaps such woes have already been kicked around on dbi-users and a list of the relevant files published; I simply haven't been able to get through on dbi.perl.org yesterday or today to check. Lacking such a list, our (fortunately patient!) DBA and I were forced to repeatedly re-run the make while resolving the access problems piecemeal. Med venlig hilsen / Best regards, Mel Presley TDC Services, Copenhagen > -----Oprindelig meddelelse----- > Fra: Sterin, Ilya [SMTP:[EMAIL PROTECTED]] > Sendt: 30. oktober 2001 06:54 > Til: Melton Cline Presley; [EMAIL PROTECTED] > Emne: RE: Can't locate DBI.pm - Oracle DBD > > It can very easily be resolved by printing out your @INC with the same > perl > installation you are trying to install DBD::Oracle with. Are you > specifying > the full path, so that it uses the 5.6 version for intall and have you > done > the same for DBI. Remember that when you use a non standard directory for > installation it is not in @INC, and therefore can't be found until you > modify @INC. > > Ilya > > > -----Original Message----- > > From: Melton Cline Presley [mailto:[EMAIL PROTECTED]] > > Sent: Friday, October 26, 2001 8:48 AM > > To: '[EMAIL PROTECTED]' > > Subject: Can't locate DBI.pm - Oracle DBD > > > > > > I've encountered an error while trying to install the DBD for Oracle. > > > > On our system, we presently need to retain Perl version 5.003 in the > > standard directory placements. In order to make use of DBI and the > > Oracle DBD possible, I've (apparently successfully) installed Perl > > version 5.6.1 using a PREFIX value of: > > > > /export/home/udv/r80755/perl > > > > I then (also, apparently successfully) installed DBI-1.20 , doing the > > decompress and unpack from this same directory. I did NOT use a > > -DPREFIX parameter when running the Makefile.PL to do this installation, > > but I DID run the Makefile using the 5.6.1 version of Perl. The > > make test results following this installation showed no problems. > > > > I've subsequently tried to install DBD-Oracle-1.12 two different ways, > > neither of which succeeded; both failed with the same diagnostic: > > > > Can't locate DBI.pm in @INC ... > > > > I did NOT use a -DPREFIX parameter for either Makefile.PL installation > > run. The difference between the two installation attempts was that > > the first was based in: > > > > /export/home/udv/a70411/perl/bin/perl > > > > and the second in: > > > > /export/home/udv/a70411/perl/bin/perl/DBI-1.20 > > > > The reason I tried the second type of installation was that there is a > > file /export/home/udv/a70411/perl/bin/perl/DBI-1.20/DBI.pm present, and > > there are 3 other DBI.pm files in subdirectories of that directory. > > > > The session log is reproduced below, with the scene of the crime set off > > by the insertion of some comment lines. Note: 's' is a local utility > > script that shows subdirectories of the current directory between a pair > > of border lines; these border lines show the current directory. 's' can > > also cd to a new directory. > > > > Note: The session log is from the 2nd installation attempt. > > > > ----------------My inquiry is twofold:--------------------- > > > > Should I install the DBD as a sibling of the DBI (in the same > directory), > > or should I install it as a child of the DBD (in the DBI-1.20 > > subdirectory)? > > > > How can I solve the problem of the missing DBI.pm ? > > > > ----------------------------------------------------------- > > > > I will give thanks in advance for any help. > > > > Mel Presley > > TDC Services > > [EMAIL PROTECTED] > > > > -------------------------------------------------------------------- > > > > y313477!r80755:~/perl [105]> uname -a > > SunOS y313477 5.6 Generic_105181-23 sun4u sparc SUNW,Ultra-Enterprise > > y313477!r80755:~/perl [106]> s > > > > ==v= /export/home/udv/r80755/perl > > ===v====v====v====v====v====v====v====v== > > bin DBI-1.20 lib man > perl-5.6.1 > > > > ==^= /export/home/udv/r80755/perl > > ===^====^====^====^====^====^====^====^== > > > > y313477!r80755:~/perl [107]> ls -la > > total 48056 > > drwxr-xr-x 7 r80755 udv 4096 Okt 26 12:41 ./ > > drwxr-xr-x 8 r80755 udv 4096 Okt 23 15:54 ../ > > drwxr-xr-x 2 r80755 udv 4096 Okt 23 19:35 bin/ > > drwxr-xr-x 6 r80755 udv 4096 Okt 26 12:50 DBI-1.20/ > > -rw-r--r-- 1 r80755 udv 624128 Okt 24 15:17 DBI-1.20.tar > > drwxr-xr-x 4 r80755 udv 96 Okt 23 19:34 lib/ > > drwxr-xr-x 4 r80755 udv 96 Okt 23 19:36 man/ > > drwxr-xr-x 29 r80755 udv 8192 Okt 23 19:27 perl-5.6.1/ > > -rw-r--r-- 1 r80755 udv 23951360 Okt 23 15:58 stable.tar > > y313477!r80755:~/perl [108]> s DBI-1.20 > > > > ==v= /export/home/udv/r80755/perl/DBI-1.20 > > ====v====v====v====v====v====v== > > blib DBD-Oracle-1.>> lib t > > >>>>>>>>>>>>> Names truncated above are printed in full below > > <<<<<<<<<<<<< > > DBD-Oracle-1.12 > > ==^= /export/home/udv/r80755/perl/DBI-1.20 > > ====^====^====^====^====^====^== > > > > y313477!r80755:~/perl/DBI-1.20 [109]> ls -la > > total 2544 > > drwxr-xr-x 6 r80755 udv 4096 Okt 26 12:50 ./ > > drwxr-xr-x 7 r80755 udv 4096 Okt 26 12:41 ../ > > drwxr-xr-x 7 r80755 udv 96 Okt 24 15:45 blib/ > > -r--r--r-- 1 r80755 udv 36841 Aug 25 01:33 Changes > > -r--r--r-- 1 r80755 udv 2050 Aug 25 00:05 dbd_xsh.h > > drwxr-xr-x 5 r80755 udv 4096 Aug 31 18:27 DBD-Oracle-1.12/ > > -rw-r--r-- 1 r80755 udv 567808 Okt 26 12:44 > DBD-Oracle-1.12.tar > > -r--r--r-- 1 r80755 udv 1570 Aug 25 00:10 dbi_sql.h > > -rw-r--r-- 1 r80755 udv 0 Okt 26 12:49 DBI.bs > > -rw-r--r-- 1 r80755 udv 105303 Okt 24 15:45 DBI.c > > -rw-r--r-- 1 r80755 udv 110576 Okt 26 12:49 DBI.o > > -r--r--r-- 1 r80755 udv 158339 Aug 25 01:33 DBI.pm > > -r--r--r-- 1 r80755 udv 91378 Aug 25 00:10 DBI.xs > > -r--r--r-- 1 r80755 udv 7795 Aug 25 00:09 dbipport.h > > -rw-r--r-- 1 r80755 udv 5199 Okt 24 15:45 dbiproxy > > -r--r--r-- 1 r80755 udv 5578 Aug 25 00:05 dbiproxy.PL > > -rw-r--r-- 1 r80755 udv 403 Okt 24 15:45 dbish > > -r--r--r-- 1 r80755 udv 741 Aug 25 00:09 dbish.PL > > -r--r--r-- 1 r80755 udv 17237 Aug 25 00:11 DBIXS.h > > -r--r--r-- 1 r80755 udv 12098 Aug 25 00:11 Driver.xst > > drwxr-xr-x 6 r80755 udv 96 Aug 25 01:34 lib/ > > -rw-r--r-- 1 r80755 udv 28346 Okt 26 12:48 Makefile > > -r-xr-xr-x 1 r80755 udv 6832 Aug 25 00:11 Makefile.PL* > > -r--r--r-- 1 r80755 udv 1714 Aug 25 00:09 MANIFEST > > -rw-r--r-- 1 r80755 udv 18136 Okt 24 15:45 Perl.c > > -rw-r--r-- 1 r80755 udv 30676 Okt 24 15:45 Perl.o > > -r--r--r-- 1 r80755 udv 394 Aug 25 00:09 Perl.xs > > -rw-r--r-- 1 r80755 udv 12046 Okt 24 15:45 Perl.xsi > > -rw-r--r-- 1 r80755 udv 0 Okt 24 15:45 pm_to_blib > > -r--r--r-- 1 r80755 udv 4966 Aug 25 00:09 README > > drwxr-xr-x 2 r80755 udv 4096 Aug 25 01:34 t/ > > -r-xr-xr-x 1 r80755 udv 3887 Aug 25 00:11 test.pl* > > -r--r--r-- 1 r80755 udv 8216 Aug 24 20:07 ToDo > > y313477!r80755:~/perl/DBI-1.20 [110]> s DBD-Oracle-1.12 > > > > ==v= /export/home/udv/r80755/perl/DBI-1.20/DBD-Oracle-1.12 > > ===v====v====v== > > hints Oracle.ex t > > ==^= /export/home/udv/r80755/perl/DBI-1.20/DBD-Oracle-1.12 > > ===^====^====^== > > > > y313477!r80755:~/perl/DBI-1.20/DBD-Oracle-1.12 [111]> ls -la > > total 1064 > > drwxr-xr-x 5 r80755 udv 4096 Aug 31 18:27 ./ > > drwxr-xr-x 6 r80755 udv 4096 Okt 26 12:50 ../ > > -r--r--r-- 1 r80755 udv 30568 Aug 31 18:27 Changes > > -r--r--r-- 1 r80755 udv 56974 Aug 29 21:39 dbdimp.c > > -r--r--r-- 1 r80755 udv 9868 Aug 30 17:48 dbdimp.h > > drwxr-xr-x 2 r80755 udv 96 Aug 31 18:27 hints/ > > -r-xr-xr-x 1 r80755 udv 43744 Aug 31 18:27 Makefile.PL* > > -r--r--r-- 1 r80755 udv 706 Aug 29 02:04 MANIFEST > > -r--r--r-- 1 r80755 udv 5743 Maj 2 2000 oci.def > > -r--r--r-- 1 r80755 udv 17596 Aug 29 21:39 oci7.c > > -r--r--r-- 1 r80755 udv 52708 Aug 31 17:55 oci8.c > > -r--r--r-- 1 r80755 udv 11204 Aug 30 17:48 ocitrace.h > > -r--r--r-- 1 r80755 udv 62260 Maj 2 2000 ora_explain.PL > > drwxr-xr-x 2 r80755 udv 4096 Aug 31 18:27 Oracle.ex/ > > -r--r--r-- 1 r80755 udv 2402 Maj 2 2000 Oracle.h > > -r--r--r-- 1 r80755 udv 42814 Aug 31 18:27 Oracle.pm > > -r--r--r-- 1 r80755 udv 2548 Aug 29 21:39 Oracle.xs > > -r--r--r-- 1 r80755 udv 1292 Maj 2 2000 oraperl.ph > > -r--r--r-- 1 r80755 udv 27606 Aug 6 23:58 Oraperl.pm > > -r--r--r-- 1 r80755 udv 9654 Aug 29 17:29 README > > -r--r--r-- 1 r80755 udv 12057 Feb 23 2001 README.clients > > -r--r--r-- 1 r80755 udv 7892 Maj 2 2000 README.explain > > -r--r--r-- 1 r80755 udv 18009 Aug 29 13:36 README.help > > -r--r--r-- 1 r80755 udv 18773 Jul 16 23:18 README.hpux > > -r--r--r-- 1 r80755 udv 12020 Aug 25 14:33 README.java > > -r--r--r-- 1 r80755 udv 393 Aug 29 21:39 README.login > > -r--r--r-- 1 r80755 udv 2559 Maj 2 2000 README.longs > > -r--r--r-- 1 r80755 udv 4963 Maj 2 2000 README.sec > > -r--r--r-- 1 r80755 udv 1907 Aug 11 2000 README.win32 > > -r--r--r-- 1 r80755 udv 664 Maj 2 2000 README.wingcc > > drwxr-xr-x 2 r80755 udv 4096 Aug 31 18:27 t/ > > -r-xr-xr-x 1 r80755 udv 13168 Aug 29 21:39 test.pl* > > -rw-r--r-- 1 r80755 udv 1466 Aug 30 11:08 Todo > > y313477!r80755:~/perl/DBI-1.20/DBD-Oracle-1.12 [112]> > > > > ***** COMMENT LINES INSERTED TO SHOW WHERE ERROR OCCURRED (SEE JUST > BELOW) > > > > /export/home/udv/r80755/perl/bin/perl Makefile.PL > > Can't locate DBI.pm in @INC (@INC contains: > > /export/home/udv/r80755/perl/lib/5.6.1/sun4-solaris > > /export/home/udv/r80755/perl/lib/5.6.1 > > /export/home/udv/r80755/perl/lib/site_perl/5.6.1/sun4-solaris > > /export/home/udv/r80755/perl/lib/site_perl/5.6.1 > > /export/home/udv/r80755/perl/lib/site_perl .) at Makefile.PL line 20. > > BEGIN failed--compilation aborted at Makefile.PL line 20. > > > > ***** COMMENT LINES INSERTED TO SHOW WHERE ERROR OCCURRED (SEE JUST > ABOVE) > > > > > > y313477!r80755:~/perl/DBI-1.20/DBD-Oracle-1.12 [113]> less Makefile.PL > > > > ## > > ## You should not need to edit this file. > > ## > > > > BEGIN { $^W = 1 } > > BEGIN { require 5.004 } > > > > use ExtUtils::MakeMaker 5.16, qw(&WriteMakefile $Verbose); > > use Getopt::Long; > > use Config; > > use Cwd; > > use File::Find; > > use strict; > > > > # This DBI must be installed before we can build a DBD. > > # For those not using Dynamic loading this means building a > > # new static perl in the DBI directory by saying 'make perl' > > # and then using _that_ perl to make this one. > > use DBI 1.20; > > use DBI::DBD; # DBD creation tools > > > > -------------------------------------------------------------------- > > > > The failure occurred at the Makefile.PL line that reads: > > > > use DBI 1.20;
