tnsnames.ora数据库连接的设置

D:/oracle/ora9/network/admin/tnsnames.ora

里面有个这样的一个文件，通过设置它可以方便sql plus的登陆，具体由一些什么样的应用，或者，具体怎么使用dblink进行操作，我还要研究一下，发现oracle似乎比sql server复杂很多。

# TNSNAMES.ORA Network Configuration File: D:/oracle/ora9/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = overmind)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

OVERMIND =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = overmind)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = overmind)
    )
  )

BV_210 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 210.74.178.23)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = bv)
    )
  )