Re: insufficient privileges as sysdba 8.1.7 on Win2k

Thanks,

This is sort of the opposite of what is going on here. Exclusive does work & both of the passwords are the same. It's "none" tat does not work.

Tod

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:6bjppukrj5gju0ilq6maoadk8fki6264qq_at_4ax.com...
> On Thu, 03 Oct 2002 21:47:17 GMT, "Tod H Sals" <todhsals_at_hotmail.com>
> wrote:
>
> >Finally, I went back & set remote_login_passwordfile = EXCLUSIVE &
restarted
> >the service. At this point connect internal with the correct password
> >specified in orapwd gets me connected. An incorrect password does not
work
> >and connect / as sysdba does not work. For an internal connection isn't
it
> >supposed to ignore the password?
>
>
> with remote_login_passwordfile = exclusive the SYS and internal
> password are expected to be identical and can be changed with alter
> user SYS identified.
> If they are not the same (which they always are with
> remote_login_passwordfile = none) and you change
> remote_login_passwordfile you'll hit ora-1031.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Thu Oct 03 2002 - 18:17:17 CDT