Re: insufficient privileges as sysdba 8.1.7 on Win2k

"todhsals" <todhsals_at_hotmail.com> wrote in message news:9APm9.21972$DN4.3891_at_sccrnsc01...
>
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:k6Pm9.45140$g9.128706_at_newsfeeds.bigpond.com...
> >
> > "todhsals" <todhsals_at_hotmail.com> wrote in message
> > news:RZOm9.20426$xI5.4066_at_sccrnsc02...
> >
> > "The OS
> > account I'm using is a domain account the local ORA_DBA and
> > Administrators groups"
> >
> > Noe that's appalling grammar, but never mind: are you saying that the
> > account I've logged onto this Windows box is a domain account, and it
> > happens to be a member of the *LOCAL* ORA_DBA group?
>
> Corrected by appaling spelling, "Noe" ; ) I saw the missing word right
> after I sent it.
>

Actually, that's the correct spelling for about the 11th century.

> Yes, domain user account that is a member of the local group named
ORA_DBA.
> I'm quite certain the group was created by the install process because
even
> the description line exactly matches the group description on functional
box
> I installed myself & the group was created by the installer.
>
> >
> > If you log onto that box as Domain_Fred and Domain_Fred is a member of
the
> > local ORA_DBA group, then a connect / as sysdba should elicit a
perfectly
> > reasonable connection, and startups and shutdowns should be no problem.
> >
>
> This was my reading of the docs but it does not work.

Probably the most irritating phrase in Christendom is "it doesn't work". WITH WHAT ERROR MESSAGE ARE YOU MET is the inevitable reply!

;-)

>I have another
> 8.1.7/Win2k box & it works fine.
>

[Snip]
>
> My reading of the docs is that remote_login_passwordfile has no affect on
> local connections.
>This seems to be the case on my other 8.1.7/Win2k box.
> From the local console I can connect / as sysdba no password to startup,
> shutdown etc. From a remote box I can shutdown by connect sys as sysdba
with
> the password.
>
> The one difference is that on the system I'm having the trouble with,
> sqlnet_authentication_services is set to none (in sqlnet.ora), if I set it
> to NTS like the working box then I can't connect to it at all.

And the error message you get is....?

>This might
> not be relevant but I thought the problems might be related. Eventually I
> need to get OS auth working for users so I need to solve this part as
well.
>

Forget the remote connections. That's just another level of complexity. Get the local connections working properly first, and then we can get fancy.

So, enable NTS in sqlnet.ora, and then tell me the EXACT error message you get when you then try and connect, locally, as "/ as sysdba".

Regards
HJR
> >

[Snip] Received on Thu Oct 03 2002 - 02:17:23 CDT