Re: URGENT!!! Oracle 8.0.6 password recovery

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 1 Jan 2002 07:46:51 +1100
Message-ID: <3c30ce00$0$5404$afc38c87@news.optusnet.com.au>

Go find the ORA_DBA local group, and add your NT account as a member of it.

You should then be able to get on with a 'connect / as sysdba' or a 'connect internal'.

Once on in that guise, you can reset all other passwords using the 'alter user fred identified by newpass' syntax. You'll particularly want to change SYSTEM's password.

Regards
HJR "Chris" <nothanks_at_home.com> wrote in message news:3C30B239.8060809_at_home.com...
> I am the network manager for a company where we recently had to let our
> DBA go. The problem is he never gave us the dba passwords to the DB. Now
> we are having some issues. Can anyone please assist me in this process.
> I have full physical as well as admin access to the machine.
> It is running NT 4.0. I do however have limited user access to the DB.
> I am NOT a DBA so keep that in mind when answering.
>
> thanks in advance.
>
Received on Mon Dec 31 2001 - 14:46:51 CST