ORA-01031: insufficient privileges

From: mark S <slinkyelephant_at_hotmail.com>
Date: 13 Nov 2004 15:20:18 -0800
Message-ID: <574e7e94.0411131520.d82d6f7@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 Received on Sat Nov 13 2004 - 17:20:18 CST