关于TNSNAMES.ORA中SERVICE_NAME，SID的一点理解

最新推荐文章于 2022-01-16 16:45:58 发布

iteye_11495

最新推荐文章于 2022-01-16 16:45:58 发布

阅读量502

点赞数

文章标签：数据库网络

本文详细解释了TNSNAMES.ORA配置文件中的SERVICE_NAME与SID的区别及用法，特别关注RAC环境中如何通过配置指定实例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

关于TNSNAMES.ORA中SERVICE_NAME，SID的一点理解
SID只指定一个实例，而SERVICE_NAME在RAC环境中指定多个实例。
如下，该配置指定了一个节点的HOST：
RAC1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.12.16)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = RAC)
)
)

如下，运行在10.122.12.16的实例是rac1:
[oracle@RAC01 ~]$> 64 bytes from RAC01 (10.122.12.16): icmp_seq=2 ttl=64 time=0.026 ms

--- RAC01> [oracle@RAC01 ~]$ ps -ef| grep ora_
oracle 1981 1 0 Jun19 ? 00:02:01>
以下有更详细的解释，转载自http://www.dba-oracle.com/t_oracle_sid_instance_name_service_name.htm
Question: What> (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(HOST = 123.45.6789)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER=dedicated)
(SERVICE_NAME => (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(HOST => )
)
(CONNECT_DATA = (SID =>
NAME VALUE
------- ----------------------------------------------
db_name>
select
> (DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST => )
(CONNECT_DATA =
(SERVICE_NAME => (SID_LIST =
(SID_DESC =
(SID_NAME => )
(SID_DESC =
(GLOBAL_DBNAME => (SID_NAME = mysid)
)
)
)

global_name - If>
select *
from
global_name;

GLOBAL_NAME
---------------------------------------
MYSID.REMOTE.DBA.NET