This error usually while you do something wrong. Wait, what’s an error when you do everything right?
Okay, here it is:
You install the instantclient 32 rpm
oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64
On that server, you switch home using oraenv
$ . oraenv ORACLE_SID = [oracle] ? DB01 The Oracle base has been set to /u01/app/oracle
You start sqlplus
$ sqlplus -v sqlplus: error while loading shared libraries: libsqlplus.so: wrong ELF class: ELFCLASS64
Oops!? what happened?
This dubious made-by-Oracle RPM package simply created a sqlplus link in BIN.
lrwxrwxrwx. /bin/sqlplus -> /usr/lib/oracle/12.1/client/bin/sqlplus
Then, oraenv did put ORACLE_HOME at the end position
$ echo $PATH /usr/local/bin:/usr/bin:/u01/app/oracle/product/db19c/db01/bin
Just change the PATH manually and you’ll be fine.
$ PATH=$ORACLE_HOME/bin:/usr/local/bin:/usr/bin $ sqlplus -v SQL*Plus: Release 19.0.0.0.0 - Production Version 19.4.0.0.0