If you are getting below error in DB13- checkDB.
BR0280I BRCONNECT time stamp: XXXXXXXXXX
BR0818I Number of tables found in DBDIFF for owner SAPR3: 2
BR0280I BRCONNECT time stamp: XXXXXXXXXX
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: XXXXXXXXXXXXX
BR0280I BRCONNECT time stamp: XXXXXXXXXXXXX
You need to run the sapdba_role.sql to fix this issue:
Go under /usr/sap/SID/SYS/run/exe and run
sqlplus /nolog @sapdba_role.sql SR3 <SID>- -- For ABAP sceham
sqlplus /nolog @sapdba_role.sql SR3<SID>DB- - -For Java Schema
Note:but it´s very important check if the script sapdba_role.sql is up to date to last version ....In some-case it worked only when download the last version of this script
Also check the below sap notes if issue is not resolved, which will help you to resolve.
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 case insufficient privileges issue to" DDART" table after given permission like below issue will be resolved.
grant SELECT on SAPR3.DDART to sapdba;
golden goose
ReplyDeletehermes bag outlet
golden goose sneakers
curry shoes
supreme new york
bape clothing
goyard bag
yeezy boost 350
bape clothing
a bathing ape