Perl DBD-Oracle on HPUX 11.23 Itanium oracle 9.2.0.5

[drwalk]

Has anyone got DBD-Oracle 1.15 going on HPUX 11.23 Itanium with Oracle 9.2.0.5?

There is a lot of info re 64bit PA-RISC but very little with Itanium. Most of the info in the README.hpux and the various forums are very misleading as it makes assumptions that HPUX 11i is the PA RISC versions.

I can not seem to get a clean build of perl5.8.5. So my next fall back is perl 5.8.3 binary from the www.hpux.connect.org.au which at least does not have THREADS linked in. The other options are 5.8.0, and 5.8.2 from HP's DSPP site, but they all have multi threading linked in.

However the perl 5.8.3 is built with gcc.

1. The Makefile.PL could not find oratypes.h. For whatever reason this file now seems to be in $ORACLE_HOME/plsql/public. I amended the makefile.PL to fix this.
2. make fails as +DD64 is included in the compile lines. I have seen in some forum notes that this needs to be removed for gcc. I did this and it compiles ok.
3. make test fails 8/9 tests with:

# make test
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/opt/oracle/product/9.2.0/lib32:/opt/oracle/product/9.2.0/rdbms/lib32" /usr/bin/ld -b -L/usr/local/lib -L/opt/
local/lib -L/usr/lib/hpux32 Oracle.o dbdimp.o oci7.o oci8.o +s +n -L/opt/oracle/product/9.2.0/rdbms/lib32/ -L/opt/oracle/product/
9.2.0/lib32/ -lclntsh -ln9 -lncrypt9 -lnbeq9 -lntcp9 -lntcps9 -lnsslb9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnhost9 -lntns9 -lnon
ame9 -l:librt.so -l:libnss_dns.so.1 -l:libdld.so -lm -lpthread -lCsup -lunwind -lm -o blib/arch/auto/DBD/Oracle/Oracle.so
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/base......./usr/lib/hpux32/dld.so: Cannot dlopen load module '/usr/lib/hpux32/libpthread.so.1' because it contains thread specific
data.
Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load '/usr/local/src/DBD-Oracle-1.15/blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracl
e: Exec format error at /usr/local/lib/perl5/5.8.3/IA64.ARCHREV_0/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/base.t line 19
The remaining tests will probably also fail with the same error.

and they do all fail.



Dwight