Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Lost Password problem
Thanks for the suggestion.
I can set the password for the user SYS successfully (using your instructions), though it still will not allow me to reach the Oracle Management Server (it claims I have incorrect credentials). Is it possible to export the schema directly from SQL rather than through the export tool found in the Database Manager Console?
Thanks for your help,
MThomas
"Michael J. Moore" <hicamel_x_the_spam_at_attbi.com> wrote in message
news:hZIj9.188101$Jo.66278_at_rwcrnsc53...
> I believe that any user with DBA authority can reset the password for SYS.
> Log on as SYSTEM and
> alter user sys identified by newpassword;
>
> "MThomas" <markt_at_wrx-ca.com> wrote in message
> news:6VGj9.2994$i%.789102_at_localhost...
> > Good morning:
> >
> > We are curently evaluating Oracle 9i and due to circumstances have lost
> the
> > password (the SYS account) to log into the Oracle Management Server. Is
> > there a method by which to recover the password or to access the server?
> >
> > Barring that is there a way to export a schems without connecting to the
> > Management Server. recovery of the schema would allow for the
> > reinstallation of Oracle and the subsequent resetting of the password.
> >
> > Thanks for your help,
> >
> > MThomas
> >
> >
>
>
Received on Mon Sep 23 2002 - 15:12:44 CDT