Oracle中SID标记整个数据库管理系统实例,SERVICE_NAME标记某一数据库
AIOSS72 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 132.149.7.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oss)
)
)
TEST19 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 132.149.7.19)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
)
)
在以上tnsnames.ora配置中,即可配置实例SID,也可配置数据库SERVICE_NAME
查看SID的SQL为select * from v$instance
查看SERVICE_NAME的SQL为select * from v$database