Oracle shutdown cancelled解决
电邮接到：XXX业务系统ip_xxx库需要停库，当然我们所想到的就是登进去执行一把shutdown immediate当然我们得注意查看alert_sid.log，其中我发现
Wed Sep 19 11:23:36 GMT+08:00 2012Shutting down instance (immediate)
Wed Sep 19 11:23:36 GMT+08:00 2012Shutting down instance: further logons disabled
Wed Sep 19 11:23:39 GMT+08:00 2012Stopping background process CJQ0
Wed Sep 19 11:23:39 GMT+08:00 2012Stopping background process QMNC
Wed Sep 19 11:23:41 GMT+08:00 2012Stopping background process MMNL
Wed Sep 19 11:23:42 GMT+08:00 2012Stopping background process MMON
License high water mark = 1574
Wed Sep 19 11:23:43 GMT+08:00 2012Process OS> Errors in file /oracle/admin/jzjs/udump/jzjs_ora_18612510.trc
Wed Sep 19 11:23:47 GMT+08:00 2012Waiting for Job queue slaves to complete
Wed Sep 19 11:23:47 GMT+08:00 2012Job queue slave processes stopped
Wed Sep 19 11:28:47 GMT+08:00 2012Active call for process 12124640 user 'oracle' program 'oracle@jszwdb01'
Active call for process 15598262 user 'oracle' program 'oracle@jszwdb01'
Active call for process 10814508 user 'oracle' program 'oracle@jszwdb01'
System State dumped to trace file /oracle/admin/jzjs/udump/jzjs_ora_18612510.trc
Wed Sep 19 11:29:59 GMT+08:00 2012SHUTDOWN: waiting for active calls to complete.
Wed Sep 19 11:43:48 GMT+08:00 2012MMNL absent for 1254 secs; Foregrounds taking over
Wed Sep 19 12:25:04 GMT+08:00 2012SHUTDOWN: Active sessions prevent database close operation
Wed Sep 19 12:25:04 GMT+08:00 2012Instance shutdown cancelled
因为我没有通过kill当前的job，印象中Oracle shutdown，如果在30分钟还有一些job无法关闭的话，那么数据库将取消停库操作，那么我们看时间从11:23到12:25都一个小时了，那么我执行一下alter system checkpoint;然后在切一下日志alter system switch logfile;
那我现在将当前消耗数据库PGA占用内存进程找出来，然后kill掉，再进行停库操作。
jszwdb01 $ ps -ef |grep -i local
oracle2359530 1 0 12:49:51 -0:00 oraclejzjs (LOCAL=NO)
oracle2621506 1 0 12:55:52 -0:05 oraclejzjs (LOCAL=NO)
oracle2818050 1 0 12:55:41 -0:01 oraclejzjs (LOCAL=NO)
oracle3408120 1 0 14:18:15 -0:00 oraclejzjs (LOCAL=NO)
oracle4522014 1 1 12:55:49 -0:41 oraclejzjs (LOCAL=NO)
oracle4587542 139 12:54:15 - 22:25 oraclejzjs (LOCAL=NO)
oracle4784346 1 0 12:54:12 -0:02 oraclejzjs (LOCAL=NO)
oracle5505164 1 0 13:30:41 -0:00 oraclejzjs (LOCAL=NO)
oracle5636152 1 0 12:55:48 -0:01 oraclejzjs (LOCAL=NO)
oracle6160434 1 0 12:52:34 -0:00 oraclejzjs (LOCAL=NO)
oracle6553610 1 0 13:10:09 -0:01 oraclejzjs (LOCAL=NO)
oracle7274674 1 0 13:08:01 -0:30 oraclejzjs (LOCAL=NO)
oracle7340092 1 0 12:52:22 -0:00 oraclejzjs (LOCAL=NO)
oracle7667964 1 0 12:53:31 -0:00 oraclejzjs (LOCAL=NO)
oracle7798852 1 0 12:53:30 -0:00 oraclejzjs (LOCAL=NO)
oracle8192200 1 0 13:12:02 -0:07 oraclejzjs (LOCAL=NO)
oracle8585360 1 1 12:56:08 -0:27 oraclejzjs (LOCAL=NO)
oracle9764988 1 3 14:23:21 -0:00 oraclejzjs (LOCAL=NO)
oracle9896124 1 0 13:54:22 -0:00 oraclejzjs (LOCAL=NO)
oracle 10420372 1 0 14:23:27 -0:00 oraclejzjs (LOCAL=NO)
oracle 10879002 111 14:23:31 -0:01 oraclejzjs (LOCAL=NO)
oracle 11010194 1 0 14:02:04 -0:00 oraclejzjs (LOCAL=NO)
oracle 11927590 1 0 13:28:43 -0:28 oraclejzjs (LOCAL=NO)
oracle 12124250 1 0 13:02:06 -0:35 oraclejzjs (LOCAL=NO)
oracle 12320884 1 0 14:18:01 -0:00 oraclejzjs (LOCAL=NO)
oracle 12386336 129 14:23:38 -0:00 oraclejzjs (LOCAL=NO)
oracle 12517476 1 0 12:55:56 -0:00 oraclejzjs (LOCAL=NO)
oracle 12910716 1 7 14:23:38 -0:00 oraclejzjs (LOCAL=NO)
oracle 13041816 1 0 12:56:50 -0:39 oraclejzjs (LOCAL=NO)
oracle 13238522 1 0 13:31:07 -0:17 oraclejzjs (LOCAL=NO)
oracle 13303974 1 3 13:13:23 -1:04 oraclejzjs (LOCAL=NO)
oracle 13566110 1 0 13:07:44 -0:35 oraclejzjs (LOCAL=NO)
oracle 13959228 1 0 12:51:06 -0:00 oraclejzjs (LOCAL=NO)
oracle 14024728 1 0 12:55:40 -0:00 oraclejzjs (LOCAL=NO)
oracle 14155852 197 14:16:40 -2:53 oraclejzjs (LOCAL=NO)
oracle 14221556 1 0 13:00:24 -0:00 oraclejzjs (LOCAL=NO)
oracle 14418054 1 0 13:31:23 -0:21 oraclejzjs (LOCAL=NO)
oracle 14549176 1 0 13:57:40 -0:00 oraclejzjs (LOCAL=NO)
oracle 14811282 1 0 12:55:37 -0:00 oraclejzjs (LOCAL=NO)
oracle 15270086 1 0 12:55:32 -0:00 oraclejzjs (LOCAL=NO)
oracle 15532084 1 0 14:20:42 -0:07 oraclejzjs (LOCAL=NO)
oracle 15663144 1 0 13:01:40 -0:02 oraclejzjs (LOCAL=NO)
oracle 15859822 1 0 14:01:42 -0:00 oraclejzjs (LOCAL=NO)
oracle 15925496 1 0 12:50:01 -0:00 oraclejzjs (LOCAL=NO)
oracle 16056396 1 0 12:55:50 -0:02 oraclejzjs (LOCAL=NO)
oracle 16121998 1 0 13:49:22 -0:29 oraclejzjs (LOCAL=NO)
oracle 16253012 1 0 12:50:01 -0:00 oraclejzjs (LOCAL=NO)
oracle 16318596 1 0 13:51:01 -0:00 oraclejzjs (LOCAL=NO)
oracle 16580708 1 0 12:49:58 -0:00 oraclejzjs (LOCAL=NO)
oracle 16842948 1 0 13:52:31 -0:00 oraclejzjs (LOCAL=NO)
oracle 17236082 1 0 13:02:32 -0:00 oraclejzjs (LOCAL=NO)
oracle 18612376 1 1 13:31:42 -0:36 oraclejzjs (LOCAL=NO)
oracle 18677794 1 7 14:23:38 -0:00 oraclejzjs (LOCAL=NO)
oracle 19005604 1 0 13:25:50 -0:23 oraclejzjs (LOCAL=NO)
oracle 19464402 1 0 14:01:43 -0:00 oraclejzjs (LOCAL=NO)
oracle 19857510 1 1 13:13:08 -0:18 oraclejzjs (LOCAL=NO)
oracle 20119740 1 0 14:04:56 -0:00 oraclejzjs (LOCAL=NO)
oracle 20709514 1 0 12:58:15 -0:22 oraclejzjs (LOCAL=NO)
oracle 20906072 195 14:17:23 -2:52 oraclejzjs (LOCAL=NO)
oracle 22020242 1 0 13:18:26 -0:00 oraclejzjs (LOCAL=NO)
oracle 22085640 1 0 12:49:51 -0:00 oraclejzjs (LOCAL=NO)
oracle 22478916 1 1 12:49:47 -0:37 oraclejzjs (LOCAL=NO)
oracle 22610034 1 0 14:23:32 -0:00 oraclejzjs (LOCAL=NO)
oracle 22872262 169 12:53:17 - 39:07 oraclejzjs (LOCAL=NO)
oracle 23068776 1 0 12:55:54 -0:04 oraclejzjs (LOCAL=NO)
oracle 23199966 1 0 12:49:41 -0:20 oraclejzjs (LOCAL=NO)
oracle 917976 1 0 14:01:34 -0:00 oraclejzjs (LOCAL=NO)
oracle1442208 1 0 12:49:50 -0:00 oraclejzjs (LOCAL=NO)
oracle6095158 1 0 13:46:18 -0:00 oraclejzjs (LOCAL=NO)
oracle6422908 1 0 14:19:13 -0:00 oraclejzjs (LOCAL=NO)
oracle7602508 1 1 14:08:50 -0:08 oraclejzjs (LOCAL=NO)
oracle8519962 1 0 13:08:23 -0:20 oraclejzjs (LOCAL=NO)
oracle8651234 1 0 13:03:44 -0:00 oraclejzjs (LOCAL=NO)
oracle8716660 1 3 12:52:17 -3:18 oraclejzjs (LOCAL=NO)
oracle8847774 1 0 12:50:00 -0:00 oraclejzjs (LOCAL=NO)
oracle8978786 1 0 12:57:35 -0:33 oraclejzjs (LOCAL=NO)
oracle9175316 1 0 13:51:25 -0:00 oraclejzjs (LOCAL=NO)
oracle9503056 1 0 14:23:36 -0:00 oraclejzjs (LOCAL=NO)
oracle 10027454 1 0 13:04:52 -0:00 oraclejzjs (LOCAL=NO)
oracle 10158502 1 0 12:53:42 -0:39 oraclejzjs (LOCAL=NO)
oracle 11272598 1 0 12:53:20 -0:00 oraclejzjs (LOCAL=NO)
oracle 11665912 1 0 12:50:00 -0:00 oraclejzjs (LOCAL=NO)
oracle 11862278 1 0 12:50:10 -0:00 oraclejzjs (LOCAL=NO)
oracle 11927982 1 0 12:49:59 -0:00 oraclejzjs (LOCAL=NO)
oracle 12058910 1 0 12:49:59 -0:00 oraclejzjs (LOCAL=NO)
oracle 12517800 1 0 14:23:34 -0:00 oraclejzjs (LOCAL=NO)
oracle 12583308 1 0 12:49:58 -0:00 oraclejzjs (LOCAL=NO)
oracle 12648908 1 1 13:02:56 -1:32 oraclejzjs (LOCAL=NO)
oracle 13369844 1 0 13:27:56 -0:00 oraclejzjs (LOCAL=NO)
oracle 13566380 1 6 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 13894140 1 0 12:49:58 -0:00 oraclejzjs (LOCAL=NO)
oracle 14156284 1 0 12:49:58 -0:00 oraclejzjs (LOCAL=NO)
oracle 14680502 147 13:43:29 -7:14 oraclejzjs (LOCAL=NO)
oracle 14811396 1 0 14:21:08 -0:00 oraclejzjs (LOCAL=NO)
oracle 14877006 1 0 12:55:58 -0:00 oraclejzjs (LOCAL=NO)
oracle 15008008 1 0 14:00:20 -0:02 oraclejzjs (LOCAL=NO)
oracle 15270278 1 0 14:03:00 -0:00 oraclejzjs (LOCAL=NO)
oracle 15794680 1 1 13:13:58 -0:52 oraclejzjs (LOCAL=NO)
oracle 15860070 1 0 12:56:03 -0:26 oraclejzjs (LOCAL=NO)
oracle 16122238 1 0 13:03:18 -0:25 oraclejzjs (LOCAL=NO)
oracle 16253400 1 0 13:29:39 -0:18 oraclejzjs (LOCAL=NO)
oracle 16581018 1 1 13:26:05 -0:34 oraclejzjs (LOCAL=NO)
oracle 17170826 1 1 14:15:27 -0:05 oraclejzjs (LOCAL=NO)
oracle 17629678 1 0 12:49:51 -0:00 oraclejzjs (LOCAL=NO)
oracle 17760650 186 14:17:14 -2:52 oraclejzjs (LOCAL=NO)
oracle 18809334 1 1 14:14:48 -0:04 oraclejzjs (LOCAL=NO)
oracle 19202504 1 0 14:17:12 -0:00 oraclejzjs (LOCAL=NO)
oracle 20447652 1 1 14:23:33 -0:00 oraclejzjs (LOCAL=NO)
oracle 21561602 147 14:23:38 -0:00 oraclejzjs (LOCAL=NO)
oracle 21758306 1 0 13:30:35 -0:23 oraclejzjs (LOCAL=NO)
oracle 21889490 1 0 14:01:29 -0:03 oraclejzjs (LOCAL=NO)
oracle 22151430 1 0 12:55:45 -0:27 oraclejzjs (LOCAL=NO)
oracle3998328 1 0 13:15:30 -0:21 oraclejzjs (LOCAL=NO)
oracle5636712 1 0 13:04:26 -0:00 oraclejzjs (LOCAL=NO)
oracle7602710 1 0 13:30:06 -0:16 oraclejzjs (LOCAL=NO)
oracle8192690 1 0 13:16:47 -0:08 oraclejzjs (LOCAL=NO)
oracle8585886 1 0 13:13:19 -0:00 oraclejzjs (LOCAL=NO)
oracle8782554 1 0 13:05:13 -0:55 oraclejzjs (LOCAL=NO)
oracle 10683096 1 3 13:25:36 -1:44 oraclejzjs (LOCAL=NO)
oracle 11141712 126 12:58:23 - 12:32 oraclejzjs (LOCAL=NO)
oracle 11207346 1 0 14:03:10 -0:00 oraclejzjs (LOCAL=NO)
oracle 11797092 1 0 13:07:30 -0:24 oraclejzjs (LOCAL=NO)
oracle 11993654 1 6 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 12780254 1 0 13:25:11 -0:31 oraclejzjs (LOCAL=NO)
oracle 13238902 1 0 12:55:48 -0:00 oraclejzjs (LOCAL=NO)
oracle 13304380 1 0 12:55:57 -0:00 oraclejzjs (LOCAL=NO)
oracle 13370014 1 1 12:58:44 -0:53 oraclejzjs (LOCAL=NO)
oracle 13632174 1 1 14:12:23 -0:07 oraclejzjs (LOCAL=NO)
oracle 13763246 1 0 12:59:01 -0:24 oraclejzjs (LOCAL=NO)
oracle 13828792 1 0 12:52:26 -0:00 oraclejzjs (LOCAL=NO)
oracle 13959694 1 0 13:07:48 -1:39 oraclejzjs (LOCAL=NO)
oracle 14025442 1 0 12:55:43 -0:00 oraclejzjs (LOCAL=NO)
oracle 14090920 1 0 13:31:24 -0:51 oraclejzjs (LOCAL=NO)
oracle 14484032 1 0 13:04:56 -0:00 oraclejzjs (LOCAL=NO)
oracle 14811826 1 0 12:55:55 -0:00 oraclejzjs (LOCAL=NO)
oracle 14877436 1 6 12:58:20 -5:01 oraclejzjs (LOCAL=NO)
oracle 15008436 1 0 13:27:05 -0:00 oraclejzjs (LOCAL=NO)
oracle 15204948 1 0 12:55:34 -0:00 oraclejzjs (LOCAL=NO)
oracle 15270516 1 0 13:59:05 -0:00 oraclejzjs (LOCAL=NO)
oracle 15336010 1 0 13:24:23 -0:33 oraclejzjs (LOCAL=NO)
oracle 15598264 1 0 12:50:00 -0:00 oraclejzjs (LOCAL=NO)
oracle 15729278 1 0 13:47:23 -9:27 oraclejzjs (LOCAL=NO)
oracle 16188094 1 0 12:53:21 -0:32 oraclejzjs (LOCAL=NO)
oracle 16253658 1 5 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 16450278 166 14:20:12 -1:45 oraclejzjs (LOCAL=NO)
oracle 16777788 1 4 13:27:49 -0:51 oraclejzjs (LOCAL=NO)
oracle 16843362 1 0 13:14:32 -0:20 oraclejzjs (LOCAL=NO)
oracle 17039892 1 0 13:05:23 -1:25 oraclejzjs (LOCAL=NO)
oracle 17236536 1 0 14:17:02 -0:00 oraclejzjs (LOCAL=NO)
oracle 17302236 1 0 14:22:50 -0:00 oraclejzjs (LOCAL=NO)
oracle 17367780 1 0 12:49:52 -0:00 oraclejzjs (LOCAL=NO)
oracle 17498634 1 0 12:57:39 -0:41 oraclejzjs (LOCAL=NO)
oracle 17695316 1 0 12:56:34 -0:25 oraclejzjs (LOCAL=NO)
oracle 17826334 168 14:23:07 -0:15 oraclejzjs (LOCAL=NO)
oracle 17891988 1 4 14:23:38 -0:00 oraclejzjs (LOCAL=NO)
oracle 18088614 1 0 12:55:53 -0:00 oraclejzjs (LOCAL=NO)
oracle 18285114 153 14:17:32 -2:47 oraclejzjs (LOCAL=NO)
oracle 19661312 1 2 13:28:14 -0:52 oraclejzjs (LOCAL=NO)
oracle 20316706 1 0 13:08:09 -0:19 oraclejzjs (LOCAL=NO)
oracle 20447762 1 0 13:33:52 -1:03 oraclejzjs (LOCAL=NO)
oracle 20906518 1 0 14:22:54 -0:00 oraclejzjs (LOCAL=NO)
oracle 21758672 1 0 12:56:51 -0:03 oraclejzjs (LOCAL=NO)
oracle 22020860 1 2 14:23:37 -0:00 oraclejzjs (LOCAL=NO)
oracle 22086256 1 4 14:23:40 -0:00 oraclejzjs (LOCAL=NO)
oracle 22282898 1 0 13:33:26 -0:15 oraclejzjs (LOCAL=NO)
oracle1377246 1 0 12:49:45 -0:02 oraclejzjs (LOCAL=NO)
oracle1967068 1 1 13:05:32 -0:50 oraclejzjs (LOCAL=NO)
oracle5243842 1 0 14:01:58 -0:05 oraclejzjs (LOCAL=NO)
oracle5374940 1 0 13:37:15 -0:00 oraclejzjs (LOCAL=NO)
oracle5833578 1 0 12:55:51 -0:00 oraclejzjs (LOCAL=NO)
oracle9634708 1 0 12:52:29 -0:00 oraclejzjs (LOCAL=NO)
oracle9896714 1 0 12:53:24 -0:00 oraclejzjs (LOCAL=NO)
oracle 10289930 1 0 12:55:52 -0:00 oraclejzjs (LOCAL=NO)
oracle 10421016 1 0 13:22:42 -0:24 oraclejzjs (LOCAL=NO)
oracle 10814348 1 0 12:58:25 -0:00 oraclejzjs (LOCAL=NO)
oracle 10945522 1 0 12:55:30 -0:00 oraclejzjs (LOCAL=NO)
oracle 11076380 1 0 14:03:37 -0:02 oraclejzjs (LOCAL=NO)
oracle 11273050 1 0 13:24:55 -0:26 oraclejzjs (LOCAL=NO)
oracle 11797390 1 0 12:55:52 -0:00 oraclejzjs (LOCAL=NO)
oracle 12256042 1 0 12:50:44 -0:06 oraclejzjs (LOCAL=NO)
oracle 12387306 1 0 12:50:41 -0:00 oraclejzjs (LOCAL=NO)
oracle 13173522 1 0 12:50:11 -0:00 oraclejzjs (LOCAL=NO)
oracle 13370248 175 14:23:26 -0:06 oraclejzjs (LOCAL=NO)
oracle 13566852 1 0 12:50:10 -0:00 oraclejzjs (LOCAL=NO)
oracle 13960080 1 0 13:39:12 -0:01 oraclejzjs (LOCAL=NO)
oracle 14549936 1 0 12:50:00 -0:00 oraclejzjs (LOCAL=NO)
oracle 14746496 1 7 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 14942986 1 0 13:08:14 -0:43 oraclejzjs (LOCAL=NO)
oracle 15074264 1 0 12:49:59 -0:00 oraclejzjs (LOCAL=NO)
oracle 15336328 1 0 13:22:53 -0:00 oraclejzjs (LOCAL=NO)
oracle 15860600 1 0 12:49:53 -0:00 oraclejzjs (LOCAL=NO)
oracle 15926230 1 0 12:49:51 -0:00 oraclejzjs (LOCAL=NO)
oracle 17171300 1 0 14:03:18 -0:02 oraclejzjs (LOCAL=NO)
oracle 17761182 1 0 12:55:37 -0:03 oraclejzjs (LOCAL=NO)
oracle 18285448 1 0 13:18:07 -0:00 oraclejzjs (LOCAL=NO)
oracle 18940738 1 4 14:23:40 -0:00 oraclejzjs (LOCAL=NO)
oracle 20251420 1 0 14:02:01 -0:00 oraclejzjs (LOCAL=NO)
oracle 20513678 1 0 14:14:56 -0:03 oraclejzjs (LOCAL=NO)
oracle 21168936 1 0 12:50:10 -0:00 oraclejzjs (LOCAL=NO)
oracle 21365544 1 0 12:49:46 -0:01 oraclejzjs (LOCAL=NO)
oracle 21758828 1 0 12:49:45 -0:07 oraclejzjs (LOCAL=NO)
oracle 21824482 1 0 13:29:46 -0:51 oraclejzjs (LOCAL=NO)
oracle2425972 1 0 12:49:52 -0:00 oraclejzjs (LOCAL=NO)
oracle2622700 1 0 12:53:00 -0:03 oraclejzjs (LOCAL=NO)
oracle2688186 1 0 12:49:52 -0:00 oraclejzjs (LOCAL=NO)
oracle3146914 1 0 13:01:59 -0:01 oraclejzjs (LOCAL=NO)
oracle3605600 1 0 12:52:29 -0:01 oraclejzjs (LOCAL=NO)
oracle4654334 1 4 12:59:01 -0:22 oraclejzjs (LOCAL=NO)
oracle5113002 1 0 12:53:35 -0:00 oraclejzjs (LOCAL=NO)
oracle5964856 1 1 13:06:09 -0:32 oraclejzjs (LOCAL=NO)
oracle7406706 1 0 14:03:10 -0:03 oraclejzjs (LOCAL=NO)
oracle7472158 1 0 13:59:39 -0:00 oraclejzjs (LOCAL=NO)
oracle7930984 1 1 13:31:00 -0:23 oraclejzjs (LOCAL=NO)
oracle8258664 1 0 12:50:51 -0:00 oraclejzjs (LOCAL=NO)
oracle8455190 1 0 13:13:10 -0:07 oraclejzjs (LOCAL=NO)
oracle9045180 1 0 12:55:44 -0:03 oraclejzjs (LOCAL=NO)
oracle9569362 1 4 14:23:40 -0:00 oraclejzjs (LOCAL=NO)
oracle9634938 1 0 12:50:01 -0:00 oraclejzjs (LOCAL=NO)
oracle 10814516 1 0 12:50:00 -0:00 oraclejzjs (LOCAL=NO)
oracle 11535534 1 102 14:14:55 -4:38 oraclejzjs (LOCAL=NO)
oracle 11666478 111 12:57:34 -4:37 oraclejzjs (LOCAL=NO)
oracle 12452996 1 0 12:55:40 -0:04 oraclejzjs (LOCAL=NO)
oracle 12715186 1 0 14:08:09 -0:00 oraclejzjs (LOCAL=NO)
oracle 12846178 195 14:23:29 -0:05 oraclejzjs (LOCAL=NO)
oracle 14025978 1 0 12:49:46 -0:01 oraclejzjs (LOCAL=NO)
oracle 14353592 1 0 13:16:47 -0:08 oraclejzjs (LOCAL=NO)
oracle 14877868 110 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 15008866 1 0 12:49:50 -0:00 oraclejzjs (LOCAL=NO)
oracle 15140088 1 2 14:08:44 -0:10 oraclejzjs (LOCAL=NO)
oracle 15402196 1 0 12:55:33 -0:00 oraclejzjs (LOCAL=NO)
oracle 15533198 1 3 14:17:14 -0:04 oraclejzjs (LOCAL=NO)
oracle 15598714 1 0 13:26:49 -0:01 oraclejzjs (LOCAL=NO)
oracle 15729710 1 0 13:38:38 -0:09 oraclejzjs (LOCAL=NO)
oracle 15795346 1 7 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 15860892 1 0 12:49:52 -0:00 oraclejzjs (LOCAL=NO)
oracle 15926474 1 1 14:12:48 -0:03 oraclejzjs (LOCAL=NO)
oracle 15992020 1 0 13:28:42 -0:00 oraclejzjs (LOCAL=NO)
oracle 16516294 1 1 12:58:29 -1:03 oraclejzjs (LOCAL=NO)
oracle 16647344 1 0 14:16:15 -0:03 oraclejzjs (LOCAL=NO)
oracle 16778422 1 0 12:49:50 -0:07 oraclejzjs (LOCAL=NO)
oracle 16843900 1 3 14:15:57 -0:06 oraclejzjs (LOCAL=NO)
oracle 17499230 1 0 14:13:29 -0:11 oraclejzjs (LOCAL=NO)
oracle 17827060 1 0 13:13:40 -0:28 oraclejzjs (LOCAL=NO)
oracle 17892386 1 0 13:58:47 -0:07 oraclejzjs (LOCAL=NO)
oracle 18154652 1 0 12:55:38 -0:04 oraclejzjs (LOCAL=NO)
oracle 19137596 1 0 12:55:42 -0:11 oraclejzjs (LOCAL=NO)
oracle 19203072 1 0 13:36:50 -0:00 oraclejzjs (LOCAL=NO)
oracle 19334378 111 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 19465312 1 6 14:23:37 -0:00 oraclejzjs (LOCAL=NO)
oracle 19596292 1 7 14:23:40 -0:00 oraclejzjs (LOCAL=NO)
oracle 19924070 1 1 14:09:07 -0:05 oraclejzjs (LOCAL=NO)
oracle 20186186 1 0 12:49:50 -0:00 oraclejzjs (LOCAL=NO)
oracle 20448458 110 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 20645062 1 0 13:22:29 -0:22 oraclejzjs (LOCAL=NO)
oracle 20841548 1 0 13:58:47 -0:00 oraclejzjs (LOCAL=NO)
oracle 21103626 142 12:54:06 - 22:05 oraclejzjs (LOCAL=NO)
oracle 21169192 1 0 13:36:03 -0:00 oraclejzjs (LOCAL=NO)
oracle2557284 1 0 13:07:04 -0:22 oraclejzjs (LOCAL=NO)
oracle2753930 1 0 12:58:34 -0:41 oraclejzjs (LOCAL=NO)
oracle3278160 1 0 12:59:51 -0:45 oraclejzjs (LOCAL=NO)
oracle3605806 1 0 12:55:42 -0:00 oraclejzjs (LOCAL=NO)
oracle3671454 1 1 12:54:18 -0:25 oraclejzjs (LOCAL=NO)
oracle3933596 1 0 12:50:11 -0:00 oraclejzjs (LOCAL=NO)
oracle5375244 1 0 12:50:10 -0:00 oraclejzjs (LOCAL=NO)
oracle5703084 1 0 13:36:27 -0:00 oraclejzjs (LOCAL=NO)
oracle6161694 1 0 14:14:41 -0:08 oraclejzjs (LOCAL=NO)
oracle6358272 1 5 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle6882724 1 0 13:09:32 -0:03 oraclejzjs (LOCAL=NO)
oracle7210386 1 0 12:50:01 -0:00 oraclejzjs (LOCAL=NO)
oracle7275884 114 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle7341550 119 12:58:43 - 11:40 oraclejzjs (LOCAL=NO)
oracle7669148 1 6 13:13:05 -2:45 oraclejzjs (LOCAL=NO)
oracle7996754 1 1 13:14:17 -0:53 oraclejzjs (LOCAL=NO)
oracle8390132 1 2 12:57:24 -1:28 oraclejzjs (LOCAL=NO)
oracle8848704 1 0 12:50:10 -0:00 oraclejzjs (LOCAL=NO)
oracle9504020 1 0 12:49:54 -0:00 oraclejzjs (LOCAL=NO)
oracle9700674 1 0 13:11:09 -0:00 oraclejzjs (LOCAL=NO)
oracle9831688 1 0 12:49:52 -0:00 oraclejzjs (LOCAL=NO)
oracle 10356088 1 0 12:57:41 -0:22 oraclejzjs (LOCAL=NO)
oracle 10421594 1 6 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 10487042 1 0 12:55:55 -0:00 oraclejzjs (LOCAL=NO)
oracle 10618264 1 2 13:32:32 -1:11 oraclejzjs (LOCAL=NO)
oracle 10683832 1 5 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 11535798 1 5 14:23:38 -0:00 oraclejzjs (LOCAL=NO)
oracle 11601244 1 0 14:10:28 -0:00 oraclejzjs (LOCAL=NO)
oracle 11666926 1 0 13:24:38 -0:28 oraclejzjs (LOCAL=NO)
oracle 11732394 1 0 13:04:07 -0:22 oraclejzjs (LOCAL=NO)
oracle 12387764 1 0 13:40:29 -0:22 oraclejzjs (LOCAL=NO)
oracle 12649840 1 6 14:23:36 -0:00 oraclejzjs (LOCAL=NO)
oracle 12912070 1 0 12:49:51 -0:00 oraclejzjs (LOCAL=NO)
oracle 13174182 1 0 13:41:26 -0:00 oraclejzjs (LOCAL=NO)
oracle 13894936 1 0 13:26:06 -0:30 oraclejzjs (LOCAL=NO)
oracle 13960472 1 0 12:54:43 -0:00 oraclejzjs (LOCAL=NO)
oracle 14091716 136 14:23:38 -0:00 oraclejzjs (LOCAL=NO)
oracle 14550452 1 0 13:33:28 -0:02 oraclejzjs (LOCAL=NO)
oracle 14616032 1 0 14:01:43 -0:00 oraclejzjs (LOCAL=NO)
oracle 14943726 1 0 14:08:59 -0:02 oraclejzjs (LOCAL=NO)
oracle 15074782 1 0 12:53:23 -0:00 oraclejzjs (LOCAL=NO)
oracle 15598906 1 0 13:11:05 -0:52 oraclejzjs (LOCAL=NO)
oracle 15664442 1 1 12:57:16 -0:54 oraclejzjs (LOCAL=NO)
oracle 15730102 1 0 12:56:48 -0:00 oraclejzjs (LOCAL=NO)
oracle 15795470 1 0 12:55:36 -0:03 oraclejzjs (LOCAL=NO)
oracle 15926610 1 0 12:59:15 -0:25 oraclejzjs (LOCAL=NO)
oracle 16975272 1 0 13:16:52 -0:07 oraclejzjs (LOCAL=NO)
oracle 17564980 1 0 12:54:09 -0:00 oraclejzjs (LOCAL=NO)
oracle 17630614 1 2 14:23:40 -0:00 oraclejzjs (LOCAL=NO)
oracle 18089320 1 0 13:03:49 -0:22 oraclejzjs (LOCAL=NO)
oracle 19531016 1 0 12:53:06 -0:00 oraclejzjs (LOCAL=NO)
oracle 19596608 1 0 13:05:06 -0:29 oraclejzjs (LOCAL=NO)
oracle 20645320 1 0 13:13:19 -0:00 oraclejzjs (LOCAL=NO)
oracle 21628372 1 0 12:49:58 -0:00 oraclejzjs (LOCAL=NO)
oracle 21693870 1 0 14:05:26 -0:00 oraclejzjs (LOCAL=NO)
oracle 21955860 1 0 14:23:19 -0:00 oraclejzjs (LOCAL=NO)
oracle 22742306 1 0 14:23:16 -0:00 oraclejzjs (LOCAL=NO)
oracle1115746 1 0 12:49:45 -0:03 oraclejzjs (LOCAL=NO)
oracle1574450 1 0 12:49:45 -0:02 oraclejzjs (LOCAL=NO)
oracle2492060 1 1 13:25:22 -1:03 oraclejzjs (LOCAL=NO)
oracle4064892 1 1 13:23:04 -0:24 oraclejzjs (LOCAL=NO)
oracle4851402 1 0 13:55:38 -0:02 oraclejzjs (LOCAL=NO)
oracle5047810 1 1 13:25:05 -0:33 oraclejzjs (LOCAL=NO)
oracle5441130 1 8 14:23:40 -0:00 oraclejzjs (LOCAL=NO)
oracle5768728 1 7 14:23:34 -0:00 oraclejzjs (LOCAL=NO)
oracle6161954 1 0 12:58:28 -0:40 oraclejzjs (LOCAL=NO)
oracle7472762 1 0 12:51:09 -0:00 oraclejzjs (LOCAL=NO)
oracle7538424 1 0 12:52:19 -0:00 oraclejzjs (LOCAL=NO)
oracle7603886 1 0 14:15:26 -0:00 oraclejzjs (LOCAL=NO)
oracle8259248 1 0 13:54:47 -0:21 oraclejzjs (LOCAL=NO)
oracle9242232 1 0 12:50:10 -0:00 oraclejzjs (LOCAL=NO)
oracle 10487470 1 1 13:31:32 -0:59 oraclejzjs (LOCAL=NO)
oracle 10815202 1 0 12:50:10 -0:00 oraclejzjs (LOCAL=NO)
oracle 10946210 1 0 13:29:10 -0:22 oraclejzjs (LOCAL=NO)
oracle 11667184 22544888 0 14:23:40pts/50:00 grep -i local
oracle 11732532 1 3 12:56:33 -1:40 oraclejzjs (LOCAL=NO)
oracle 12387904 1 0 13:25:04 -0:00 oraclejzjs (LOCAL=NO)
oracle 12781240 1 0 13:31:16 -0:29 oraclejzjs (LOCAL=NO)
oracle 13043354 1 0 13:14:17 -0:00 oraclejzjs (LOCAL=NO)
oracle 13108862 1 0 12:55:33 -0:11 oraclejzjs (LOCAL=NO)
oracle 13436648 1 5 14:23:40 -0:00 oraclejzjs (LOCAL=NO)
oracle 13698622 1 0 14:17:09 -0:01 oraclejzjs (LOCAL=NO)
oracle 13764224 1 2 12:56:54 -0:53 oraclejzjs (LOCAL=NO)
oracle 14091936 1 1 13:08:19 -0:29 oraclejzjs (LOCAL=NO)
oracle 14288526 1 0 13:31:08 -0:00 oraclejzjs (LOCAL=NO)
oracle 14353948 1 0 14:09:08 -0:06 oraclejzjs (LOCAL=NO)
oracle 14681764 1 0 13:22:54 -0:29 oraclejzjs (LOCAL=NO)
oracle 15009494 1 1 13:26:21 -0:30 oraclejzjs (LOCAL=NO)
oracle 15402618 1 0 13:04:31 -0:22 oraclejzjs (LOCAL=NO)
oracle 15664726 177 14:19:22 -2:13 oraclejzjs (LOCAL=NO)
oracle 15992416 1 6 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 16057886 1 0 12:55:47 -0:02 oraclejzjs (LOCAL=NO)
oracle 16189088 1 5 14:23:38 -0:00 oraclejzjs (LOCAL=NO)
oracle 16254488 1 0 13:02:19 -0:08 oraclejzjs (LOCAL=NO)
oracle 16582302 1 1 13:14:15 -0:32 oraclejzjs (LOCAL=NO)
oracle 16844400 1 0 12:49:53 -0:00 oraclejzjs (LOCAL=NO)
oracle 16909936 1 0 13:09:53 -0:00 oraclejzjs (LOCAL=NO)
oracle 17106578 151 14:23:38 -0:00 oraclejzjs (LOCAL=NO)
oracle 17303166 1 0 12:54:06 -0:00 oraclejzjs (LOCAL=NO)
oracle 17696430 1 0 12:49:45 -0:26 oraclejzjs (LOCAL=NO)
oracle 18417214 1 0 13:51:06 -0:00 oraclejzjs (LOCAL=NO)
oracle 18482830 1 0 12:55:42 -0:00 oraclejzjs (LOCAL=NO)
oracle 20383336 1 0 13:23:46 -0:03 oraclejzjs (LOCAL=NO)
oracle 20842086 1 0 13:13:58 -0:08 oraclejzjs (LOCAL=NO)
oracle 22087390 1 0 12:49:53 -0:00 oraclejzjs (LOCAL=NO)
oracle 22152904 1 0 13:58:00 -0:00 oraclejzjs (LOCAL=NO)
oracle 22808296 1 1 14:12:28 -0:03 oraclejzjs (LOCAL=NO)
oracle 23135922 1 0 14:23:12 -0:00 oraclejzjs (LOCAL=NO)
oracle 23660176 1 0 12:55:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 24512052 115 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 24708790 1 0 13:59:03 -0:00 oraclejzjs (LOCAL=NO)
oracle 24970774 1 0 12:53:34 -0:00 oraclejzjs (LOCAL=NO)
oracle 25036310 1 0 12:55:43 -0:02 oraclejzjs (LOCAL=NO)
oracle1181524 1 0 12:55:53 -0:00 oraclejzjs (LOCAL=NO)
oracle1443646 1 0 12:56:28 -0:01 oraclejzjs (LOCAL=NO)
oracle2164624 1 0 12:49:41 -0:00 oraclejzjs (LOCAL=NO)
oracle2623484 1 0 12:58:36 -0:07 oraclejzjs (LOCAL=NO)
oracle2754492 1 9 14:23:40 -0:00 oraclejzjs (LOCAL=NO)
oracle6162184 1 103 14:21:42 -0:55 oraclejzjs (LOCAL=NO)
oracle6948810 1 0 13:05:04 -0:00 oraclejzjs (LOCAL=NO)
oracle7079886 1 0 12:58:50 -0:32 oraclejzjs (LOCAL=NO)
oracle8456008 1 0 14:06:14 -0:50 oraclejzjs (LOCAL=NO)
oracle8521682 1 1 13:13:44 -0:27 oraclejzjs (LOCAL=NO)
oracle8980302 114 12:56:23 -7:07 oraclejzjs (LOCAL=NO)
oracle9176852 1 0 12:55:58 -0:00 oraclejzjs (LOCAL=NO)
oracle9766876 1 1 12:55:33 -0:44 oraclejzjs (LOCAL=NO)
oracle 10356538 1 1 12:57:33 -0:55 oraclejzjs (LOCAL=NO)
oracle 10880970 1 0 12:55:44 -0:07 oraclejzjs (LOCAL=NO)
oracle 11274020 1 0 12:49:45 -0:02 oraclejzjs (LOCAL=NO)
oracle 11863814 163 12:53:56 - 30:06 oraclejzjs (LOCAL=NO)
oracle 12126154 1 0 12:53:18 -0:00 oraclejzjs (LOCAL=NO)
oracle 12847016 1 0 12:55:56 -0:04 oraclejzjs (LOCAL=NO)
oracle 12978156 1 0 12:55:54 -0:00 oraclejzjs (LOCAL=NO)
oracle 13174714 1 0 14:18:21 -0:02 oraclejzjs (LOCAL=NO)
oracle 13240272 112 12:56:57 -5:57 oraclejzjs (LOCAL=NO)
oracle 13502460 1 0 13:07:02 -0:10 oraclejzjs (LOCAL=NO)
oracle 14223180 1 0 14:15:31 -0:00 oraclejzjs (LOCAL=NO)
oracle 15271788 1 0 14:15:53 -0:00 oraclejzjs (LOCAL=NO)
oracle 15533932 1 0 12:50:01 -0:00 oraclejzjs (LOCAL=NO)
oracle 15730652 1 0 13:11:41 -0:00 oraclejzjs (LOCAL=NO)
oracle 15796104 1 0 12:49:59 -0:00 oraclejzjs (LOCAL=NO)
oracle 15992650 17629206 0 13:28:08 -0:07 oraclejzjs (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 16058190 1 0 12:49:59 -0:00 oraclejzjs (LOCAL=NO)
oracle 16254732 1 0 13:13:19 -0:00 oraclejzjs (LOCAL=NO)
oracle 16582400 1 0 13:20:51 -0:00 oraclejzjs (LOCAL=NO)
oracle 16713614 1 0 12:59:08 -0:00 oraclejzjs (LOCAL=NO)
oracle 17565444 110 14:23:39 -0:00 oraclejzjs (LOCAL=NO)
oracle 17631192 189 14:17:01 -2:54 oraclejzjs (LOCAL=NO)
oracle 18351990 1 0 13:12:11 -0:00 oraclejzjs (LOCAL=NO)
oracle 18417450 1 0 12:56:05 -0:01 oraclejzjs (LOCAL=NO)
oracle 18483052 1 9 14:23:38 -0:00 oraclejzjs (LOCAL=NO)
oracle 18548550 1 6 12:56:41 -6:51 oraclejzjs (LOCAL=NO)
oracle 18679652 1 0 13:38:48 -0:00 oraclejzjs (LOCAL=NO)
oracle 18810782 1 0 12:54:51 -0:57 oraclejzjs (LOCAL=NO)
oracle 20842362 1 0 12:49:53 -0:10 oraclejzjs (LOCAL=NO)
oracle 21890884 1 0 12:49:53 -0:00 oraclejzjs (LOCAL=NO)
oracle 22087450 1 5 14:23:37 -0:00 oraclejzjs (LOCAL=NO)
这样你找到了pid后，可以通过kill -9 pid进行杀掉（之前查询结果没有保存，所以时间可能无法对应，但是方法就是这样），再通过shutdown immediate进行停库操做，我们继续关注alert日志，
Wed Sep 19 12:43:13 GMT+08:00 2012Shutting down instance (immediate)
Wed Sep 19 12:43:13 GMT+08:00 2012Shutting down instance: further logons disabled
License high water mark = 1574
Wed Sep 19 12:48:14 GMT+08:00 2012Active call for process 12124640 user 'oracle' program 'oracle@jszwdb01'
Active call for process 15598262 user 'oracle' program 'oracle@jszwdb01'
Active call for process 10814508 user 'oracle' program 'oracle@jszwdb01'
System State dumped to trace file /oracle/admin/jzjs/udump/jzjs_ora_11274002.trc
SHUTDOWN: waiting for active calls to complete.
All dispatchers and shared servers shutdown
Wed Sep 19 12:48:24 GMT+08:00 2012ALTER DATABASE CLOSE NORMAL
Wed Sep 19 12:48:24 GMT+08:00 2012SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Sep 19 12:48:24 GMT+08:00 2012Block change tracking service stopping.
Wed Sep 19 12:48:24 GMT+08:00 2012Stopping background process CTWR
Wed Sep 19 12:48:28 GMT+08:00 2012Shutting down archive processes
Archiving is disabled
Wed Sep 19 12:48:33 GMT+08:00 2012ARCH shutting down
ARC1: Archival stopped
Wed Sep 19 12:48:38 GMT+08:00 2012ARCH shutting down
ARC0: Archival stopped
Wed Sep 19 12:48:39 GMT+08:00 2012Thread 1 closed at log sequence 144393
Successful close of redo thread 1
Wed Sep 19 12:48:54 GMT+08:00 2012Completed:> Wed Sep 19 12:48:54 GMT+08:00 2012ALTER DATABASE DISMOUNT
Completed:> ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
停库结束。当然我们可以通过查询当前库中正在存活的任务，然后杀掉在停库。
select sid,serial# from v$session;
alter system kill session 'sid, serial#';
shutdown immediate;
页:
[1]