The personal website of Philip Mather

Install & Use SQLPlus

Posted Sat, 03/20/2010 - 14:15 by philip.mather

Download oracle-instantclient-basic-10.2.0.4-1.i386.rpm and oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm to the /tmp/ directory of the server...

rpm -ivh /tmp/oracle-instantclient-*
vi /tmp/tnsnames.ora
export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.4/client/lib/:${LD_LIBRARY_PATH}
export TNS_ADMIN=/path/to/tnsnames.ora/nofile/
sqlplus system/oracle@targetfromora

OracleXE will need the following export first...

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus