Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: insufficient privileges when using SYSDBA

Re: insufficient privileges when using SYSDBA

From: zeb <spam_at_nowhere.com>
Date: Sun, 14 Nov 2004 12:32:44 +0100
Message-ID: <41974175$0$4568$636a15ce@news.free.fr>


> 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)

What is your REMOTE_LOGIN_PASSWORDFILE
exclusive ?
if not set it Received on Sun Nov 14 2004 - 05:32:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US