急急 ora10 客户端无法连接数据库 无法解析指定的连接标识符

Question

安装成功oracle 10 客户端后，修改文件sqlnet.ora 如下

sqlnet.ora Network Configuration File: E:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\sqlnet.ora

Generated by Oracle configuration tools.

This file is actually generated by netca. But if customers choose to

install "Software Only", this file wont exist and without the native

authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)

tnsnames.ora 如下

tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora

Generated by Oracle configuration tools.

FXM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

MYJ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.19.6.197)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
使用sql plus 连接数据库总是报错无法解析指定的连接标识符 什么原因怎么办

Answer 1

重新安装吧，记得完全卸载，删除注册表。这个可能是因为服务端客户端的字符集不同引起的。网上也有很多解决办法，我当时按照别人的方法解决好像并没有什么效果