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: sys ans system password

Re: sys ans system password

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Thu, 25 May 2006 20:12:50 GMT
Message-ID: <Izu85M.IBM@igsrsparc2.er.usgs.gov>


shark wrote:
> Hi all,
>
> i installed 10g but i don't remeber whether i hv given a password for
> sys & system . As a result of which i can tn connect 2 the D/b . i
> treid using the default password of this 2 acct but it does nt wrk :(
> .
> is there ne way in which i can i reset this passwrd using o/s
> authentication.
>
> os windows 2000 server.
> oracle version 10g
>
>
> thanks.
>

Sign on to the Windows box with the account you used to create your database. Then do the following in a DOS window:

sqlplus /nolog
connect / as sysdba
alter user sys identified by new_password; alter user system identified by new_password; exit

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Thu May 25 2006 - 15:12:50 CDT

Original text of this message

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