Open Source Development

Power Open Source Development

Explore the open source tools and capabilities for building and deploying modern applications on IBM Power platforms including AIX, IBM i, and Linux.


#Power


#Power

 View Only
  • 1.  Dependent module libclntsh.so could not be loaded.

    Posted Sat August 24, 2019 03:50 AM

    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


    #AIX-Open-Source-Software
    #AIXOpenSource


  • 2.  Re: Dependent module libclntsh.so could not be loaded.

    Posted Wed September 11, 2019 06:42 AM

    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).


    #AIXOpenSource
    #AIX-Open-Source-Software


  • 3.  Re: Dependent module libclntsh.so could not be loaded.

    Posted Thu September 12, 2019 02:41 PM

    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.


    #AIX-Open-Source-Software
    #AIXOpenSource