Elton
I think you have hit Oracle bug 1300367 involving multiple archiver
processors. Only processors 1 and 2 get killed by a shutdown immediate and
others are left hanging. This matches with what you are seeing when you ps
your system, processes 3 and 4 still there, and also your alert log which
show 1 and 2 stopping. talk to Oracle support about this, warning you may
not get much help as last I heard it was only fixed in version 9. But check
they may have done a backport. The published work round off metalink is to
issue the following command prior to shutdown:
SVRMGR> ALTER SYSTEM SET log_archive_max_processes=10;
SVRMGR> alter system archive log stop;
==> this will kill all ARCH processes
SVRMGR> ALTER SYSTEM SET log_archive_max_processes=1;
SVRMGR> alter system archive log start;
==> this will start ONLY one ARCH process
Hope this helps.
Regards
Fraser McCallum
MVP Oracle
www.brainbench.com
"Elton Saulsberry" <me_at_devnull.net> wrote in message
news:8eg97.3782$9i1.260949_at_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)
>
> *** 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 - 16:51:36 CDT
