Re: ORA-01031: insufficient privileges

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 13 Nov 2004 23:41:53 GMT
Message-ID: <Xns95A09FB0A17FSunnySD@68.6.19.6>

slinkyelephant_at_hotmail.com (mark S) wrote in news:574e7e94.0411131520.d82d6f7_at_posting.google.com:

> Hi we're running Oracle 8 on unix AIX.
>
> When I try to connect to dba studio on my windows xp pro machine I
> have a problem.
>
> Connecting as sys with SYSOPER works, however when I select SYSDBA
> this produces the following error:
> ORA-01031: insufficient privileges
>
>
> This is really confusing me as I've read SYSOPER and SYSOPER are both
> just privileges which by default should be granted to the sys account.
> Also I have checked and the sys account is assigned to the dba group
> on our unix box. I don't understand how one works but not the other.
> Any ideas?
>
> I can provide more detailed information if required.
>
>
> Mark
>

If TWO_TASK is set, then
unset TWO_TASK Received on Sat Nov 13 2004 - 17:41:53 CST