虚拟机linux地址192.168.92.2上安装了oracle;本机winxp装客户端。当tnsping 192.168.92.2时,出现以下提示:已使用 HOSTNAME 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=192.168.92.2))(AD
DRESS=(PROTOCOL=TCP)(HOST=192.168.92.2)(PORT=1521)))
TNS-12560: TNS: 协议适配器错误客户端tnsnames.ora如下:
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
服务器端listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = orcl)
(ORACLE_HOME = /home/oracle/product/10.1)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)搞不懂为什么这样,还有别的地方需要查看的吗
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=192.168.92.2))(AD
DRESS=(PROTOCOL=TCP)(HOST=192.168.92.2)(PORT=1521)))
TNS-12560: TNS: 协议适配器错误客户端tnsnames.ora如下:
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
服务器端listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = orcl)
(ORACLE_HOME = /home/oracle/product/10.1)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)搞不懂为什么这样,还有别的地方需要查看的吗
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货