SHUTDOWN: Active sessions prevent database close operation
616858Mar 4 2011 — edited Mar 5 2011Hi Gurus!
I get this in my alertlog...
Thu Mar 3 23:55:16 2011
Starting background process EMN0
EMN0 started with pid=24, OS id=14504
Thu Mar 3 23:55:17 2011
ShuttingThu Mar 3 23:55:20 2011
Stopping background process QMNC
Thu Mar 3 23:55:20 2011
Stopping background process CJQ0
Thu Mar 3 23:55:22 2011
Stopping background process MMNL
Thu Mar 3 23:55:23 2011
Stopping background process MMON
Thu Mar 3 23:55:24 2011
Shutting down instance (immediate)
License high water mark = 99
Thu Mar 3 23:55:24 2011
Stopping Job queue slave processes
Thu Mar 3 23:55:24 2011
Job queue slave processes stopped
Fri Mar 4 00:00:23 2011
Active call for process 11011 user 'oracle' program 'oracle@dagonet (S000)'
SHUTDOWN: waiting for active calls to complete.
Fri Mar 4 00:14:33 2011
MMNL absent for 1203 secs; Foregrounds taking over
Fri Mar 4 00:55:27 2011
SHUTDOWN: Active sessions prevent database close operation
I know my DB didn't shutdown by the process 11011 user 'oracle' program 'oracle@dagonet (S000)' took too much time, my doubt is what do I need to do to restart the background process that were stopped??
Do I have to restart the DB?
Thanks in advanced.