bash-3.2$ rpm -qa grep oracle

oracle-instantclient-sqlplus-11.1.0.1-1

oracle-instantclient-basic-11.1.0.1-1

bash-3.2$ sqlplus

Error 6 initializing SQL*Plus

Message file sp1.msb not found

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Fix:

bash-3.2$ export ORACLE_HOME=/usr/lib/oracle/11.1.0.1/client64

bash-3.2$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

bash-3.2$ /usr/lib/oracle/11.1.0.1/client64/bin/sqlplus erer/[email protected]:1526/SPAPA1P

SQL*Plus: Release 11.1.0.6.0 – Production on Sat Sep 22 04:33:02 2012