linux下，以oracle超级帐号启动

[laogou2]

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


我怎么停止其中一个?

[laogou2]

linux启动了两个oracle服务，如何停止其中之一？

[oracledbalgtu]

1。create pfile from spfile;
2。编辑pfile,把*.diapatchers= 项删掉;
3。shutdown immediate
4。create spfile from pfile;
5。startup


[Quote=引用楼主 laogou2 的帖子:]
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 F…
[/Quote]

[laogou2]

修改pfile和spfile文件？

[ruihuahan]

sqlplus 中把其中一个 shutdowon

[laogou2]

[Quote=引用 4 楼 ruihuahan 的回复:]
sqlplus 中把其中一个 shutdowon
[/Quote]
具体怎么做呢？

[范佩西_11]

sqlplus /nolog
conn sys@ora9i as sysdba;
shutdown normal;

[sailing0123]

sqlplus /nolog
conn sys/sys@ora9i as sysdba;
shutdown immediate

[laogou2]

现在知道了，是两个实例名，但是是同一个数据库的ID,只能停实例，不能停数据库