Re: LOST DataBase Password

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 1 May 2002 14:14:58 +1000
Message-ID: <G%Jz8.41$su6.245@news.oracle.com>

"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message news:RaJz8.4247$gR7.2504767686_at_newssvr21.news.prodigy.com...
> Make sure if Windows you are logged as user with ORA_DBA group or UNIX
with
> dba group.
>
> Then:
> $sqlplus /nolog
> SQL>conn / as sysdba
> SQL> alter user <whatever> identified by <new_password>;
>
> The password is recorded in data dictionary but is encrypted so you will
> have hard time to decrypted.

It is *not* encrypted. It's hashed. There's a difference -though, even hashed, it's going to be near-impossible to interpret it correctly.

HJR
>
> If you have user login with DBA privileges, then you can use a script to
> connect to any user account w/o password. The scripts is here:
>

http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi?s=3ccefcda1598ffff;act=ST;
> f=14;t=248
>
> Check the latest Oracle DBA forums at:
> http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi
>
> Hope that helps,
>
> Trifon Anguelov
> Senior Oracle DBA
>
> http://www.dbaclick.com
>
> --------------------------------------------------------------------------

--


> ------------------------------------------

>

>

> "kashveti" <kashveti_at_yahoo.com> wrote in message

> news:176491e2.0204301136.3917ac47_at_posting.google.com...

> > i have setup  oracle server 9, designed a database, but lost my

> > password to it. Now i can't get an access to my database files. does

> > anybody knows how to change password manualy or maybe it is recorded

> > in some .log files? HELP PLEASE

>

>

Received on Tue Apr 30 2002 - 23:14:58 CDT