| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: instance shutdown problem ? (please help)
John,
If you ever had a running database, you did have a controlfile. This is a new install; but are you saying that there was never a database created, with datafiles, redo log files, etc. and you never stored data?
If so then there is no problem. Just use Oracle Database Configuration Manager and delete the instance that is running. And then create a new instance with the same name. You don't have to remember or write the controlfiel creation command.
However, if the database was created and you had data in that, then unless the database is is archivelog mode you can't just create a controlfile. Even if it's in archivelog mode, in order to create a controlfile, you need to know the exact location and names of datafiles and redo log files as well as block sizes, etc. I kind of assume that would be a little difficult to do. But if you can do it, just get the syntax from the manual. Here it is, just in case.
CREATE CONTROLFILE
DATABASE MYSID
LOGFILE GROUP 1 ('c:\oradata\log1.log', 'd:\oradata\log1.log') SIZE 50K,
GROUP 2 ('c:\oradata\log2.log', 'd:\oradata\log2.log') SIZE 50K
NORESETLOGS
DATAFILE 'c:\oradata\system.dat' SIZE 100M
MAXLOGFILES 5
MAXLOGHISTORY 100
MAXDATAFILES 10
MAXINSTANCES 2
ARCHIVELOG
CHARACTER SET F7DEC;
Of course, this is an example. Please replace the necessary details with your environment.
HTH
> 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: 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).Received on Mon Nov 25 2002 - 08:54:06 CST
 |
 |