Quickest way to set up the Oracle Instant Client for sqlplus access to the Oracle Database

Need quick and immediate access to SQL*Plus (i.e., sqlplus) from your Linux server?

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

2. Download these files:

  • instantclient-basic-linux.x64-21.5.0.0.0dbru.zip
  • instantclient-sqlplus-linux.x64-21.5.0.0.0dbru.zip

3. Unzip the software:

unzip instantclient-basic-linux.x64-21.5.0.0.0dbru.zip

unzip instantclient-sqlplus-linux.x64-21.5.0.0.0dbru.zip

4.   Connect:

cd instantclient_21_5

./sqlplus username@dbhost:1521/dbname