Hi, Please execute sapdba_role.sql as described in note 134592 and try DBCheck again. Regards, LEH
| | | ---------------Original Message--------------- From: Ocean Elevan Sent: Friday, September 30, 2011 1:45 AM Subject: DBcheck Get Failed in DB13 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 Thanks in advance Ocean | | __.____._ Copyright © 2011 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251 | | Lars-Erik Hallsten SAP Basis Top Contributor
Contributed the most posts in a group for a month to earn a Silver Achievement Popular White Papers In the Spotlight View the "Managing the Application Life Cycle" webinar and learn how organizations optimize their SAP applications. _.____.__ |