It defines the application can connect to which database,server address using which port . its for reference of database.
The web.config file is for webpages not for the database.
a typical entry in tnsname.ora file is as follows.
----------------------------------------------------------------------
-
OM =
-
(DESCRIPTION =
-
(ADDRESS = (PROTOCOL = TCP)(HOST = is-18)(PORT = 1521))
-
(CONNECT_DATA =
-
(SERVER = DEDICATED)
-
(SERVICE_NAME = Om)
-
)
-
)
-
-
EXTPROC_CONNECTION_DATA =
-
(DESCRIPTION =
-
(ADDRESS_LIST =
-
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
-
)
-
(CONNECT_DATA =
-
(SID = PLSExtProc)
-
(PRESENTATION = RO)
-
)
-
)
-
-
MES =
-
(DESCRIPTION =
-
(ADDRESS_LIST =
-
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.15.3)(PORT = 1521))
-
)
-
(CONNECT_DATA =
-
(SID = MES)
-
)
-
)
-
-
BDCORA =
-
(DESCRIPTION =
-
(ADDRESS_LIST =
-
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.12.16)(PORT = 1521))
-
)
-
(CONNECT_DATA =
-
(SERVICE_NAME = orcl1)
-
)
-
)
-
-
MESTEST =
-
(DESCRIPTION =
-
(ADDRESS_LIST =
-
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.14.155)(PORT = 1521))
-
)
-
(CONNECT_DATA =
-
(SERVICE_NAME = MESTEST)
-
)
-
)
-