I try to install oracle instant client 12.1 in .rpm with sqlplus in .zip on a cloud linux box, but I got error: Message file sp1.msb not found.
instant client and sqlplus download URL:
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
After digging on the internet, I still cannot figure it out.
my ~/.bash_profileļ¼
export ORACLE_HOME=/usr/lib/oracle/12.1/client64
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=american_america.utf8
source ~/.bash_profile
echo $PATH
/usr/lib/oracle/12.1/client64/bin
echo $ORACLE_HOME
/usr/lib/oracle/12.1/client64
sqlplus is unzipped in /usr/lib/oracle/12.1/client64/bin, otherwise command cannot be found.
Any suggestion is welcomed.
Best Answer
This is my solution, hope helpful. After unzip the Oracle instant client archive I have to create some directories, move files and create tnsnames.ora manually. This is the layout after my setup:
Sample tnsnames.ora:
Environment variables in ~/.bashrc (for all OS users)
At this time, the command 'sqlplus user/passwd@acntuat' should work.