Skip to Content
avatar image
Former Member

ORA-01031: insufficient privileges error

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

E:\Documents and Settings\Administrator>sqlplus/nolog

SQLPlus: Release 10.2.0.2.0 - Production on Sun Jul 20 12:30:17 2008*

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> connect as sysdba

Enter user-name: system

Enter password:

ERROR:

ORA-01031: insufficient privileges

SQL>

iam using ecc6.0

any one give me solution

Edited by: Mugala Balu on Jul 20, 2010 9:05 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 27, 2010 at 05:07 AM

    My first question is why you are trying to connect your DB from Administrator user?

    You don't have any DB admin (SIDADM or ORASID) in your landscape?

    As told by above techies, just logoff from administrator and relogin with SIDADM then try....it should work.

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi,

      try this :

      set ORACLE_SID=<SID>
      set ORACLE_HOME=<Home of your oracle installation>
      
      sqlplus / as sysdba
      

      regards,

  • avatar image
    Former Member
    Jul 20, 2010 at 07:21 AM

    You can use the below command also to connect to database

    sqlplus "/as sysdba"

    if you again face the error, please logoff and login with SIDADM and try the above command.

    thanks,

    Mahendra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 22, 2010 at 09:33 AM

    Hi,

    your logged on as "Admin"

    Trying logging on as "sid<adm>" ora "ora<sid> and try again..

    Mark

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 26, 2010 at 09:35 AM

    Hi Mugala,

    login with your <SID>adm user, then connect to your database as sqlplus /as sysd\ba.

    hopefully it will resove your problem.

    Regards,

    Priya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 26, 2010 at 12:02 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded