Skip to Content
avatar image
Former Member

ORA-0131 :insufficient privileges

Dear ALL,

I am running below comand sqlplus / as sysdba

ORA-0131 :insufficient privileges ,I am running this comand through SIDadm  user.

The user is memeber of ADMIN groups ,ORA_DBA and etc .

Please suggest any one how to proceed further.

SAP system also down (Java system)  in MMC JSTART.EXE is stopped.

Please suggest

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 24, 2013 at 02:34 PM

    Hi Sap

    You can follow the below link.

    http://scn.sap.com/thread/1192924

    http://scn.sap.com/thread/1411712

    http://scn.sap.com/thread/1854642

    http://www.dba-oracle.com/t_ora_01031_insufficient_privileges.htm

    follow the below sap notes :

    1. sapnote 834917

    2. Note 91216 - BRBACKUP/SAPDBA: ORA-01031 Insufficient privileges

    3. Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role

    With Regards

    Ashutosh Chaturved


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2013 at 11:58 PM

    Hi,

    Do you have multiple DB instance running on your server? in this case check your DBSID and SID... you must use the right <SID>adm

    You can try interactive connection to db:

    sqlplus /nolog

    then:

    connect / as sysdba

    Regards,

    Shahab

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      If you have multiple instance, please

      -check your ORACLE_SID and ORACLE_HOME variable.

      -please also check again if your user is a member of ORA_DBA or ORA_<DBSID>_DBA

      -also check if the OPS$<SID>ADM user is created in your database

      could you please also try:

      connect /@<your DBSID> as sysdba

      hope this helps.

      Shahab