Oracle

From wiki.kungfootek.net
Revision as of 15:54, 4 May 2016 by Daniel Baker (talk | contribs) (Created page with "Installing SQLPlus in Linux / Centos 7 [http://stackoverflow.com/questions/23488394/how-to-install-sql-plus-client-in-linux Collected from Stack Overflow] [http://www.oracle...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Installing SQLPlus in Linux / Centos 7

Collected from Stack Overflow

Get the correct RPM


Set environment variables in your ~/.bash_profile

ORACLE_HOME=/usr/lib/oracle/11.2/client64
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_HOME
export LD_LIBRARY_PATH
export PATH

Reload your .bash_profile or bash_rc with source or relog.


sqlplus "username/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.1)(PORT=1521))(CONNECT_DATA=(SID=YOURSID)))"