insufficient privileges when using SYSDBA

From: mark S <slinkyelephant_at_hotmail.com>
Date: 14 Nov 2004 01:56:16 -0800
Message-ID: <574e7e94.0411140156.5dbec954@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
(reposted as original post got added to the bottom of an old thread) Received on Sun Nov 14 2004 - 03:56:16 CST