Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: urgent - can't do anything till fixed

Re: urgent - can't do anything till fixed

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Wed, 18 Aug 1999 13:48:31 -0400
Message-ID: <37BAF1EE.E1DA651C@Unforgettable.com>


Do a 'shutdown abort'. You should not have deleted the files until the database was shut down completely. If this still doesn't work then you will have to manually kill all of the oracle processes.

Ken

kev wrote:

> Hi Oracle Jedi's,
>
> I'm trying to create a DB with a creation script. In between runs, I
> deleted the necessary files before doing a shutdown, so now whenever I
> try to do anything I get (for example):
>
> SVRMGR> shutdown
> ORA-00210: cannot open the specified controlfile
> ORA-00202: controlfile: '/u02/oradata/WWS/control01.ctl'
> ORA-27041: unable to open file
> Linux Error: 2: No such file or directory
> Additional information: 3
>
> because it can't find the files I've deleted. What do I do? I can't do
> anything until I fix this :-(
>
> quick help very much appreciated,
>
> - Kev
Received on Wed Aug 18 1999 - 12:48:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US