Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SHUTDOWN: Active sessions prevent database close operation

616858Mar 4 2011 — edited Mar 5 2011
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2011
Added on Mar 4 2011
7 comments
3,371 views