-2

Is it possible to connect to remote oracle database from my laptop if I only install instant client, without installing oracle database? I have the tnsnames.ora and listener.ora files in oracle_home/network/admin which I created. I downloaded instant client, but how can I connect to the database by sqlcplus client. My system just does not recognize sqlplus command

I also did this

LD_LIBRARY_PATH=/ORACLE_HOME export LD_LIBRARY_PATH

  • And what have you tried to do? If you installed oracle client and you have correct tnsnames.ora, SQL*Plus should work. Also there is an useful utility - tnsping, it helps sometimes. – Dmitriy Apr 18 '15 at 9:40
2

SQL*Plus is not part of the basic Instant Client, it is an additional download at the Instant Client download page. Once you have downloaded and installed it, you can use it by setting the ORACLE_HOME and PATH envrionment variables, for example:

export ORACLE_HOME=/oracle/base/product/11.2.0/client_1
export PATH=$ORACLE_HOME/bin:$PATH

Or on a Windows OS:

set ORACLE_HOME=C:\oracle\base\product\11.2.0\client_1
set PATH=%ORACLE_HOME%\bin;%PATH%

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.