Using the SQL*Plus Instant Client

Now that you have the Oracle SQL*Plus Instant Client installed, here's the quickest way to start using it. (Installation instructions on this blog post.)

# Set the environment variables to your local installation

export SQLPLUS_HOME=/u01/sqlplus/instantclient_21_5
export TNS_ADMIN=${SQLPLUS_HOME}
export LD_LIBRARY_PATH=${SQLPLUS_HOME}


# Call SQL*Plus

${SQLPLUS_HOME}/sqlplus dbusername@dbhost:1521/dbservucebane


# Call SQL*Plus with password on prompt

${SQLPLUS_HOME}/sqlplus dbusername/welcome1@//dbhost:1521/dbservicename