Good morning! I have been in charge of installing Oraperl on a bunch of our HPUX systems. I've gone from 10.20 all the way to 11i. I found your cpan.org site, which has almost all of the information that I already gleaned from sources abroad. Thanks for maintaining all this, it's a great tool to use.
I recently had a problem with Oracle 9 64-bit on HPUX 11i. We have another application that required SH_LIBARY_PATH to point to the 64-bit libraries, which "broke" the Oraperl module. So I did some research and successfully recompiled and re-installed with the most recent versions of everything (perl, DBI, DBD) that works with 64-bit shared libraries. This is the error we were getting (basically) "/usr/lib/dld.sl: Bad magic number for shared library: /ora1/app/oracle/product/9.2.0.1.0/lib32" I resolved the issue. I thought you might want to add it to your README.HPUX at some point. Here is my step-by-step instructions, pretty much what you have but streamlined for this particular case. Required software: HPUX 11.11 (11i) PA-RISC perl 5.8.4 source DBI-1.42 source DBD-Oracle-1.15 source Oracle 9.2.0.1.0 installation Step 1: Compiling Perl This compiles PERL using the default HPUX cc compiler. The important things to note here are the configure parameters. the only non-default option to take is to add "+z" to the additional cc flags step. # gunzip perl-5.8.4.tar.gz # tar -xf perl-5.8.4.tar # cd perl-5.8.4 # ./Configure -Ubincompat5005 -Duselargefiles -A prepend:libswanted='cl pthread ' -Duse64bitall Any additional cc flags? Add +z to beginning of list, include all other options. # make;make test "make test" should have over 98% succeed. If less, something is wrong. Step 2.DBI gunzip DBI-1.42.tar.gz tar -xvf DBI-1.42.tar cd DBI-1.42 perl Makefile.PL make;make test make install Step 3: Install DBD-Oracle First, set the following environment variables (custom to your own oracle install, naturally) export ORACLE_USERID=user/pass export ORACLE_HOME=/oracle/product/9.2.0.1.0 export ORACLE_SID=orap1 gunzip DBD-Oracle-1.15.tar.gz tar -xvf DBD-Oracle-1.15.tar cd DBD-Oracle-1.15 perl Makefile.PL -l make;make test make install Gram Ludlow Unix/Teamcenter LEC Support Caterpillar (765) 448-2075
