我在SUSE上都装了Oracle11g。当我想在window上访问SUSE上的Oracle时遇到了麻烦。
我用netca试图建立一个连接,但是报TNS-12541错误。
第一感觉是SUSE上的监听器没有打开,然我去查看了lsnrctl的状态和listenter.ora的配置:
status如下:
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 18-JUL-2010 20:22:42
Uptime 0 days 0 hr. 19 min. 38 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/db/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/db/oracle/diag/tnslsnr/linux-ook6/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 3 handler(s) for this service...
Service "orcl.site" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.site" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
===========================================================================
listenter.ora文件配置如下:
# listener.ora Network Configuration File: /home/oracle/db/oracle/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux-ook6)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=
(SID_NAME=orcl)
(ORACLE_HOME=/home/oracle/db/oracle/product/11.1.0/db_1)
(PRESPAWN_MAX=20)
(PRESPAWN_LIST=
(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
)
)
)
==========================================================================
1521端口状态如下:
oracle@linux-ook6:~> netstat -an|grep 1521
tcp 0 0 127.0.0.1:1521 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:43457 127.0.0.1:1521 CLOSE_WAIT
tcp 0 0 127.0.0.1:1521 127.0.0.1:43453 ESTABLISHED
tcp 0 0 127.0.0.1:43456 127.0.0.1:1521 CLOSE_WAIT
tcp 0 0 127.0.0.1:17361 127.0.0.1:1521 CLOSE_WAIT
tcp 0 0 127.0.0.1:17324 127.0.0.1:1521 CLOSE_WAIT
tcp 0 0 127.0.0.1:17323 127.0.0.1:1521 CLOSE_WAIT
tcp 0 0 127.0.0.1:43453 127.0.0.1:1521 ESTABLISHED
tcp 0 0 127.0.0.1:17360 127.0.0.1:1521 CLOSE_WAIT
unix 3 [ ] STREAM CONNECTED 41521
=============================================================================
oracle实例名等如下:
NAME VALUE
---------------------------------------- ---------------------------------------
global_names FALSE
service_names orcl.site
db_name orcl
====================================================================
在windows的ping IP正常,ping 1521端口正常。
我现在遇到的状况是:
用windows TNS-12541:无监听程序
那位高人能解决,不胜感激!!。。。。。。5555555555,裸地等回复。