Setup sqlplus for AWD

Download and unzip instanceclient packages

unzip instantclient-tools-linux-19.6.0.0.0dbru.zip
unzip instantclient-basiclite-linux-19.6.0.0.0dbru.zip
unzip instantclient-odbc-linux-19.6.0.0.0dbru.zip
unzip instantclient-odbc-linux-19.6.0.0.0dbru.zip
unzip instantclient-sqlplus-linux-19.6.0.0.0dbru.zip
unzip instantclient-tools-linux-19.6.0.0.0dbru.zip

Update profile.d/custom.sh file for profile

TNS_ADMIN=/usr/lib/oracle/19.6/client/wallet
ORACLE_HOME=/usr/lib/oracle/19.6/client/
export TNS_ADMIN ORACLE_HOME
export LD_LIBRARY_PATH="$ORACLE_HOME"
PATH=$PATH:${ORACLE_HOME}/bin
export PATH

Download wallet, unzip it and store in secure location . add priviledge only for user who will need access it or to group as needed.

Update path in sqlnet.ora to point to wallet directory

wallet /usr/local/app/oracle/wallet

Use RPM to install instance client

rpm -ivh oracle-instantclient19.6-basic-19.6.0.0.0-1.i386.rpm
rpm -ivh oracle-instantclient19.6-sqlplus-19.6.0.0.0-1.i386.rpm
yum install libaio
yum install libaio.i686

Leave a Reply

Your email address will not be published. Required fields are marked *