4 Replies Latest reply: Jan 14, 2014 4:54 AM by yoonas RSS

Oracle 11g XE: sqlplus - tnsnames - server and client

slsam01 Newbie
Currently Being Moderated



I installed Oracle 11g XE on Windows 7 Home Premium.

After installation, I see the server installed and I can use sqlplus to connect to the database. I also see tnsnames.ora. Both of the sqlplus and tnsnames.ora are part of the server.


Some questions:

1. Does Oracle 11g XE has a corresponding client software?

2. Oracle client also has sqlplus and tnsnames.ora. What are the difference in the sqlplus and tnsnames.ora between server and client?


Many thanks!


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