Thursday 31 July 2014

Installing Oracle XE and SQL Plus on CentOS

Dependencies
rpm --install libaio-0.3.107-10.el6.x86_64.rpm
rpm --install bc-1.06.95-1.el6.x86_64.rpm

Oracle XE Install and post config (note, you need to have populated xe.rsp)
rpm --install oracle-xe-11.2.0-1.0.x86_64.rpm
/etc/init.d/oracle-xe configure responseFile=xe.rsp

Instant Client and SQLPlus install
rpm --install oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
rpm --install oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

Environment setup
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE

Test with
/usr/lib/oracle/11.2/client64/bin/sqlplus system/oracle@XE

Resources
http://pkgs.org


3 comments: