Path: utzoo!attcan!uunet!samsung!uakari.primate.wisc.edu!sdd.hp.com!decwrl!fernwood!oracle!news
From: sharnyo@.com (Suwandi Harnyo)
Newsgroups: comp.databases
Subject: Re: Oracle crashes
Keywords: help
Message-ID: <1990Oct2.224052.6976@oracle.com>
Date: 2 Oct 90 22:40:52 GMT
References: <25244@sequoia.execu.com>
Reply-To: sharnyo@oracle.com (Andi Harnyo)
Organization: Oracle Corporation, Belmont, CA
Lines: 35

In article <25244@sequoia.execu.com> bob@sequoia.execu.com (Bob Kieras) writes:
>
>    We are running Ultrix-32 V3.1 (Rev. 9) on a Microvax 3600 and
>    ORACLE RDBMS V6.0.27.9.1 and we have encountered a problem.
>    If the machine is shutdouwn using the shutdown command without
>    shutting oracle down first, the database cannot be restarted. 
>    When we attempt to restart the database, we get the following error
>    while using the SQLDBA program :
>
>	 SQLDBA> startup
>	 ORACLE instance started
>	 Database mounted
>	 Unexpected oracle server termination by signal 6
>	 %
>    ( Core is dumped and oracle crashed.)
>
>    I have traced the problem to the database control file, 
>    /usr/oracle/dbs/cntrlora6.dbf where "ora6" is the instance name.
>    This file is either broken or left in a state incompatible with 
>    restarting the database. Rebuilding the database and thereby replacing
>    the control file fixes the problem. Obviously, we can always have
>    "shutdown" shutdown the database first but if the machine ever crashes,
>    the databse will be creamed. Does anyone out there know of an oracle
>    utility that "fixes" control files ?
>
>                                          thanks in advance
>					  Bob Kieras


Bob, 

This is a known problem and Oracle has a fix for it.                   
Call the technical support line.

-Andi