Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: LOST DataBase Password
Huh???
"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.
>
> 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
>
> --------------------------------------------------------------------------
--Received on Thu May 02 2002 - 00:55:52 CDT
> ------------------------------------------
>
>
> "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
>
>
![]() |
![]() |