Re: ORA-01031 error message

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 16 Mar 2001 21:30:36 +0100
Message-ID: <tb4trg1grd9m14@beta-news.demon.nl>

"Rodney Li" <rodney.li_at_stelco.ca> wrote in message news:7rus6.155604$Z2.1967710_at_nnrp1.uunet.ca...
> Hi All,
> I just set up this Oracle Server 8.1.6 Enterprise Ed. Now, I can connect
> using sys_at_SID/password fine, same thing with any other user. However, when
I
> try connecting as internal_at_SID/password, I get the error:
> ORA-01031: insufficient privileges.
> Anyone experienced that?
> Thx,
> Rodney
>
>

First of all: try using the *proper* syntax, as documented in your manuals: <username>/<password>@service
Secondly it looks like your user is not a member of the dba group (Unix) or the local ora_dba group (NT)

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Mar 16 2001 - 14:30:36 CST