虚拟机linux下TNSPING不通
[oracle@localhost Desktop]$ tnsping 192.168.100.230TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 21-AUG-2015 21:48:49Copyright (c) 1997, 2009, Oracle. All rights reserved.Used parameter files:Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.230)(PORT=1521)))
TNS-12541: TNS:no listener但是WINDOWS能TNSPING通。。
LINUX的LISTENER如下LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.213)(PORT = 1521))
)SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = ORCL)
)
)ADR_BASE_LISTENER1 = /home/oracle/app/oracle
LINUX tnsname:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.213)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)windows:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.213)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)linux _hosts:
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6~
~
~
[oracle@localhost Desktop]$ tnsping 192.168.100.230TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 21-AUG-2015 21:48:49Copyright (c) 1997, 2009, Oracle. All rights reserved.Used parameter files:Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.230)(PORT=1521)))
TNS-12541: TNS:no listener但是WINDOWS能TNSPING通。。
LINUX的LISTENER如下LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.213)(PORT = 1521))
)SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = ORCL)
)
)ADR_BASE_LISTENER1 = /home/oracle/app/oracle
LINUX tnsname:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.213)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)windows:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.213)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)linux _hosts:
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6~
~
~
解决方案 »
- XML数据文件怎么导入到Oracle数据库中?
- 在Windows下面使用sqlldr把数据导入Oracle
- oracle的regExp_like函数 如何匹配出“多行(大于一行的)的记录”
- oracle 创建物化视图的问题:多个主体站点
- Oracle网站上提供下载的Oracle数据户服务器软件是否有使用限制
- hoho 调查调查
- 有什么方法能查询基于函数的索引的定义吗?
- 请问:VC中如何用ADO访问远程的(局域网)的oracle 数据库?[万分着急]
- 关于oracle分区表删除分区的问题
- centOS安装oracle 报这个错误是什么意思??
- ORA-00904 标识符无效
- 从oracle8升级到11后,信息系统内的用户就不能修改自己的密码了,能帮我看看吗?
TNSPING 127.0.0.1 不能通过
-- 应该 ping 你的 服务名,不是 IP地址,你试试下面的。
C:\>TNSPING ORCL