Sample tns entry in tnsnames.ora network file

Following are the sample entry for tns in tnsnames.ora file

Go to the location ORACLE_HOME/rdbms/admin

Then find the tnsnames.ora file in Oracle and open in edit mode and add the new entery as follows:

MYSIDNAME=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = SIDNAME)
    )
  )

NETCA is used to make tns entry in Oracle. Open the NETCA app with netca command at command prompt and follow the link

Create TNS entry in TNSNAMES.ORA file with NETCA Utility