在一台linux服务器上安装了oracle10,服务器上访问没有问题,但客户端无法链接,提示ora-12170。
我看监听器都是正常的啊:如下,我链接的是hmis
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-SEP-2008 19:36:36Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 23-SEP-2008 19:20:41
Uptime 0 days 0 hr. 15 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/product/10g/network/admin/listener.ora
Listener Log File /home/oracle/product/10g/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "hmis" has 1 instance(s).
Instance "hmis", status READY, has 1 handler(s) for this service...
Service "hmisXDB" has 1 instance(s).
Instance "hmis", status READY, has 1 handler(s) for this service...
Service "hmis_XPT" has 1 instance(s).
Instance "hmis", status READY, has 1 handler(s) for this service...
The command completed successfully
我看监听器都是正常的啊:如下,我链接的是hmis
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-SEP-2008 19:36:36Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 23-SEP-2008 19:20:41
Uptime 0 days 0 hr. 15 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/product/10g/network/admin/listener.ora
Listener Log File /home/oracle/product/10g/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "hmis" has 1 instance(s).
Instance "hmis", status READY, has 1 handler(s) for this service...
Service "hmisXDB" has 1 instance(s).
Instance "hmis", status READY, has 1 handler(s) for this service...
Service "hmis_XPT" has 1 instance(s).
Instance "hmis", status READY, has 1 handler(s) for this service...
The command completed successfully
解决方案 »
- oracle11g+win7:ORA-12154: TNS:could not resolve the connect identifier specified
- oracle11g装完后cpu100%,我的已经正常安装了,没报错
- 继续求助,c#连接oracle提示invalid username or password
- 请教一个关于Oracle数据抽取的问题
- not exists 子句 select 什么效率最高
- 如何插入lob类型的数据
- 索引不能扩展(index can not extend。。。),怎么办?
- 请教一个存储过程。
- 关于主键设置的问题
- 请教一下关于sign的用法,最好能举个例子,谢谢拉!
- oracle 事务
- oracle的order by问题.太头疼了
然后再tnsping服务器一下,通不通?
1。将本机winxp的“控制面板-防火墙-例外”中添加1521端口。
2。HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0上新建一个字符串值:USE_SHARED_SOCKET=true都不好使
还有我看了我服务器上的1521端口是LISTENING状态,不知道跟ESTABLISHED有什么区别。
最好是关闭整个防火墙,有时候只开放1521端口可能不好用。