ORA-01031: insufficient privileges : DB13 CheckDB error

[Former Member]

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

[former_member204746 · Accepted solution]

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.

[Former Member · Accepted solution]

Thank You Very Much,

The problem was solved.

[Former Member · Accepted solution]

Hi Vinod,

can u plz tell how did u solve this issue . i have same backup failure issue .

BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:

'CONNECT / AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0056I End of database backup: bebynmur.anf 2009-11-20 20.30.41

BR0280I BRBACKUP time stamp: 2009-11-20 20.30.41

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2009-11-20 20.30.41

BR0291I BRARCHIVE will be started with options '-U -d util_file -c force -p initSID.sap -cds'

BR0280I BRBACKUP time stamp: 2009-11-20 20.30.43

BR0292I Execution of BRARCHIVE finished with return code 3

[Former Member · Accepted solution]

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

[Former Member]

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