C:\Users\PARADISE>tnsping 192.168.1.113:1521/orclTNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 14-1月 - 2015 20:08:21Copyright (c) 1997, 2010, Oracle. All rights reserved.已使用的参数文件: D:\Oracle\product\11.2.0\client\network\admin\sqlnet.ora已使用 EZCONNECT 适配器来解析别名 尝试连接 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=orcl))(ADDRESS=(PROTOCOL=TCP)( HOST=192.168.1.113)(PORT=1521))) OK (50 毫秒)
tnsping 192.168.1.113:1521/orcl
2、确认你能访问到服务器IP,可以ping测试PS.楼上tnsping对即使客户端或许无用的
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl)
)
),配置后重启监听,客户端就可以连接了,不知道你是不是这种情况..
2015 20:08:21Copyright (c) 1997, 2010, Oracle. All rights reserved.已使用的参数文件:
D:\Oracle\product\11.2.0\client\network\admin\sqlnet.ora已使用 EZCONNECT 适配器来解析别名
尝试连接 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=orcl))(ADDRESS=(PROTOCOL=TCP)(
HOST=192.168.1.113)(PORT=1521)))
OK (50 毫秒)
多次安装oracle的产品,此变量会相应变化,
导致客户端读取的tnsname配置文件不是目前配置的tns文件