Error 6 initializing SQLPLUS Error in Unix/Linux

Error 6 initializing SQLPLUS Error in Unix/Linux :DK®

Error Description :DK®

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

Please check this command first. 

 $ echo $ORACLE_HOME
/opt/oracle/product/11.2.0/Xe/bin/sqlplus

If you are getting empty value for this command then need to follow below steps.DK®

1) Find out the path to sqlplus:DK®

$ find /opt/oracle -name sqlplus
 /opt/oracle/product/11.2.0/Xe/bin/sqlplus

2) Set your Oracle_HOME (upto xe directory)

export ORACLE_HOME=/opt/oracle/product/11.2.0/Xe/

3) Set the path to the directory where sqlplus is located to your PATH variable:
export PATH=/opt/oracle/product/11.2.0/Xe/bin:$PATH

Find the SQL Version :
/opt/oracle/product/11.2.0/Xe/bin/sqlplus /nolog

Find Tnsnames.ora location in Unix/Linux :DK®

cd /opt
$ find $ORACLE_HOME -name tnsnames.ora
/opt/oracle/product/11.2.0/Xe/network/admin/samples/tnsnames.ora
/opt/oracle/product/11.2.0/Xe/network/admin/tnsnames.ora
/opt/oracle/product/client11.2.0.1/network/admin/samples/tnsnames.ora

Find the current  user privileges :DK®

SQL> select * from session_privs;