Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Shutdown Immediate hangs on detached process

Shutdown Immediate hangs on detached process

From: Elton Saulsberry <me_at_devnull.net>
Date: Mon, 30 Jul 2001 12:52:36 -0400
Message-ID: <8eg97.3782$9i1.260949@e420r-atl1.usenetserver.com>

I'm having a problem completing a SHUTDOWN IMMEDIATE on my database. It hangs with this message:
SHUTDOWN: waiting for detached processes to terminate. This is Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production on Solaris 5.8

Any help is appreciated.




/u01/app/oracle/admin/odstrnp/bdump/alert_odstrnp.log



Mon Jul 30 01:05:02 2001
Thread 1 advanced to log sequence 2003
  Current log# 2 seq# 2003 mem# 0:
/u02/app/oracle/oradata/odstrnp/redo02.log
Mon Jul 30 01:05:02 2001
ARC5: Beginning to archive log# 1 seq# 2002 ARC5: Completed archiving log# 1 seq# 2002 Mon Jul 30 11:51:48 2001
Shutting down instance (immediate)
License high water mark = 5
Mon Jul 30 11:51:48 2001
ALTER DATABASE CLOSE NORMAL
Mon Jul 30 11:51:48 2001
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Jul 30 11:51:48 2001
Thread 1 closed at log sequence 2003
Mon Jul 30 11:51:48 2001
Completed: ALTER DATABASE CLOSE NORMAL
Mon Jul 30 11:51:48 2001
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
archiving is disabled
Mon Jul 30 11:51:52 2001
ARCH shutting down
ARC0: Archival stopped
Mon Jul 30 11:51:52 2001
ARCH shutting down
ARC1: Archival stopped
[odstrnp]/u01/app/oracle/admin/odstrnp/bdump


$tail alert_odstrnp.log


Completed: ALTER DATABASE DISMOUNT
archiving is disabled
Mon Jul 30 11:51:52 2001
ARCH shutting down
ARC0: Archival stopped
Mon Jul 30 11:51:52 2001
ARCH shutting down
ARC1: Archival stopped
Mon Jul 30 11:57:01 2001
SHUTDOWN: waiting for detached processes to terminate.


$ps -ef |grep oracle

  oracle 23509 23507  0 11:29:13 pts/4    0:00 -ksh
  oracle 15504     1  0   Jul 26 ?        0:01 ora_arc2_odstrnp
  oracle 22304     1  0 23:03:01 ?        0:01 ora_arc5_odstrnp
  oracle  1107     1  0   Jul 20 ?        0:01

/u01/app/oracle/product/8.1.6/bin/tnslsnr LISTENER -inherit
  oracle 23584 23582  0 11:53:30 pts/5    0:00 -ksh
  oracle 23607 23584  0 11:59:54 pts/5    0:00 grep oracle
  oracle 18075     1  0   Jul 27 ?        0:01 ora_arc3_odstrnp
  oracle 23577 23509  0 11:51:47 pts/4    0:00 /usr/bin/ksh shutdown.sh
odstrnp
  oracle 20199     1  0   Jul 28 ?        0:00 ora_arc4_odstrnp
  oracle 23578 23577  0 11:51:47 pts/4    0:00 svrmgrl
  oracle 23579 23578  0 11:51:47 ?        0:00 oracleodstrnp
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))


/u01/app/oracle/admin/odstrnp/bdump/odstrnp_arc5_22304.trc



Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production
ORACLE_HOME = /u01/app/oracle/product/8.1.6 System name: SunOS
Node name:      todd..com
Release:        5.8
Version:        Generic_108528-06
Machine:        sun4u

Instance name: odstrnp
Redo thread mounted by this instance: 1
Oracle process number: 11
Unix process pid: 22304, image: oracle_at_todd..com (ARC5)

oracle_at_todd..com[odstrnp]/u01/app/oracle/admin/odstrnp/udump $ls
odstrnp_ora_23579.trc
oracle_at_todd..com[odstrnp]/u01/app/oracle/admin/odstrnp/udump
$cat *
****************************************************************************
*******

/u01/app/oracle/admin/odstrnp/udump/odstrnp_ora_23579.trc
Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production
ORACLE_HOME = /u01/app/oracle/product/8.1.6 System name: SunOS
Node name:      todd..com
Release:        5.8
Version:        Generic_108528-06
Machine:        sun4u

Instance name: odstrnp
Redo thread mounted by this instance: 0 <none> Oracle process number: 14
Unix process pid: 23579, image: oracle_at_todd..com

Parmeter file:


log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
##### For archiving if enabled #####
log_archive_start = true
log_archive_dest_1 = "location=/u03/oradata/odstrnp/arch"
log_archive_format = arch_%t_%s.arc

****************************************************************************


$df -k

Filesystem            kbytes    used   avail capacity  Mounted on

/dev/dsk/c0t0d0s0 1987399 64073 1863705 4% /
/dev/dsk/c0t0d0s6 1987399 1238885 688893 65% /usr
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd mnttab 0 0 0 0% /etc/mnttab
/dev/dsk/c0t0d0s1 1987399 56452 1871326 3% /var
swap 1706840 8 1706832 1% /var/run swap 1707128 296 1706832 1% /tmp
/dev/dsk/c0t0d0s5 1987399 3493 1924285 1% /opt
/dev/dsk/c1t2d0s1 1019167 5279 952738 1% /u02
/dev/dsk/c0t1d0s0 17413250 3268153 13970965 19% /u03
/dev/dsk/c1t2d0s0 4133310 1297637 2794340 32% /u01
/dev/dsk/c1t2d0s6 30359871 3174087 26882186 11% /u04
klee:/export/home0 6666970 3553862 3046439 54% /export/home0
--
Elton
esaulsberry at jumpon dot net
Received on Mon Jul 30 2001 - 11:52:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US