首先是listener。ora的内容
lISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = 100.100.100.100)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oradata/product/9.2.0.4)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ora9204)
(ORACLE_HOME = /oradata/product/9.2.0.4)
(SID_NAME = oracle)
)
)
然后是tnsnames。ora的配置单
SMSRemote =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 100.100.100.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora9204)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = charvi)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
运行lsnrctl start 后:
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 27-JUN-2008 11:37:15
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /oradata/product/9.2.0.4/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Log messages written to /oradata/product/9.2.0.4/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(P
ORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 27-JUN-2008 11:37:15
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /oradata/product/9.2.0.4/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
问题就出来了:”The listener supports no services“
我要启动监听的目的是因为我在sqlnet.ora中写了限制了特定的IP才可以访问oracle的语句,需要重启监听,但启动不了,也限制不了IP,望大家指点迷津啊~~谢谢
shenhua_sjp 于 2008-08-06 17:44:08发表:
监听没有配置
su - oracle以后
使用netca配置监听程序
然后在lsnrctl start 便会启动起来的。。。。
magicianbobo 于 2008-06-30 14:58:12发表:
真让我这个小菜鸟失望,原本想请教下这个论坛的高人,结果。。。唉。人就是这样。。。说不清的
magicianbobo 于 2008-06-27 17:09:49发表:
no one can give me a help?