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 -> Help- connect as sys from client

Help- connect as sys from client

From: andi <andi_at_a.com>
Date: Tue, 19 Nov 2002 14:18:35 +0800
Message-ID: <arcjdh$vlk$1@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:18:35 CST

Original text of this message

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