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

[Former Member]

Der All

We face problem in dbcheck in db13 after update solman sp4 to sp8 use sum Tools

BR0983I Tablespace fragmentation

Tablespace    Files   Tables  Indexes    Extents     Total[KB]   Used[%]     Free[KB]   FreeExt.   MaxSize[KB]   MaxAlloc[KB]   Used[%]

PSAPSR3           9    41178    53517      48724     50667520     74.84     12747264        384      91709440+      41041920+    41.35+

PSAPSR3702        8        0        0          0     28712960      0.03     28704768         11      69754880+      41041920+     0.01+

PSAPSR3702X       7      390      572       6846     45260800     95.08      2228288          4      51200000+       5939200+    84.05+

PSAPSR3DB         3      687     1304       2797      5140480     95.06       253824          2      30720000+      25579520+    15.91+

PSAPSR3USR        1       17       17          0        40960      2.50        39936          1      10240000+      10199040+     0.01+

PSAPTEMP          1        0        0          0      1239040      0.74      1229824          0      10240000+       9000960+     0.09+

PSAPUNDO          1        0        0          0      6369280      0.02      6368256         83      10240000+       3870720+     0.01+

SYSAUX            1      399      453       2947       430080     92.43        32576          1      10240000+       9809920+     3.88+

SYSTEM            1      628      714       3198       911360     99.08         8384          2      10240000+       9328640+     8.82+

Total:           32    43299    56577      64512    138772480     62.81     51613120        488     294584320      155811840     29.59      2

BR0280I BRCONNECT time stamp: 2013-11-01 09.47.21

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

'PREPARE stmt_5 FROM'

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

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: cemlatie.chk 2013-11-01 09.47.21

BR0280I BRCONNECT time stamp: 2013-11-01 09.47.21

BR0804I BRCONNECT terminated with errors

Nainesh

9376998808

[karthikeyan_natarajan4 · Accepted solution]

Hi Nainesh,

Have you looked at this note

900525  - BRCONNECT fails with ORA-01031 at location BrDdartRead-1

regards

kartik

[Former Member · Accepted solution]

Dear kartin

we applay

sqlplus /nolog @sapdba_role sapsr3

But there no differenc

Nainesh

[Former Member · Accepted solution]

Dear Kartic

After update it show warninnig

[Reagan]

Hello

ORA-01031: insufficient privileges

Run the sapdba_role.sql

sqlplus /nolog @sapdba_role sapsr3

This is incorrect

Here is the correct way: sqlplus /nolog @sapdba_role SR3

Regarding the harmful statistics:

http://help.sap.com/saphelp_nw04/helpdata/en/36/b8503e30a9d549e10000000a114084/content.htm

Regards

RB

[Former Member]

Thanks

I post that after this a warning is show whic i send Screen short of warning...

what i do

Thanks

[Reagan]

Follow this KBA

1918288  - How to process HARMFUL_STATISTICS

Regards

RB

[karthikeyan_natarajan4]

Hi Nainesh,

Do you see any dump in ST22.

regards

kartik

[Former Member]

Dear Kartic

My Client copy not sucess full and may dump in ST22

and in DB02 Tablsapce Ove view SAPSR3702X Table space not show but when i go to Detail then i get all detail for SAPSR3702X Table Space I send Screen Alos