Re: help with recovery

"daveb" <davebest_at_SuPsAaM.net> wrote in message news:<IaadneROCqM7YfzdRVn-gQ_at_speakeasy.net>...
> "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

Sometimes the registry gets screwy in this sort of situation. Check especially entries like ORA_<SID>_AUTOSTART ORA_<SID>_PFILE ORACLESERVICE<SID> ORA_NLS33 and check for multiple oracle homes.

Also, disable the service and reboot the server, there be bugs. Look around for different versions of log files like alert*log and hidden files in <oracle_home>\DATABASE. Check task manager for oracle.exe running when you think it shouldn't be. The KILL command in DOS can be useful. Look in any alert logs you found for "waiting for active calls to complete." Set sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NONE) to check for some bizarro bug.

Just some stuff I've run into.

jg

--
@home.com is bogus.
Happy Big 5-0, color TV!