Re: I can't connect as SYSDBA

Then add yourself as a member of the ORA_DBA group on the Windows server.

That's a LOCAL group, not a domain one. Membership of it means you can, on that machine, log on as you (say your NT Server username was "Juha" -remember, we're not talking about logging on to the domain), and then log on to the database by doing a 'connect / as sysdba'.

Once that works, you can just issue an 'alter user sys identified by new_password', and you should then be able to connect using the password file again.

But this workaround will require you to work locally, on the server, and be able to log on to it, as a local user with the privileges necessary to add yourself into the ORA_DBA group.

Regards
HJR "juha" <salmjuh_at_hotmail.com> wrote in message news:c9858ca5.0207232123.71d49a55_at_posting.google.com...
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:<35c%8.42209$Hj3.126920_at_newsfeeds.bigpond.com>...
> > Hi Juha,
> >
> > I'm not entirely sure how you're attempting to login so I'm assuming
you're
> > trying to logon as sys/password as sysdba ?
> >
> > If so, did you create a password file (orapwd) ? If so, do you remember
the
> > value of the password=value parameter. If not you'll be cursing as that
> > (like I say I think) is the password you're after.
> >
>
> I have no idea how that password file was created. Former
> administrator change employer and I have absolutely no idea what our
> system keep inside.
>
>
> Buy the way. OS is Windows NT4.0 server and oracle is version 8.0.4
>
>
> > If I've described the scenario correctly, you can either login using O/S
> > authentication (connect / as sysdba) but you need to be an authenticated
> > user on the O/S (such as a member of dba group) or you can delete and
> > recreate the password file (this time taking note of the password
> > parameter).
> >
>
>
> If I delete the password file it will delete ALL passwords ? Is this
> right. If so, I can't do it, because there is usernames used by
> applications and if I recreate the password file thous applications
> would stop working ?
>
>
> Juha
>
>
>
> > Get in there mate
> >
> > Richard
> > "juha" <salmjuh_at_hotmail.com> wrote in message
> > news:c9858ca5.0207230221.7e02e10c_at_posting.google.com...
> > > Hi all
> > >
> > >
> > >
> > > I can connect as (sys/"password") normal BUT I can't connect as
> > > SYSDBA. Is there different password ? And after installation is't
> > > oracle ? I tried that also, but didn't work.
> > >
> > >
> > > I am new whit oracle and this database and I can't get backups from
> > > the server because don't know the right password.
> > >
> > > Also, I can log to "Security" application and when I look priviledges
> > > for sys, there is everything enabled. So, if I can connect as normal
> > > whit SYS username, why I can't backup?
> > >
> > >
> > > So, any ideas what I should do?
> > >
> > >
> > >
> > > Thanks for all hints
> > >
> > >
> > > Juha
Received on Wed Jul 24 2002 - 02:05:42 CDT