DBcheck get failed from db13 with error BR0301E SQL error -1031

[Former Member]

Hi,

I am executing DBcheck from db13 but it gets failed with error "BR0301E SQL error -1031 at location BrDbdiffRead-1, SQL statement".

Here is the job logs:

************************************

Job started

Step 001 started (program RSDBAJOB, variant &0000000000424, user ID SVKM_BASIS2)

Execute logical command BRCONNECT On host svkmeccdbci

Parameters: -u / -jid CHECK20110930103211 -c -f check

BR0801I BRCONNECT 7.00 (40)

BR0477I Oracle pfile /oracle/SEP/102_64/dbs/initSEP.ora created from spfile /oracle/SEP/102_64/dbs/spfileSEP.ora

BR0805I Start of BRCONNECT processing: cegwudvg.chk 2011-09-30 10.32.12

BR0484I BRCONNECT log file: /oracle/SEP/sapcheck/cegwudvg.chk

BR0280I BRCONNECT time stamp: 2011-09-30 10.32.12

BR0813I Schema owners found in database SEP:

DBSNMP, DIP, OPS$ORASEP, OPS$SAPSERVICESEP, OPS$SEPADM, ORACLE_OCM, OUTLN, SAPSR3*, SYS, SYSTEM,

TSMSYS

BR0280I BRCONNECT time stamp: 2011-09-30 10.32.20

BR0814I Number of tables in schema of owner SAPSR3: 77207

BR0836I Number of info cube tables found for owner SAPSR3: 49

BR0814I Number of tables/partitions in schema of owner SYS: 625/189

BR0814I Number of tables/partitions in schema of owner SYSTEM: 134/27

BR0280I BRCONNECT time stamp: 2011-09-30 10.32.29

BR0815I Number of indexes in schema of owner SAPSR3: 92099

BR0815I Number of indexes/partitions in schema ofowner SYS: 678/199

BR0815I Number of indexes/partitions in schema ofowner SYSTEM: 175/32

BR0280I BRCONNECT time stamp: 2011-09-30 10.32.52

BR0816I Number of segments in schema of owner DBSNMP: 25

BR0816I Number of segments in schema of owner OPS$SEPADM: 1

BR0816I Number of segments in schema of owner OUTLN: 9

BR0816I Number of segments/LOBs in schema of owner SAPSR3: 174072/2383

BR0816I Number of segments/LOBs in schema of owner SYS: 1838/87

BR0816I Number of segments/LOBs in schema of owner SYSTEM: 353/22

BR0816I Number of segments in schema of owner TSMSYS: 4

BR0280I BRCONNECT time stamp: 2011-09-30 10.32.52

BR0961I Number of conditions found in DBCHECKORA:118

BR0280I BRCONNECT time stamp: 2011-09-30 10.32.52

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

'PREPARE stmt_5 STATEMENT FROM'

'SELECT OBJNAME FROM "SAPSR3".DBDIFF WHERE DBSYS IN ('ORACLE', ' ') AND OBJTYPE = 'TABL' AND DIFFKIND IN ('02', '61', '99') ORDE

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: cegwudvg.chk2011-09-30 10.32.52

BR0280I BRCONNECT time stamp: 2011-09-30 10.32.52

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

****************************************************

Please help.

Thanks in advanced.

Ocean

[Former Member]

Hi,

I searched "BRCONNECT" "ORA-01031" and found the following note 900525

Can you run the brconnect -f check and see if it works?

if not you may need to run the script sapdba_role.sql

Regards,

Chris

[Former Member]

Dear,

Thanks for the reply.

I have checked the note you have mention, but it show it is for SAP Release 6.20 or lower.

we have ECC6 EHP4 release 700.

So, please advise, should i go for that note and perform the required action ?

Thanks.

[Former Member]

Hello,

But the Note 134592 - Importing the SAPDBA role (sapdba_role.sql) is Release independent.

You should try it as already suggested, sapdba_role.sql might be existing in the kernel DIR as well and you may try to execute from there itself but this note suggests to download the latest.

Thanks

[Former Member]

Just to add -

If you are on Unix, you can try to verify the permissions as well - Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA OR saproot.sh SID to rectify the kernel files' permissions.

Thanks