tnsping:TNS-03505 无法解析名称 pl/sql:ora-:2154
环境:服务器端和客户端分别在两台电脑上,都是XP系统,都是11g。
客户端的tnsnames.ora文件
ORCL_85 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.85)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
listener.ora
LISTENER2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.85)(PORT = 1521))
)
服务器端的tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
用sqlplus登录返回
ERROR:
ORA-12154:TNS:无法解析指定的标识符
用tnsping orcl85返回
tnsping:TNS-03505
用tnspoing 192.168.0.85(服务器IP)返回
已使用HOSTNAME适配器来解析别名
Attempting to contact <DESCRIPTION=<CONNECT_DATA=<SERVICE_NAME=>><ADDRESS=<PROTOCOL=TCP><HOST=192.168.0.85><PORT=1521>>>
从下午到现在,一直没有弄好- -
求指导