linux下,以oracle超级帐号启动
输入
LSNRCTL> status
显示如下:
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 08-OCT-2008 10:27:37
Uptime 14 days 3 hr. 10 min. 50 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /opt/ora9/product/9.2/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "ora9iXDB" has 1 instance(s).
Instance "ora9i", status READY, has 1 handler(s) for this service...
Service "sy" has 1 instance(s).
Instance "ora9i", status READY, has 1 handler(s) for this service...
The command completed successfully
我怎么停止其中一个?
输入
LSNRCTL> status
显示如下:
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 08-OCT-2008 10:27:37
Uptime 14 days 3 hr. 10 min. 50 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /opt/ora9/product/9.2/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "ora9iXDB" has 1 instance(s).
Instance "ora9i", status READY, has 1 handler(s) for this service...
Service "sy" has 1 instance(s).
Instance "ora9i", status READY, has 1 handler(s) for this service...
The command completed successfully
我怎么停止其中一个?
1。create pfile from spfile;
2。编辑pfile,把*.diapatchers= 项删掉;
3。shutdown immediate
4。create spfile from pfile;
5。startup
用sql语句关闭一个数据库就ok 了吧!