John If this is a new install then why dont you just do the install again. Otherwise you can use following
STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "WMPROD" NORESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 10 MAXLOGHISTORY 3630 LOGFILE GROUP 1( '/ora/redo1/wmprod/redo1a.log', '/ora/redo2/wmprod/redo1b.log' ) SIZE 700M, .. DATAFILE '/ora/ts4/wmprod/system01.dbf', .. ; Justput in names of you all your redologs and data files. You may have to do a recovery afterwards. -Shaleen ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 25, 2002 4:48 AM > thanks to all who are helping with this problem. > > control file(s) are missing. since this is a new install it might > have been that the control files were never created. > the oracle docs (support) tell to use "CREATE CONTROLFILE" > statement to create control file(s). but i need to know the > complete procedure. would you know the complete statement and > procedure to generate control files. do we have to change the > db/sid name ? > > > > > > > --- Arup Nanda <[EMAIL PROTECTED]> wrote: > > Yes, the poster clarified that it was a missing controlfile. I > > have a reply > > that catered to the missing controlfile issue. > > > > > > > > > > > > > > >From: Jeremiah Wilton <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: Re: instance shutdown problem ? (please help) > > >Date: Sun, 24 Nov 2002 15:23:35 -0800 > > >MIME-Version: 1.0 > > >Received: from newsfeed.cts.com ([209.68.248.164]) by > > >mc6-f42.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); > > Sun, 24 Nov > > >2002 16:13:22 -0800 > > >Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com > > >(8.9.3/8.9.3) with UUCP id QAA10715;Sun, 24 Nov 2002 16:06:45 > > -0800 (PST) > > >Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id > > 0050A562; > > >Sun, 24 Nov 2002 15:23:35 -0800 > > >Message-ID: <[EMAIL PROTECTED]> > > >X-Comment: Oracle RDBMS Community Forum > > >X-Sender: Jeremiah Wilton <[EMAIL PROTECTED]> > > >Sender: [EMAIL PROTECTED] > > >Errors-To: [EMAIL PROTECTED] > > >Organization: Fat City Network Services, San Diego, California > > >X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. > > Bergman > > >Precedence: bulk > > >Return-Path: [EMAIL PROTECTED] > > >X-OriginalArrivalTime: 25 Nov 2002 00:13:22.0422 (UTC) > > >FILETIME=[772A6160:01C29417] > > > > > >Hmm, I think the error is right there in a snippet fo the alert > > log in > > >the poster's original message. ORA-205 "Error in identifying > > >controlfile." > > > > > >The database will not start because Oracle cannot find or access > > one > > >or more of the controlfiles. > > > > > >Are all the postings today about controlfiles? > > > > > >-- > > >Jeremiah Wilton > > >http://www.speakeasy.net/~jwilton > > > > > >On Sat, 23 Nov 2002, Arup Nanda wrote: > > > > > > > Well, system does not do a shutdown abort. Oracle finds a > > problem and > > >then > > > > instance aborts. > > > > > > > > A few things you can do here. > > > > > > > > (1) See if a trace file is generated around that time in > > user_dump_dest > > >or > > > > background_dump_dest that might provide clues. If you see a > > core fiel in > > >any > > > > directory named core_* in the core_dump_dest, it has cored > > dumped. > > > > > > > > (2) Start the database from command line. From NT services > > panel, make > > >the > > > > services OracleServiceXXX manual, from automatic. Then reboot > > the box. > > >Start > > > > the service manually and then see what happens in the > > process. > > > > > > > > (3) Start the instance and service in a command prompt window > > using > > >oradim > > > > comamnd. I am not sure of the options; but the oradim command > > gives a > > >help. > > > > > > > > At some point you would hit a problem that is decipherable. > > Please let > > >us > > > > know what came out of it. > > > > > > > > >From: john <[EMAIL PROTECTED]> > > > > > > > > > >ver 8i NT4.o > > > > >all services have been set to automatic and start fine > > > > > > > > > >however the NT Event Viwer and the oracle "alert.log" > > > > >show that the instance being shutdown just after the > > > > >box boots up. > > > > > > > > > >how do we rectify this problem ? > > > > > > > > > >below is from the alert.log > > > > > > > > > >ORA-205 signalled during: alter database mount exclusive.. > > > > >Shutting down instance (abort) > > > > >License high water mark = 5 > > > > >Instance terminated by USER, pid = 144 > > > > >--------------------------------------------------- > > > > >please note: the shutdwon was not initiated by any admin > > > > >or user but done by the system itself after the box boots > > > > >up. > > > > > >-- > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > > >-- > > >Author: Jeremiah Wilton > > > INET: [EMAIL PROTECTED] > > > > > >Fat City Network Services -- 858-538-5051 > > http://www.fatcity.com > > >San Diego, California -- Mailing list and web hosting > > services > > > >--------------------------------------------------------------------- > > >To REMOVE yourself from this mailing list, send an E-Mail > > message > > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > > in > > >the message BODY, include a line containing: UNSUB ORACLE-L > > >(or the name of mailing list you want to be removed from). You > > may > > >also send the HELP command for other information (like > > subscribing). > > > > > > _________________________________________________________________ > > MSN 8 with e-mail virus protection service: 2 months FREE* > > http://join.msn.com/?page=features/virus > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Arup Nanda > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 > > http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting > > services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > > in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You > > may > > also send the HELP command for other information (like > > subscribing). > > > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: john > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orafaq INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).