Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: LOST DataBase Password

Re: LOST DataBase Password

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Thu, 02 May 2002 05:55:52 GMT
Message-ID: <Ix4A8.1657$6T5.172874@bgtnsc05-news.ops.worldnet.att.net>


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
>
> --------------------------------------------------------------------------

--

> ------------------------------------------
>
>
> "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 Thu May 02 2002 - 00:55:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US