Re: LOST DataBase Password

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Wed, 01 May 2002 03:21:21 GMT
Message-ID: <RaJz8.4247$gR7.2504767686@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.

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 - 22:21:21 CDT