From: sejprv@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle instance won't shutdown
Date: Tue, 12 Dec 2000 15:46:47 GMT
Organization: Deja.com - Before you buy.
Lines: 29
Message-ID: <915h94$hj5$1@nnrp1.deja.com>
References: <9061oi$ash$1@nnrp1.deja.com>
NNTP-Posting-Host: 129.142.16.2
X-Article-Creation-Date: Tue Dec 12 15:46:47 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
X-Http-Proxy: 1.0 ANDERS, 1.0 x53.deja.com:80 (Squid/1.1.22) for client 129.142.16.2
X-MyDeja-Info: XMYDJUIDsejprv


In article <9061oi$ash$1@nnrp1.deja.com>,
  sungeek@my-deja.com wrote:
> Oracle 8.0.6
> A normal shutdown will hang. Must use abort. Does anyone have an idea
> of what files should be checked to cure this problem. i.e. control
> files etc. This system has several instances and only one of them has
> this problem. This particular instance starts up ok and updates ok, it
> just refuses to shutdown normally.
>
> Thanks in advance.
> Yes I have talked to Oracle support and they point to a hardware
> problem which we do not have any hardware problem. SUN support points
> back to oracle. A fun pissing match...
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
HI

If you have the option audit_trail=true in your parameter file you
should make a select count(*) from aud$, I had the same problem, but
after i impelmentet this I haven't seen it happen again. Its from
Oracle.
--
SEJ


Sent via Deja.com http://www.deja.com/
Before you buy.