日期:2014-05-16  浏览次数:20411 次

oracle连接实例配置
配置连接文件参考:
# tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

60 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 数据库ip地址)(PORT = 数据库服务端口))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = testdb)
    )
  )

61 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 数据库ip地址)(PORT = 数据库服务端口))
    )
    (CONNECT_DATA =
      (SID = testdb)
    )
  )

注:60,61为服务的名称,可以自己随意设定