0 votes
1 view
in AWS by (8.9k points)

I am working on AWS services. I have an ec2 ( centos ) instance. I need to configure SQL*Plus client on this centos machine.

The server with whom I want to connect is at some remote area. The server version is oracle-se(11.2.0.2)

Kindly help me getting the client installed on the centos machine.

Thanks in advance.

1 Answer

0 votes
by (18.5k points)

Use the following commands:

1. Download Oracle Linux instant client

oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm

oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm

2. Install

rpm -ivh oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm

rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm

3. Set environment variables in your ~/.bash_profile as shown below:

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

4. Reload the bash_profile using the following command:

source ~/.bash_profile

5. Start using SQL*PLUS and connect your server:

sqlplus "username/[email protected](DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.1)(PORT=1521))(CONNECT_DATA=(SID=YOURSID)))"

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...