Oracle doesn't shutdown

From: Dan Yusuph <oradba_at_mail.kz>
Date: Fri, 16 May 2003 11:26:49 +0600
Message-ID: <ba1p5g$offfh$1@ID-175901.news.dfncis.de>

Chr2k04 <chr2k4_at_aol.com>
wrote in message news:bf58ec5f.0305151521.3fd0f172_at_posting.google.com...

> After a recent power-outage where my computer uncleanly shut
> down,oracle starts up but doesnt shut down.
>
> I have Linux Mandrake9.1, Oracle 9i, and I use sqlplus /nolog and
> connect as a sysdba to shut it down, with 'shut'.
>
> Am I going to have to reinstall the database?

if you have:
1) dictionary managed tablespaces (for user data and especially temp tablespace)
and
2) there is a substring like "...waiting for smon..." in the end of alertlog then:
look metalink note 61997.1
"SMON - Temporary Segment Cleanup and Free Space Coalescing"

it is recommended recreate your 9i database with locally managed tablespaces, see concepts

Dan Received on Fri May 16 2003 - 00:26:49 CDT