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: Help - How to recover dba password

Re: Help - How to recover dba password

From: <cservehk>
Date: Tue, 21 Aug 2001 10:40:05 +0800
Message-ID: <3b81caec@newsgate.hknet.com>


Thanks,
I am able to get in as system.

"Paul Drake" <paled_at_home.com> wrote in message news:3B7E382C.F92371E7_at_home.com...
> cservehk wrote:
> >
> > I have an oracle 8i install on win2k server.
> > I hae nt admin password. a user account that connect to the oracle
server.
> > Can anyone help?
>
> login to the console with an account that belongs to the local group
> ORA_DBA
> or ORA_%ORACLE_SID%_DBA.
>
> in the sqlnet.ora - make sure that the following parameter is
> configured:
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> at a command prompt, type:
>
> C:\> set oraccle_sid=<your sid>
>
> C:\> svrmgrl
>
> SVRMGR> connect / as sysdba
> Connected.
> SVRMGR> alter user <username> identified by "<new password>";
>
>
> that will reset the password to a user account.
>
> the other method is to remove the existing password file, and create a
> new one.
>
> C:\> orapwd -- this will display the help page for the
> orapwd.exe utility.
>
> hth,
>
> Paul
Received on Mon Aug 20 2001 - 21:40:05 CDT

Original text of this message

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