Re: logon as sysdba -- insufficient privileges ?!?!?

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:dh0ab0pgilj5ata51n0s05ohqorutroot0_at_4ax.com...

> >
> >Looks like the same known bug as I ran into today, running 8.1.7.0.0,
> >like you. The problem is you are using a *domain* account (which you
> >shouldn't, btw, according to documentation)
> >It has been resolved in the meantime, don't recall in which release.
> >Never mind, you should upgrade to 8.1.7.4.1 minimum anyway.
> >The workaround as usual, is to edit sqlnet.ora and disable
> >sqlnet.authentication_services by changing nts to none.
>
> Hmm. Ok, I patched it up to 8.1.7.4.1, but still no-go -- still get
> the ORA-01031: insufficient privileges when trying to 'connect / as
> sysdba'.

I hate to say I told you so, but, er, I did kind of mention that patching blindly wasn't necessary going to be the issue in this case, particularly since 8.1.7.0 does O/S authentication at Chez Dizwell with no problems.

> Having a domain account in the local ORA_DBA group, and having
> sqlnet.authentication_services = (NTS) is how we have virtually every
> Windows (NT and 2k) server here -- over 30 of 'em. This is the only
> one not working. However, to leave no stone unturned, I created a
> local account for myself on the server, logged on with that account,
> and tried again, both with sqlnet.authentication_services = (NTS) and
> sqlnet.authentication_services = (NONE). No matter, connect / as
> sysdba always returns "insufficient privileges".

Can you do me a three minute favour. Add 'Everyone' to the ORA_DBA group, and try again.

Then report back.

Regards
HJR Received on Wed May 26 2004 - 16:17:58 CDT