how to create Tnsnames.ora

[19972003]

Any one knows how to configure the oracle client version 11 to talk to the Oracle Server? the Client is install on Sql 2005 server, I am sorry if I post the article in the wrong forum list.

many thanks,

 

[jaxtell]

My tnsnames.ora file is located at \oracle\product\10.2.0\client\Network\Admin
Find the corresponding location on your server. The structure of tnsnames.ora should look like

<MYDB> = 
  (DESCRIPTION = 
    (ADDRESS = 
      (PROTOCOL = TCP)
      (HOST = <localhost>)
      (PORT = 1521)
    )
    (CONNECT_DATA = 
      (SERVICE_NAME = <DBNAME>)
    )
  )

replace the <> with what makes sense for your database. You might need to change protocol and port too, depending on your setup. If you need additional information, try the Oracle release 11g forum.

 

[19972003]

my oracle instant client version 11 is installed in C:\oracle\InstantClient and I don't have Network\Admin folder anything like that, where would I put the TNSnames.ora file?

Many thanks,