Re: Help!! Oracle Application Crash

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
> >
Received on Wed May 01 2002 - 21:47:22 CDT