环境:服务器端和客户端分别在两台电脑上,都是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.oraSQLNET.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>>>
从下午到现在,一直没有弄好- -
求指导
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.oraSQLNET.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>>>
从下午到现在,一直没有弄好- -
求指导
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货