2 Replies Latest reply: Dec 20, 2011 5:19 AM by Sudheendra-Oracle RSS

    How to use Oracle instant client to run sqlplus

    user12048533
      I installed Oracle Client 11.2. I noticed that there is a sqlplus command that I can use to test the database connection. How do I run it without a tnsnames.ora file?

      Well, I put a tnsnames.ora file under $ORACLE_HOME,

      when I invoke sqlplus, It gives me this error:

      Enter user-name: user/password@testdb
      ERROR:
      ORA-12154: TNS:could not resolve the connect identifier specified

      How can I test the connection?

      Thanks a lot!