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

Re: Help- connect as sys from client

From: andi <andi_at_a.com>
Date: Tue, 19 Nov 2002 16:08:06 +0800
Message-ID: <arcpqs$12d$1@mawar.singnet.com.sg>


Hi,

I've updated the server's sqlnet.ora (1st attempt changed to NONE and second attempt commented out the parameter),
and restart the database, but still cannot connect, the same error message occured.
I'm using client's side sqlplus 8.0.6.0.0 from oracle developer 6i

Any other way?
TIA. "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:BWkC9.79536$g9.224186_at_newsfeeds.bigpond.com...
> 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 - 02:08:06 CST

Original text of this message

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