SID与SERVICE_NAME的区别

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