Shutdown Normal or Immediate Hang Waiting for MMON process (Doc ID 1183213.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 01-Jul-2016***

Symptoms

Shutdown immediate/normal hangs. If the startup is restricted, then the shutdown immediate works fine.

Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Stopping background process MMNL
Thu Aug 05 13:28:48 2010
Background process MMNL not dead after 10 seconds
Killing background process MMNL
Stopping background process MMON
Thu Aug 05 13:29:20 2010
Background process MMON not dead after 30 seconds
Killing background process MMON
License high water mark = 1
Thu Aug 05 13:34:23 2010
Active process 12377 user 'oracle' program 'oracle@bsf14f (MMON)'
Active process 12377 user 'oracle' program 'oracle@bsf14f (MMON)'
Active process 22755 user 'oracle' program 'oracle@bsf14f (M000)'
Active process 22755 user 'oracle' program 'oracle@bsf14f (M000)'

SHUTDOWN: waiting for logins to complete.

 

(latch info) wait_event=0 bits=100
holding (efd=4) 38000b808 ksuosstats global area level=8
Location from where latch is held: ksu.h LINE:12921 ID:ksugetosstat:
Context saved from call: 0
state=busy [holder orapid=16] wlstate=free [value=0]
waiters [orapid (seconds since: put on list, posted, alive check)]:
27 (985, 1281008063, 985)
waiter count=1
Process Group: DEFAULT, pseudo proc: 0x3bf51c538
O/S info: user: oracle, term: UNKNOWN, ospid: 12379 (DEAD)
OSD pid info: Unix process pid: 12379, image: oracle@bsf14f (MMNL)

 


22395: open("/dev/kstat", O_RDONLY) = 19
22395: ioctl(19, KSTAT_IOC_CHAIN_ID, 0x00000000) = 227215
22395: ioctl(19, KSTAT_IOC_READ, "kstat_headers") Err#12 ENOMEM
22395: ioctl(19, KSTAT_IOC_READ, "kstat_headers") = 227215
22395: ioctl(19, KSTAT_IOC_READ, "cpu_info352") = 227215
22395: ioctl(19, KSTAT_IOC_READ, "cpu_info353") = 227215
22395: ioctl(19, KSTAT_IOC_READ, "cpu_info354") = 227215
...
22395: close(19) = 0
22395: open("/dev/kstat", O_RDONLY) = 19
22395: ioctl(19, KSTAT_IOC_CHAIN_ID, 0x00000000) = 227215
22395: ioctl(19, KSTAT_IOC_READ, "kstat_headers") Err#12 ENOMEM
22395: ioctl(19, KSTAT_IOC_READ, "kstat_headers") = 227215
22395: ioctl(19, KSTAT_IOC_READ, "sysinfo") = 227215
22395: ioctl(19, KSTAT_IOC_READ, "cpu_stat352") = 227215
22395: ioctl(19, KSTAT_IOC_READ, "cpu_stat353") = 227215
 .......

 

Changes

Upgrade to release 11.2.0.1.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms