tnsnames.org

今天为了连接到SERVER2机器上的Oracle数据库，修改了network\admin\下的tnsnames.org文件

…………

SERVER1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = SERVER1)
    )
  )
     SERVER2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = SERVER2)
    )
  )

连接失败，仔细检查才知道竟然是因为修改时在代码前面不小心留了空格