Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: help with recovery

Re: help with recovery

From: Howard J. Rogers <>
Date: Thu, 25 Mar 2004 06:49:56 +1100
Message-ID: <4061e666$0$18490$>

"daveb" <> wrote in message
> "Howard J. Rogers" <> wrote in message
> news:40611c61$0$3956$
> Ok, started over as you suggesed.
> > Create a new service. At the command line:
> >
> > oradim -NEW -SID xxxx -STARTMODE auto
> >
> > The "xxxx" there should be whatever the SID was on the old machine for
> this
> > database. There's a privileged user authentication issue here which I'm
> > hoping won't be an issue because this is Windows and you're almost bound
> to
> > be a member of the ORA_DBA group already. But you may experience
> > trying to get the service to start if you aren't.
> >
> > Check that the new service is started.
> oradim.log shows instance created and Services shows that it is running.
> > In a DOS window (command line, whatever!), set your ORACLE_SID=xxxx:
> >
> > set ORACLE_SID=xxxx
> >
> > Then launch SQL*Plus:
> >
> > sqlplus "/ as sysdba"
> This gives ORA-01031: insufficient privileges.
> So I tried sqlplus system

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.

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

(You might want a better location for the thing. And "fred" thus becomes SYS's password. )
So you'd then launch SQL*Plus with:

sqlplus "sys/fred as sysdba"

Make sure you've set ORACLE_SID as an environment variable before you start doing anything, too.

HJR Received on Wed Mar 24 2004 - 13:49:56 CST

Original text of this message