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: reset password for sys/system? how?

Re: reset password for sys/system? how?

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Tue, 08 Apr 2003 22:21:17 -0700
Message-ID: <3E93ADCC.3442BDA6@exxesolutions.com>


Sybrand Bakker wrote:

> On Wed, 09 Apr 2003 04:03:15 GMT, "Mark A. Thomas"
> <marktuid4att_at_att.net> wrote:
>
> >I lost the password for sys and system.
> >Is there a file I can modify or another user (outln) that I can
> >log on as and rest sys and system to something new?
> >
> >TIA
> >
> >/markt
> >marktuid4att_at_att.net
>
> Just connect / as sysdba in sql*plus on the server, and issue an alter
> user command. Or use any other user with alter user privilege.
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Or delete the file PWDsid.ora.

Remember that to do what Sybrand suggests ... and it is certainly the best solution ... you must be loggged onto the server's operating system as the owner of Oracle.

Daniel Morgan Received on Wed Apr 09 2003 - 00:21:17 CDT

Original text of this message

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