Check your sqlnet.ora on the server. If it says
SQLNET.AUTHENTICATION_SERVICES=(NTS) try setting it to be equal to (NONE),
or comment out the entire line. Then try again.
Regards
HJR
"andi" <andi_at_a.com> wrote in message
news:arcjdh$vlk$1_at_mawar.singnet.com.sg...
> Hi All,
> I'm using oracle 8i, win2k,
> and set the parameter remote_login_passwordfile=exclusive
>
> SQL> select * from v$pwfile_users;
>
> USERNAME SYSDB SYSOP
> ------------------------------ ----- -----
> INTERNAL TRUE TRUE
> SYS TRUE TRUE
>
> But when I tried to login from client using user SYS the error occured:
>
> SQL> connect sys/change_on_install as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> How to solve the problem?
> TIA
>
>
>
>
Received on Tue Nov 19 2002 - 00:42:06 CST
