TNS 无法处理服务名

使用oracle的时候,有时候碰到 tns 无法处理服务名的问题.其实很简单.

例如我用workflow登陆mecon数据库的时候就报这个错误.

第一 找到tnsnames.ora文件.

例如

GSXYDJ =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.102)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = gsxydj)(SERVER = DEDICATED))
  )

第二:

增加

databasename =

  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = databaseip)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = databasesid)(SERVER = DEDICATED))
  )