Setup Oracle sql plus client on AWS Ubuntu/Linux

Setup Oracle sql plus client on AWS Ubuntu/Linux

Dependencies :

• AWS Instance with Ubuntu/Linux
• Oracle Instant Client package
• Oracle SQL Plus package

Steps to Install the Client : 

1. First we need to install alien package

sudo apt -get install alien

2. Install downloaded instant rpm package<client>

sudo alien -i oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm 

3. Install downloaded sql plus package

sudo alien -i oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm 

4. Install libaio1,libaio-dev packages if not already installed. Usually in vanilla ubuntu 14 l

ibaio1, libaio-dev packages are not pre-installed. 

5. Export oracle client lib directory path to LD_LIBRARY_PATH variable. 

export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib/${LD_LIBRARY_PATH:+:$LD_LIBRARY_PATH}

6. Test the client now.

Following sql prompt will appear by using credentials are correct.

ubuntu@ip-272-300-203-2222:~/oracle_client$ sqlplus64
username/password@//rds_hostname:1521/ORCL
SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 14 07:44:56
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
connected to:
oracle Database 11g Enterprise Edition release 11.2.0.4.0-64 bit production
With the portioning ,Oracle Label Security,Olap,Data Mining ans Real Application Testing Options