Re: Lost Password problem

Thanks for the advice on the EXP function.

We have now been able to retrieve the existing schema from the server.

MThomas

"Michael J. Moore" <hicamel_x_the_spam_at_attbi.com> wrote in message news:JsLj9.379584$kp.1148748_at_rwcrnsc52.ops.asp.att.net...
> yes, you can bring up a command window and type in
> EXP
>
> It should prompt you through the export options.
> EXPort is a batch utility and you can read about it in the oracle
utilities
> manual.
>

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920
> /a96652.pdf
>
>
> I think that the problem you are having with OEM is that OEM keeps it's
own
> set of usernames internally (in it's repository). It is saying that the
OEM
> user id ( not the database user id) that you are logged on under does not
> sufficient credentals.
> Mike
>
>
>
> "MThomas" <markt_at_wrx-ca.com> wrote in message
> news:pBKj9.3010$i%.792615_at_localhost...
> > 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 Tue Sep 24 2002 - 15:29:09 CDT