Re: Help!! Oracle Application Crash

Before trying to recreate the controlfile - though that may be necessary - try issuing the following at a command prompt

ORADIM73 -NEW -SID <yoursidgoeshere> -INTPWD <internmal password goes here> -STARTMODE AUTO -PFILE '<initorafilenamegoeshere>'

in order to recreate the service. you will also need to start the services before trying to recover the database.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Unknown" <ckeeler_at_tampabay.rr.com> wrote in message
news:3CD0A8A8.F7A37885_at_tampabay.rr.com...


> James,

>

> Can you please explain how to do this step by step?

>

> Thanks.

>

> -Chris

>

> James Williams wrote:

>

> > On Thu, 02 May 2002 00:40:49 GMT, Unknown <ckeeler_at_tampabay.rr.com>

> > wrote:

> >

> > Try to use oradim73 to create a new service

> >

> > Startup mount

> >

> > create crontrofile command.

> >

> > You can take an example out of a book and then add your files in.

> >

> > Once you get a working controlfile

> >

> > You should be able to.

> >

> > alter database open resetlogs

> >  if the database came down good otherwise you will need a recover

> > database if you have archivelogs which you probably don't.

> >

> > >Dan,

> > >

> > >Listener works.

> > >

> > >Svrmgr works, but it gives me:  ORA-09325: OracleService(SID) has not

been


> > >started.

> > >

> > >I just can't seem to create and/or start another instance???

> > >

> > >What do you recommend now?

> > >

> > >Thanks.

> > >Christopher C. Keeler

> > >

> > >

> > >

> > >Daniel Morgan wrote:

> > >

> > >> Unknown wrote:

> > >>

> > >> > Hello,

> > >> >

> > >> > I have, rather "HAD" an Oracle Database v. 7.3 running on NT crash.

> > >> >

> > >> > The good news is, the database instances were on D drive.

> > >> >

> > >> > I re-installed Oracle back to C drive, but do not know how to

create a


> > >> > new instance, and point Oracle to the still intact database files

on D


> > >> > drive.

> > >> >

> > >> > I have a backup of the init<SID>.ora file, as well as the control

files,


> > >> > but do not know how use these to recover the database.

> > >> >

> > >> > Please help this newbie, cause all of my PL/SQL code in stored in

the


> > >> > DB.

> > >> >

> > >> > Thank you.

> > >> >

> > >> > Sincerely,

> > >> > Christopher C. Keeler

> > >>

> > >> The best help I can give you is to NEVER store all of your PL/SQL

code in


> > >> any one place. Doing so stands on a fine line between masochistic and

> > >> suicidal.

> > >>

> > >> Have you tried starting the listener?

> > >>

> > >> c:\oracle\ora81\bin>lsnrctl start

> > >>

> > >> Does it start?

> > >>

> > >> c:\oracle\ora81\bin>lsnrctl status

> > >>

> > >> Can you get into server manager?

> > >>

> > >> c:\oracle\ora81\bin>svrmgrl

> > >>

> > >> Can you connect?

> > >>

> > >> SVRMGR> connect internal

> > >>

> > >> Can you run a simple SQL statement?

> > >>

> > >> SVRMGR> select count(*) from tab$;

> > >>

> > >> If you get any errors report back the full error text not just the

number.


> > >>

> > >> Daniel Morgan

> > >

>