Skip to Content
avatar image
Former Member

ORA-01031: insufficient privileges : DB13 CheckDB error

Hi All,

I am getting below error in DB13- checkDB.

I have run the sapdba_role but same error.

BR0280I BRCONNECT time stamp: 2009-09-15 06.30.08

BR0818I Number of tables found in DBDIFF for owner SAPR3: 2

BR0280I BRCONNECT time stamp: 2009-09-15 06.30.08

BR0301E SQL error -1031 at location BrDdartRead-1, SQL statement:

'PREPARE stmt_6 STATEMENT FROM'

'SELECT TABART FROM "SAPR3".DDART ORDER BY TABART'

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: ceblwauo.chk 2009-09-15 06.30.08

BR0280I BRCONNECT time stamp: 2009-09-15 06.30.08

BR0804I BRCONNECT terminated with errors

Sap: 45B

oracle: 9.2

Thanks in advance.

Vinod

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 15, 2009 at 11:56 AM

    This should fix your error:

    sqlplus "/ as sysdba"

    grant SELECT on SAPR3.DDART to sapdba;

    exit

    if it still fails later, also add these:

    Sqlplus "/ as sysdba"

    grant ALL on SAPR3.SDBAH to sapdba;

    grant ALL on SAPR3.SDBAD to sapdba;

    grant ALL on SAPR3.DBAML to sapdba;

    grant ALL on SAPR3.DBARCL to sapdba;

    grant ALL on SAPR3.DBAFID to sapdba;

    grant ALL on SAPR3.DBAEXTL to sapdba;

    grant ALL on SAPR3.DBAREOL to sapdba;

    grant ALL on SAPR3.DBABARL to sapdba;

    grant ALL on SAPR3.DBADFL to sapdba;

    grant ALL on SAPR3.DBAOPTL to sapdba;

    grant ALL on SAPR3.DBASPAL to sapdba;

    grant ALL on SAPR3.DBABD to sapdba;

    grant ALL on SAPR3.DBABL to sapdba;

    grant ALL on SAPR3.DBATL to sapdba;

    grant ALL on SAPR3.DBAOBJL to sapdba;

    grant ALL on SAPR3.DBAPHAL to sapdba;

    grant ALL on SAPR3.DBAGRP to sapdba;

    grant ALL on SAPR3.DBAERR to sapdba;

    grant ALL on SAPR3.DBATRIAL to sapdba;

    grant ALL on SAPR3.DBSTATC to sapdba;

    grant ALL on SAPR3.DBSTATTORA to sapdba;

    grant ALL on SAPR3.DBSTATIORA to sapdba;

    grant ALL on SAPR3.DBSTATHORA to sapdba;

    grant ALL on SAPR3.DBSTAIHORA to sapdba;

    grant ALL on SAPR3.DBMSGORA to sapdba;

    grant ALL on SAPR3.DBCHECKORA to sapdba;

    grant ALL on SAPR3.MLICHECK to sapdba;

    grant SELECT on SAPR3.TGORA to sapdba;

    grant SELECT on SAPR3.IGORA to sapdba;

    grant SELECT on SAPR3.TSORA to sapdba;

    grant SELECT on SAPR3.TAORA to sapdba;

    grant SELECT on SAPR3.IAORA to sapdba;

    grant SELECT on SAPR3.SVERS to sapdba;

    grant SELECT on SAPR3.CVERS to sapdba;

    grant SELECT on SAPR3.DD02L to sapdba;

    grant SELECT on SAPR3.DD09L to sapdba;

    grant SELECT on SAPR3.DDNTT to sapdba;

    grant SELECT on SAPR3.DDART to sapdba;

    grant SELECT on SAPR3.DARTT to sapdba;

    grant SELECT on SAPR3.DBCHK to sapdba;

    grant SELECT on SAPR3.DBDIFF to sapdba;

    grant ALL on SAPR3.SAPLIKEY to sapdba;

    grant SELECT on SAPR3.RSNSPACE to sapdba;

    grant SELECT on SAPR3.RSPSPACE to sapdba;

    exit;

    good luck.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Please check the below sap notes.

      91216 - BRBACKUP-SAPDBA ORA-01031 Insufficient privileges

      126248 - SAPDBA Check causes ora-01031

      761745 - Oracle 9 ORA-01031 and ORA-06512 with DBMS_STATS

      900525 - BRCONNECT fails with ORA-01031 at location BrDdartRead-1

      1028220 - ORA-01031 Insufficient privileges despite SAPCONN role

      834917 - Oracle Database 10g New database role SAPCONN

      134592 - Importing the SAPDBA role (sapdba_role.sql)

      In my case insufficient privileges to DDART table after given permission like below issue resolved.

      grant SELECT on SAPR3.DDART to sapdba;

      Regards,

      Vinod

  • avatar image
    Former Member
    Sep 15, 2009 at 11:57 AM

    Hi,

    Please see the OSS below OSS Note matches to your scenario.

    [Note 761745 - Oracle 9: ORA-01031 and ORA-06512 with DBMS_STATS|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=761745]

    Thanks,

    Shambo

    Add comment
    10|10000 characters needed characters exceeded