Re: help with recovery

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:4061e666$0$18490$afc38c87_at_news.optusnet.com.au...
>
> OK. Who are you logged onto the Windows box as (ie, which Windows account
> name did you use?)?
>
> You want to check the users and groups on this machine: there should be
one
> called ORA_DBA. Your Windows user account should be a member of that
group.

I've done everything as Administrator (oracle installation, all these tests) through terminal services. It's a spare dedicated box on my internal LAN pressed into service for this.

> If you can't fiddle with that, then bear in mind you are in the business
of
> trying to start an Oracle instance, which is a privileged action, and
which
> therefore SYSTEM has no hope in hell of ever pulling off. You should be
> trying instead with the SYS account, passwords change_on_install, oracle,
or
> anything you remember from before the hard disk failure!
>
> If none of that works, we may have to create a new password file to get
> authenticated. If none of the above works (and it should) then use oradim
to
> delete the service you just (triumphantly!) created, and oradim to
re-create
> it. Only when you re-create it, you'd type:
>
> oradim -NEW -SID xxxx -INTPWD fred
>
> And *before* you re-create it, you'd type:
>
> orapwd file=C:\oracle\orapwfred password=fred entries=25

Ok, that worked :)
I'm now connected to an idle instance.

"oradim -shutdown -sid xxx -shuttype srvc" works, but gives

    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist in the oradim.log

Experimenting with startup mount/nomount seems to hang. btw, the directory structure for this is identical to the old system, so I would think the control files would be ok. But to check, I did the create pfile from spfile. Paths look ok.
Also, so far as I can tell, all the oradata files were retrieved successfully.

Dave Received on Wed Mar 24 2004 - 15:24:53 CST