Question

我的Oracle用shutdown immediate不能关闭，出现了一个EMN0进程，不知道是干吗的，请高手指教

Mon Oct 10 21:26:27 2011
alter tablespace users read write
Mon Oct 10 21:26:27 2011
Completed: alter tablespace users read write
Mon Oct 10 21:37:58 2011
Starting background process EMN0
EMN0 started with pid=21, OS id=5717
Mon Oct 10 21:37:58 2011
Shutting down instance: further logons disabled
Mon Oct 10 21:37:58 2011
Stopping background process CJQ0
Mon Oct 10 21:37:58 2011
Stopping background process MMNL
Mon Oct 10 21:37:58 2011
Stopping background process MMON
Mon Oct 10 21:37:58 2011
Shutting down instance (immediate)
License high water mark = 8
Mon Oct 10 21:37:59 2011
Stopping Job queue slave processes, flags = 7
Mon Oct 10 21:37:59 2011
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Mon Oct 10 21:40:05 2011
Starting background process EMN0
Shutting down instance: further logons disabled
EMN0 started with pid=11, OS id=17886
Mon Oct 10 21:40:05 2011
Shutting down instance (immediate)
License high water mark = 8
All dispatchers and shared servers shutdown
Mon Oct 10 21:41:52 2011
Starting background process EMN0
EMN0 started with pid=12, OS id=28064
Mon Oct 10 21:41:52 2011
Shutting down instance: further logons disabled
Mon Oct 10 21:41:52 2011
Shutting down instance (immediate)
License high water mark = 8
All dispatchers and shared servers shutdown
[oracle@localhost bdump]$ tail -f alert_orcl.log
All dispatchers and shared servers shutdown
Mon Oct 10 21:41:52 2011
Starting background process EMN0
EMN0 started with pid=12, OS id=28064
Mon Oct 10 21:41:52 2011
Shutting down instance: further logons disabled
Mon Oct 10 21:41:52 2011
Shutting down instance (immediate)
License high water mark = 8
All dispatchers and shared servers shutdown
Mon Oct 10 21:46:36 2011
idle dispatcher 'D000' terminated, pid = (13, 1)
Mon Oct 10 21:49:04 2011
Starting background process EMN0
Shutting down instance: further logons disabled
EMN0 started with pid=13, OS id=30590
Mon Oct 10 21:49:04 2011
Shutting down instance (immediate)
License high water mark = 8
All dispatchers and shared servers shutdown
Mon Oct 10 21:54:10 2011
SHUTDOWN: Active processes prevent shutdown operation
Mon Oct 10 21:59:44 2011
Shutting down instance (abort)
License high water mark = 8
Termination issued to instance processes. Waiting for the processes to exit
Mon Oct 10 21:59:54 2011
Instance termination failed to kill one or more processes
Instance terminated by USER, pid = 27064
我的系统是Linux RedHat5.3，Oracle版本是10.2.0.4，用expdp工具导出了users表空间，然后用scott用户创建了一个分区表，然后关闭数据库时出现了这个问题。出现了一个EMN0进程不知道是干什么的，后面出现的EMN0进程是因为我关不掉数据库时多次使用了shutdown immediate命令。最后不得已用shutdown abort关闭了数据库

Answer 1

关于EMN0 “This message occurs because there is a trigger which is installed with the JVM that fires at shutdown that 'wakes' up the EMN0 process. By itself, the message shouldn't be a concern.”所以不用关注这个。

使用shutdown immediate 关闭数据库时，发生数据库假死的大部分原因都是因为回滚大失误造成的，所以建议你在执行此语句之前使用 alter system checkpoint;

在我们现网的环境中shutdown immediate使用是很谨慎的，需要首先停掉数据库监听器，将JOB队列参数设置成0，然后手工杀掉所有的ORACLE 用户SESSION后，在执行 alter system checkpoint 然后在 shutdown immediate。

Answer 2

显示2一般是认为命令没有输入完成，你可以加一个;试一下，不过实际上shutdown immediate这个命令并不需要加;的，你试试吧。我的版本是10g。但愿能帮到xjl09830更多尽在365testing,测评网,51cto

Answer 3

显示2一般是认为命令没有输入完成，你可以加一个;试一下，不过实际上shutdown immediate这个命令并不需要加;的，你试试吧。我的版本是10g。xjl09830希望有所提示，有空到IT168,IT实验室,天天软件测试网进一步交流!