Originally posted by: JowelLegaspi

Please assist in troubleshooting the library error on perl script below.

odsbat3x@p1ehowup4017:/opt/odsbat3x > /opt/oracle/ora3xf/scripts/PERLSQL.sh mdl mimd ods_usr PRU_Replacement_var_RPT.pl NA

*** PERLSQL.sh START Fri Aug 23 14:44:46 EDT 2019 **********


Changing dir to /opt/oracle/ora3xf

PRU_Replacement_var_RPT.pl mimd ods_usr xxxx NA

Starting PRU Replacement Report on mimd, PID = 42598574 at Fri Aug 23 14:44:46 2019

FILE processing time = 0.000616 Seconds


Working on Run date 20190722

install_driver(Oracle) failed: Can't load '/opt/perl5_64/lib/site_perl/5.18.1/aix-64all/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: Could not load module /opt/perl5_64/lib/site_perl/5.18.1/aix-64all/auto/DBD/Oracle/Oracle.so.
Dependent module libclntsh.so could not be loaded.
Could not load module libclntsh.so.
System error: No such file or directory
Could not load module /opt/perl5_64/lib/site_perl/5.18.1/aix-64all/auto/DBD/Oracle/Oracle.so.
Dependent module /opt/perl5_64/lib/site_perl/5.18.1/aix-64all/auto/DBD/Oracle/Oracle.so could not be loaded. at /opt/perl5_64/lib/5.18.1/aix-64all/DynaLoader.pm line 190.
at (eval 15) line 3.
Compilation failed in require at (eval 15) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /opt/oracle/ora3xf/scripts/PRU_Replacement_var_RPT.pl line 1173.

PERLSQL.sh ERROR Executing RC=2 Fri Aug 23 14:44:46 EDT 2019

Originally posted by: AyappanP

I don't think the library "Oracle.so" is part of official perl fileset delivered with AIX. 

From the error message , it looks like the shared library requires another library "libcIntsh.so" which is not present in the machine ( or not present at the correct path).

Originally posted by: Edward Davignon

You may need to install an Oracle Database Client.  Perhaps this might help: https://www.oracle.com/database/technologies/instant-client/downloads.html   As always, make sure you are licensed for software that you install.