TNS
简介TNS
TNS 是一家全球性的市场研究与资讯集团。
我们的战略目标是，成为全球公认的增值资讯和洞见服务的业界领袖，帮助客户做出卓有成效的决策。
作为领先的行业见解专家，我们的员工为全球性机构及世界各地的客户提供创意见解和卓越服务。通过覆盖70多个国家和地区的全球网络，我们与客户携手，满足他们对高品质信息、分析和远见的需求。
作为全球最重要的定制研究及分析服务供应商，我们将对行业的深刻理解与多个领域的世界级专业技术紧密结合，这些领域包括新产品开发、市场细分与市场定位研究、品牌与广告研究以及利益相关人管理。此外，我们也是消费者零售研究、媒体监测与因特网、电视和广播受众调查服务的主要供应商。
详细介绍Oracle：TNS
Oracle中TNS的完整定义：transparence Network Substrate透明网络底层，监听服务是它重要的一部分，不是全部，不要把TNS当作只是监听器
ORACLE当中，如果想访问某个服务器，必须要设置TNS，它不像SQL SERVER那样在客户端自动列举出在局域网内所有的在线服务器，只需在客户端选择需要的服务器，然后使用帐号与密码登录即可。而ORCAL不能自动列举出网内的服务器，需要通过读取TNS配置文件才能列出经过配置的服务器名。
配置文件名一般为：tnsnames.ora
存取路径: $ORACLE_HOME
etworkadminnsnames.ora
eg:# TNSNAMES.ORA Network Configuration File: C:oracleora81
etworkadminnsnames.ora
# Generated by Oracle configuration tools.
ODS =
(description =
(address = (protocol = tcp)(host = 10.201.64.12)(port = 1521))
(connect_data =
(sid = ods)
)
)
AUTOCLM_10.210.4.11 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.4.11)(PORT = 1521))
)
(CONNECT_DATA =
(SID = autoclm)
(SERVER = DEDICATED)
)
)
PROPTEST_10.210.4.30 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.4.30)(PORT = 1521))
)
(CONNECT_DATA =
(SID = proptest)
(SERVER = DEDICATED)
)
)
p05 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.201.64.14)(PORT = 1521))
)
(CONNECT_DATA =
(SID = p05)
(SERVER = DEDICATED)
)
)
p05_8 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.201.64.8)(PORT = 1521))
)
(CONNECT_DATA =
(SID = p05)
)
)
ODS =
(description =
(address = (protocol = tcp)(host = 10.201.64.8)(port = 1521))
(connect_data =
(sid = p05)
)
)
test_14 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.201.64.14)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = p05test)
)
)
CIBS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.68.71)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cibs)
)
)
ORA10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.202.1.77)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORA10)
)
)
CIBS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.68.71)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cibs)
)
)
CAI =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.68.80)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = proplh)
)
)
CHELP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.68.137)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = autoclm)
)
)
配置完毕后，客户端就可以列举出|"ODS",”P05”,"CAI”，"CHELP”，“CIBS”等的服务器名出来。