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)
- SESSION ID:(9.1315) 2001-07-29 23:03:01.159
- 2001-07-29 23:03:01.159
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
- SESSION ID:(16.971) 2001-07-30 11:57:01.180
SHUTDOWN: waiting for detached processes to terminate.
- 2001-07-30 12:02:10.210
SHUTDOWN: waiting for detached processes to terminate.
- 2001-07-30 12:07:19.210
SHUTDOWN: waiting for detached processes to terminate.
- 2001-07-30 12:12:28.210
SHUTDOWN: waiting for detached processes to terminate.
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