you are getting this because unix user system has not been granted sysdba
role. Oracle user SYSTEM will give you the same error until you grant
sysdba role to him
SQL> grant sysdba to userid;
Also, why in the heck would you have a unix user named 'system' to connect
to the oracle database whih aread has a builtin user SYSTEM.
you are asking for trouble.
Discontinue using an ops$system and set up a reasonable userid.
----- Original Message -----
From: "nitin" <oracledba-ezmlmshield-x11608421.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, November 02, 2006 3:48 AM
Subject: ORA-01031 after connecting as OPS$
> Dear Experts,
> I am getting the ORA-01031 after I connect to SQL PLUS as external user.
> Please have a look at the following
>
> plmpal03 system [system]:>id
> uid=400(system) gid=201(dba) groups=201(dba)
> plmpal03 system [system]:>sqlplus /
>
> SQL*Plus: Release 9.2.0.2.0 - Production on Wed Nov 1 16:34:41 2006
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
> With the Partitioning and Oracle Data Mining options
> JServer Release 9.2.0.2.0 - Production
>
> SQL> show user
> USER is "OPS$SYSTEM"
> SQL> conn / as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
>
> Warning: You are no longer connected to ORACLE.
> SQL>
>
> Any help is highly appreciated.
> Thanks in advance.
>
> Nitin
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
Oracle LazyDBA home page