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

  • Feb 25, 2013 at 06:29 AM

    hi Dear,

    Please have a look at below SAP notes and link

    Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

    Please download the role( sapdba_role_ora10.SAR) and apply.

    If still get the same issue then have a go through these too.


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

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

    ORA-01031 Insufficient privileges

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 25, 2013 at 06:46 AM

    Hi,

    >> ORA-0131 :insufficient privileges

    Check the ops$ mechanism is running correctly.

    Is it pure java stack? Find the database user in secure store on configtool. Paste the statement output, below;

    SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = <J2EE_DB_USER>;

    Best regards,

    Orkun Gedik

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Deepak Kori

      Hi,

      I ma trying to genarte the pwd file but its showing error please suggest any idea ,already renamed to old passowrd file

      C:\Users\ssmadm>orapwd file=D:\oracle\SSM\11202\database\PWdSSM.ora password=jkt
      123

      OPW-00001: Unable to open password-file