Re: ORA-01031: insufficient privileges

slinkyelephant_at_hotmail.com (mark S) wrote in message 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

The issue here is the ablity to connect to your instance remotely as sysdba; this requires a password file generated by orapwd and an init.ora parameter, remote_login_passwordfile, set to shared or exclusive (I prefer exclusive). If this parameter is set to NONE then no password file is utilised and no possibility exists of a remote login with sys as sysdba, which explains your error message.

I'd check your installation and correct that which is necessary so that remote logins as SYS as SYSDBA are enabled.

David Fitzjarrell Received on Sun Nov 14 2004 - 19:41:57 CST