export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH For , use LIBPATH :
Check:
ldd $ORACLE_HOME/bin/sqlplus Look for lines like: An invalid NLS_LANG can cause SQL*Plus to look
If it’s set to something exotic like JAPANESE_JAPAN.JA16EUC , verify that $ORACLE_HOME/nls/data contains the necessary data files. For testing, unset it: export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH For
Introduction If you are an Oracle DBA, developer, or data analyst working with Oracle Database on UNIX/Linux systems (such as AIX, Solaris, HP-UX, or Linux), you might have encountered a frustrating error when trying to launch SQL*Plus: use SHLIB_PATH : libsqlplus.so =>
export LIBPATH=$ORACLE_HOME/lib:$LIBPATH For , use SHLIB_PATH :
libsqlplus.so => /u01/app/oracle/product/19.3.0/dbhome_1/lib/libsqlplus.so If you see not found , then LD_LIBRARY_PATH is incorrect or the library is missing. If you see a path, ensure that path is readable and executable. An invalid NLS_LANG can cause SQL*Plus to look for messages in a nonexistent language subdirectory.