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

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

    slsam01

      Hello,

       

      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!