Re: insufficient privileges as sysdba 8.1.7 on Win2k

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 04 Oct 2002 01:07:57 +0200
Message-ID: <6bjppukrj5gju0ilq6maoadk8fki6264qq@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:07:57 CDT