oracle无法解析指定的连接标识符

oracle数据库安装在其他电脑上，自己的电脑上安装oracle客户端，这时下面的

代码可以连上数据库，把数据导出来。

echo 导出数据库数据
set user=username
exp %user%/password@abc file=E:/数据库备份/%user%-%date%.db

但是如果再在本机上安装服务器端，发现下面错误（ORA-12154：TNS：无法解析指定的连接标示符）。

解决方法是，打开client安装目录下network->admin下的tnsnames.ora文件

内容如下：

# tnsnames.ora Network Configuration File: F:/oracle/product/10.2.0/client_2/NETWORK/ADMIN/tnsnames.ora
# Generated by Oracle configuration tools.

abc =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = orcl)
      (SERVER = DEDICATED)
    )
  )

127.0.0.1_LOCALLOST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Locallost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = 127.0.0.1)
      (SERVER = DEDICATED)
    )
  )

ORCL_LOCALHOST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = orcl)
      (SERVER = DEDICATED)
    )
  )

把红色字体部分，拷贝到服务器端的安装目录下network->admin下的tnsnames.ora文件。如下所示：

# tnsnames.ora Network Configuration File: F:/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 74B5853F2D1648B)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

abc =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = orcl)
      (SERVER = DEDICATED)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )

修改后，发现可以连接数据库了。