Oracle perl modules - how to get working ?

[Unix Team_6]

Hi everyone,

we have a big problem with some perl scripts. We have migrated from Lclass HPUX 11.0 to rx3600 11.31 and now some perl scripts dont work. See error below. ive tried downloading and making/installing oracle DBD and DBI perl modules from cpan.org and even though it worked my perl upload script below still doesnt work. anyone know what to do now ?

Lots of big points available to any/all replies! any info useful.

$ perl $APPMODULE_PATH/cdr_loader_main.pl
+ perl /CCCMAIN/coltcom/load/cdr/scripts/cdr_loader_main.pl
install_driver(Oracle) failed: Can't load '/opt/perl_32/lib/site_perl/5.8.8/IA64.ARCHREV_0 -thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: No such file or directory at /opt/perl_32/lib/5.8.8/IA64.ARCHREV_0-thread-multi/DynaLoader.pm line 230.
at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /CCCMAIN/coltcom/load/coltmodules/db_manipulation.pm line 51
BEGIN failed--compilation aborted at /CCCMAIN/coltcom/load/coltmodules/db_manipulation.pm line 61.
Compilation failed in require at /CCCMAIN/coltcom/load/cdr/scripts/cdr_loader_main.pl line 26.
BEGIN failed--compilation aborted at /CCCMAIN/coltcom/load/cdr/scripts/cdr_loader_main.pl line 26.


Thanks,

Unix team

[Unix Team_6]

Found some more info. Line 230 of DynaLoader.pm shows;

# Many dynamic extension loading problems will appear to come from
# this section of code: XYZ failed at line 123 of DynaLoader.pm.
# Often these errors are actually occurring in the initialisation
# C code of the extension XS file. Perl reports the error as being
# in this perl code simply because this was the last perl code
# it executed.

my $libref = dl_load_file($file, $module->dl_load_flags) or
croak("Can't load '$file' for module $module: ".dl_error());

Question is how to fix initialisation of C code in the extension XS File ??

[Unix Team_6]

ok got past this issue. copied over all of /opt/perl5 from 11.0 box and oracle_817 dir and it works.

I now have another perl problem. see error below. the environment is identical on both boxes but still get this error. any perl experts out there who can help please ??

$ export PATH=/usr/local/bin:$PATH
$ export ORACLE_SID=CCCPROD
$ export ORAENV_ASK=NO
$ export INVOICE_HOME=/CCCMAIN/coltcom/load/invoice/invoiceloader
$ export COLTMODULE_PATH=/CCCMAIN/coltcom/load/coltmodules
$ export APPMODULE_PATH=$INVOICE_HOME/scriptsnew
$ export CONFIGFILE_FULLNAME=$INVOICE_HOME/confignew/invoiceconfig.properties
$ . /usr/local/bin/oraenv
$ /usr/bin/perl $INVOICE_HOME/scriptsnew/invoice_loader_main.pl

INFO: Connected to ccmain with user(LOADUSR) at 10/11/10 12:06:11 successful!

Can't load '/opt/perl5/lib/site_perl/5.6.1/PA-RISC2.0/auto/XML/Parser/Expat/Expat.sl' for module XML ::Parser::Expat: No such file or directory at /opt/perl5/lib/5.6.1/PA-RISC2.0/DynaLoader.pm line 206 .
at /opt/perl5/lib/site_perl/5.6.1/PA-RISC2.0/XML/Parser.pm line 15
Compilation failed in require at /opt/perl5/lib/site_perl/5.6.1/PA-RISC2.0/XML/Parser.pm line 15.
BEGIN failed--compilation aborted at /opt/perl5/lib/site_perl/5.6.1/PA-RISC2.0/XML/Parser.pm line 19 .
Compilation failed in require at /opt/perl5/lib/site_perl/5.6.1/XML/XPath/XMLParser.pm line 7.
BEGIN failed--compilation aborted at /opt/perl5/lib/site_perl/5.6.1/XML/XPath/XMLParser.pm line 7.
Compilation failed in require at /opt/perl5/lib/site_perl/5.6.1/XML/XPath.pm line 13.
BEGIN failed--compilation aborted at /opt/perl5/lib/site_perl/5.6.1/XML/XPath.pm line 13.
Compilation failed in require at /CCCMAIN/coltcom/load/invoice/invoiceloader/scriptsnew/invoice_xmlp roc.pl line 92.
BEGIN failed--compilation aborted at /CCCMAIN/coltcom/load/invoice/invoiceloader/scriptsnew/invoice_ xmlproc.pl line 92.
Compilation failed in require at /CCCMAIN/coltcom/load/invoice/invoiceloader/scriptsnew/invoice_load er_main.pl line 22.
INFO: Disconnect with Database at 10/11/10 12:06:11, Good-bye !

And line 15 of Parser.pm is;

$ cat /opt/perl5/lib/site_perl/5.6.1/PA-RISC2.0/XML/Parser.pm
# XML::Parser
#
# Copyright (c) 1998-2000 Larry Wall and Clark Cooper
# All rights reserved.
#
# This program is free software; you can redistribute it and/or
# modify it under the same terms as Perl itself.

package XML::Parser;

use Carp;
use IO::File;

BEGIN {
require XML::Parser::Expat;
$VERSION = '2.30';
die "Parser.pm and Expat.pm versions don't match"
unless $VERSION eq $XML::Parser::Expat::VERSION;
}

any idea how to fix ? it can load XML and Parser and Expat ? but all these exist in /opt/perl5 which was copied over from 11.0 box to new 11.31 box.

[Unix Team_6]

fixed. missing libexpat.so from /usr/local/lib.

This website was fantastic in explaining perl module Expat;

http://viewcvs.scratchbox.org/cgi-bin/viewcvs.cgi/scratchbox/doc/perl.txt?view=co

[Unix Team_6]

.