This discussion is archived
2 Replies Latest reply: Dec 20, 2011 3:19 AM by 423410 RSS

How to use Oracle instant client to run sqlplus

user12048533 Newbie
Currently Being Moderated
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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points