Re: Help!! Oracle Application Crash

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 - 19:40:49 CDT