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:53:30 +0800
Message-ID: <arcsg1$1ar$1@mawar.singnet.com.sg>


Hi,
I've changed the sys's password and tried to connect from client. Below is the result, error still occurs.

SQL> connect sys/oracle
Connected.
SQL> connect sys/oracle as sysdba
ERROR:
ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE. SQL> Any other idea ?
TIA "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:upsjtu0v72ttd81cpmrleigddo9q7rre6u_at_4ax.com...
> On Tue, 19 Nov 2002 16:08:06 +0800, "andi" <andi_at_a.com> wrote:
>
> >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.
>
>
> Most likely you changed the remote_login_passwordfile parameter
> without changing the SYS password.
> When remote_login_passwordfile = exclusive the SYS and internal
> password are supposed to be the same. If they're not, you are toast.
> Simply alter user SYS identified by password, this will now change
> both the SYS password and the internal password.
>
>
>
> Also I don't believe Howards advice is correct. AFAIK it *only* works
> on the server with NTS *set*
>
>
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Nov 19 2002 - 02:53:30 CST

Original text of this message

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