shutdown immediate hung

From: Mike Adams <mikea_at_best.com>
Date: 2000/05/15
Message-ID: <3920d38f$0$209@nntp1.ba.best.com>#1/1

I attempted to "shutdown immediate" on one of our "test" databases tonight. The shutdown hung after closing and unmounting the database. I checked the
"alert" log and the last statement (see last line of this posting) says it's
"waiting for detached processes to terminate". Anyone know what this
means???

I checked the processes for the instance and the only processes remaining are:

oracle 823 822 0 18:38:33 ? 0:00 oracleroctest (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

  oracle   126     1  0 18:11:23 ?        0:00 ora_arc3_roctest
  oracle 29212     1  0 15:34:09 ?        0:02 ora_arc2_roctest
  oracle   705     1  0 18:24:55 ?        0:00 ora_arc4_roctest

Is it waiting for those archive processes?

Thanks in advance for any help!!!!

Please 'cc' mikea_at_best.com as I can't check new groups at work.

Mon May 15 18:38:13 2000

ARC4: received prod
ARC4: Beginning to archive log# 2 seq# 730
ARC4: Completed archiving log# 2 seq# 730
ARC4: re-scanning for new log files
ARC4: prodding the archiver

Mon May 15 18:38:14 2000
ARC0: received prod
Mon May 15 18:39:13 2000
Shutting down instance (immediate)
License high water mark = 2
Mon May 15 18:39:14 2000
ALTER DATABASE CLOSE NORMAL
Mon May 15 18:39:14 2000
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon May 15 18:39:14 2000
Thread 1 closed at log sequence 731
Mon May 15 18:39:14 2000
Completed: ALTER DATABASE CLOSE NORMAL
Mon May 15 18:39:14 2000
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
archiving is disabled

ARCH: changing ARC0 KCRRACTIVE->KCRRSHUTDN
ARCH: sending ARC0 shutdown message
ARCH: changing ARC1 KCRRACTIVE->KCRRSHUTDN
ARCH: sending ARC1 shutdown message

Mon May 15 18:39:17 2000
ARCH shutting down
ARC0: Archival stopped
ARC0: changing ARC0 KCRRSHUTDN->KCRRDEAD Mon May 15 18:39:17 2000
ARCH shutting down
ARC1: Archival stopped
ARC1: changing ARC1 KCRRSHUTDN->KCRRDEAD Mon May 15 18:44:26 2000
SHUTDOWN: waiting for detached processes to terminate. Received on Mon May 15 2000 - 00:00:00 CDT