Skip to Content
0
Aug 16, 2013 at 04:03 PM

brconnect gives ORA-01031: insufficient privileges after SAP Note 1139623 applied

1033 Views

Now that I have run through the SAP note my brconnect gives me:

sapjbd:orajbd 27> brconnect -u / -c -f stats -t all -f nocoll -p 2

BR0801I BRCONNECT 7.20 (32)

BR0805I Start of BRCONNECT processing: celwopzy.opt 2013-08-16 10.56.30

BR0484I BRCONNECT log file: /oracle/JBD/sapcheck/celwopzy.opt

BR0280I BRCONNECT time stamp: 2013-08-16 10.56.31

BR0813I Schema owners found in database JBD: APPQOSSYS, DBSNMP, DIP, OPS$ORAJBD, OPS$SR3ADM, ORACLE_OCM, OUTLN, SAPSR3DB%

BR0280I BRCONNECT time stamp: 2013-08-16 10.56.32

BR0814I Number of tables in schema of owner APPQOSSYS: 4

BR0814I Number of tables in schema of owner DBSNMP: 24

BR0814I Number of tables in schema of owner OUTLN: 3

BR0814I Number of tables in schema of owner SAPSR3DB: 671

BR0280I BRCONNECT time stamp: 2013-08-16 10.56.33

BR0815I Number of indexes in schema of owner DBSNMP: 16

BR0815I Number of indexes in schema of owner OUTLN: 4

BR0815I Number of indexes in schema of owner SAPSR3DB: 1007

BR0280I BRCONNECT time stamp: 2013-08-16 10.56.33

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

'PREPARE stmt_15 FROM'

'SELECT DBOBJ, DOTYP, OBJOW, VWTYP, ACTIV, OBJEC, AEDAT, AMETH, OPTIO, SIGNI, TOBDO, HISTO, TDDAT, DURAT, PLAND FROM "SAPSR3DB".DBST

ATC WHERE (DOTYP IN ('01', ' ') AND OBJOW IN ('SAPSR3DB', 'SAPR3', ' ') OR DOTYP >= 'AA' AND DOTYP <= 'ZZ') AND DBTYP IN ('ORACLE',

' ') AND VWTYP IN ('A', 'O', ' ') ORDER BY DBOBJ, DOTYP, OBJOW, DBTYP'

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: celwopzy.opt 2013-08-16 10.56.33

BR0280I BRCONNECT time stamp: 2013-08-16 10.56.33

BR0804I BRCONNECT terminated with errors

I have reapplied the sapdba_role.sql as per SAP Note 134592.

I am at a loss.

HP-UX Oracle 11.2.0.2