1.这段时间 研究了 oracle 的 sid 和 service_name
分享出来 ,
DZJ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.230.31.15)(PORT = 1521))
)
(CONNECT_DATA =
(SID = oradb1)
)
)
31.15 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.230.31.15)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oradb)
)
)
总结,两总 写法 其实都可以,service_name 代表 全局数据库名,sid 为数据库实例名