shutdown immediate not working properly [message #113667] |
Wed, 18 April 2001 07:42 |
Pablo Campanini
Messages: 13 Registered: January 2001
|
Junior Member |
|
|
After we issue a shutdown immediate on an MPM Oracle 8.1.7. It hangs up (wait) until we issue a Shut Force.
There may be connections or transactions still going on, but the shutdown immediate should take care of it as mentioned in the manual.
Any ideas how to kill connections or transactions? and shutdown quick?
|
|
|
Re: shutdown immediate not working properly [message #113672 is a reply to message #113667] |
Thu, 19 April 2001 13:18 |
Dean Saunders
Messages: 11 Registered: April 2001
|
Junior Member |
|
|
: After we issue a shutdown immediate on an MPM Oracle 8.1.7. It hangs up (wait) until we issue a Shut Force.
: There may be connections or transactions still going on, but the shutdown immediate should take care of it as mentioned in the manual.
: Any ideas how to kill connections or transactions? and shutdown quick?
You can issue an MPM command DISPLAY TASKS to
display all of the worker tasks and then
issue MPM commands STOP TASK000x (where x is
1,2,3 so on) to stop all of the subtask. The
shutdown immediate will continue and shut the rest
of the subtasks down. If not SHUTDOWN FORCE
is your next choice, restart the database again
and shutting down again with SHUTDOWN normal.
Dean
|
|
|