环境：winxp Oracle10g配置文件
-------------------------------------------------------------------------------------------------------------------
# tnsnames.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.# (SERVER = DEDICATED) PLSExtProcORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=aaaa3)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL))(HS=OK))# ORCL=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=aaaa3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)-------------------------------------------------------------------------------------------------------------------# sqlnet.ora Network Configuration File: d:\oracle\product\10.2.0\db_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, EZCONNECT)# SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)# NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)-----------------------------------------------------------------------------------------------------------------# listener.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools. PLSExtProcSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = aaaa3)(PORT = 1521))
)
)------------------------------------------------------------------------------------------------------------------
服务器和客户端的配置文件如上（本地计算机）sql plus 连接没问题现在的问题是：Oracle10g Designer 死活连接不上UserName：sys
Password： xxx
Connect String：ORCL AS SYSDBA错误提示：TNS：无法解析我的凝问：
按道理来说SQLPLUS 连接没问题的话 Designer 应该就没问题了
因为这说明 tnsname 等参数文件已配置正确了。但 Designer 为什么连不上呢？请高手帮帮了，谢谢！！
-------------------------------------------------------------------------------------------------------------------
# tnsnames.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.# (SERVER = DEDICATED) PLSExtProcORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=aaaa3)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL))(HS=OK))# ORCL=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=aaaa3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)-------------------------------------------------------------------------------------------------------------------# sqlnet.ora Network Configuration File: d:\oracle\product\10.2.0\db_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, EZCONNECT)# SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)# NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)-----------------------------------------------------------------------------------------------------------------# listener.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools. PLSExtProcSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = aaaa3)(PORT = 1521))
)
)------------------------------------------------------------------------------------------------------------------
服务器和客户端的配置文件如上（本地计算机）sql plus 连接没问题现在的问题是：Oracle10g Designer 死活连接不上UserName：sys
Password： xxx
Connect String：ORCL AS SYSDBA错误提示：TNS：无法解析我的凝问：
按道理来说SQLPLUS 连接没问题的话 Designer 应该就没问题了
因为这说明 tnsname 等参数文件已配置正确了。但 Designer 为什么连不上呢？请高手帮帮了，谢谢！！
如果测试OK，证明数据库服务没问题
UserName：sys AS SYSDBA
Password： xxx
Connect String：ORCL