1 Reply Latest reply: Oct 19, 2011 12:21 AM by Hemant K Chitale RSS

    TNSNAMES.ORA

    890463
      Hi All,

      I am a newbie to the world of Database.

      Can you please tell me where the TNSNAMES.ORA should reside

      Regards,
      User

      Edited by: 887460 on Oct 18, 2011 9:31 PM
        • 1. Re: TNSNAMES.ORA
          Hemant K Chitale
          On the "client". The client may be a Windows desktop or a big Linux/Unix Application Server.

          However, in recent versions, the TNSNAMES.ORA file is not mandatory as there are other options.
          The TNSNAMES is one of several naming methods.
          The connect descriptor can be provided on the command line itself, thus not requiring a tnsnames.ora file.
          EZCONNECT strings also do not require a tnsnames.ora file.


          See "Understanding Naming Methods" at http://download.oracle.com/docs/cd/E11882_01/network.112/e10836/concepts.htm#CIAHJEDI
          and the chapter "Configuring Naming Methods" at http://download.oracle.com/docs/cd/E11882_01/network.112/e10836/naming.htm#i507143


          Hemant K Chitale