tnsname.ora里面的连接配置不对

你修改一下连接配置

If you are using local naming (TNSNAMES.ORA file):
//      - Make sure that "TNSNAMES" is listed as one of the values of the
//        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
//        (SQLNET.ORA)
//      - Verify that a TNSNAMES.ORA file exists and is in the proper
//        directory and is accessible.
//      - Check that the net service name used as the connect identifier
//        exists in the TNSNAMES.ORA file.
//      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
//        file.  Look for unmatched parentheses or stray characters. Errors
//        in a TNSNAMES.ORA file may make it unusable.

可能有两种原因：

1、客户端安装的电脑是否有另一个版本的Oracle？（包括Server/Client）

有的话，卸载，只剩一下Oracle92 Server/Client

2、tnsnames.ora（￥:\oracle\product\10.2.0\network\ADMIN）配置错误

最简单的方法：可考虑 Copy 服务端的 tnsnames.ora 到客户端去使用，当然，要修改HOST值。