Setup sqlplus for AWS RDS Oracle DB in a Linux server

Step 1 : 

Download the packages


URL : https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html


We need below 2 files. 


instantclient-basic-linux.x64-23.8.0.25.04.zip
nstantclient-sqlplus-linux.x64-23.8.0.25.04.zip


The version of above packages can be changed. 


Make a new dir for the oracle configurations and extract the 2 zip files in the same location.


mkdir -p /root/oracle/instantclient_23_8



Step 2 :


Create  tnsnames.ora file


touch /root/oracle/instantclient_23_8/network/admin/tnsnames.ora


Content is below


service name =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = maleesha-lr.c700eh08fac4.eu-west-2.rds.amazonaws.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = service_name)
    )
  )


Step 3 :


Set env variables for the linux user in the bash profile 


export ORACLE_HOME=/root/oracle/instantclient_23_8
export PATH=$ORACLE_HOME:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin

Step 4 :


Install libaio


sudo dnf install -y libaio

Step 5 :


Test the connection


source ~/.bash_profile

sqlplus username/password@service_name



Maleesha Gimshan | 21st June 2025

Comments

Post a Comment

Popular posts from this blog

ArgoCD Installation

Image
Argo-CD is a Kubernetes-native continuous deployment (CD) tool. Unlike external CD tools that only enable push-based deployments, Argo CD can pull updated code from Git repositories and deploy it directly to Kubernetes resources. Official documentation :  https://argo-cd.readthedocs.io/en/stable/ 1. ArgoCD Installation Step 1 : Login to the relevant Kubernetes cluster and Create new namespace for argoCD  kubectl create namespace argocd Step 2: Download the argoCD installation manifest. Get the link from argoCD official documentation - https://argo-cd.readthedocs.io/en/stable/getting_started/#1-install-argo-cd curl -s https://raw.githubusercontent.com/argoproj/argo-cd/ v2.11.3 /manifests/install.yaml -o install.yaml Step 3: Apply the installation manifest to the new namespace  kubectl apply -n argocd -f install.yaml Step 4: Change the service type from ClusterIP to NodePort in the service called “ argocd-server ” kubectl edit svc argocd-server -n argocd Step 5 : Bef...
Read more

Linux File Permissions – Quick Short Note

Image
This is the file permissions looks like in the Linux systems There are 3 main objects. u - User (owner) g - Group (users in the same group that file owner also includes) o - Others (everyone else) Permission types  r - read w - write x - execute  How to change the file permission   We can use "chmod" command as below chmod 775 filename
Read more