Script for killing processes after shutdown immediate fails
Hi All,
I am looking to enhancing my shutdown script to kill off processes that block "shu immediate" from happening.
Shutting down instance (immediate)
License high water mark = 13
Active call for process 7205 user 'oracle' program 'oracle@sun6 (S000)'
SHUTDOWN: waiting for active calls to complete. ** Waits as long as 2 hours if I dont kill the OS process **
All dispatchers and shared servers shutdown
Wed Nov 26 14:54:23 2008
ALTER DATABASE CLOSE NORMAL
I had to manually kill off the process S000 the last 2 days for "shu immediate" to work ; altering my automated backup schedule.
Any ideas on how I can make sure that "shu immediate" shuts down as expected. This shutdown script is used by the TSM backup automatically for a midnight shutdown.
Thank you.