I am using Perl script used to run the ETL batch framework . We upgraded Oracle from 12c to 19C , after upgrade we are facing below issue while running the job .
install_driver(Oracle) failed: Can't load 'usr/local/lib64/perl15/auto/DBD/Oracle/Oracle.so' for module DBD:Oracle: libclntshcore.so.12.1: cannot open shared object files: No such file or directory at /usr/lib64/perl15/DynaLoader.pm line 190.
Interstingly when I rename rename libclntshcore.so.19.1 to libclntshcore.so.12.1 , it will start working . So I am trying to understand why its still trying to pick 12 library (libclntshcore.so.12.1) though I have changed my LD_LIBRARY path to 19c Oracle . Please advice .