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" <ORACLE-L_at_fatcity.com>
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 <arupnanda_at_hotmail.com> 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 <jwilton_at_speakeasy.net>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >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_at_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: <F001.0050A562.20021124152335_at_fatcity.com>
> > >X-Comment: Oracle RDBMS Community Forum
> > >X-Sender: Jeremiah Wilton <jwilton_at_speakeasy.net>
> > >Sender: root_at_fatcity.com
> > >Errors-To: ML-ERRORS_at_fatcity.com
> > >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: root_at_fatcity.cts.com
> > >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 <john_g123_9_at_yahoo.com>
> > > > >
> > > > >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: jwilton_at_speakeasy.net
> > >
> > >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: ListGuru_at_fatcity.com (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: arupnanda_at_hotmail.com
> >
> > 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: ListGuru_at_fatcity.com (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: john_g123_9_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: shgarg_orafaq_at_hotmail.com
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: ListGuru_at_fatcity.com (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).
Received on Mon Nov 25 2002 - 08:49:13 CST
