SQL error -20000 at location stats_oradict_collect-4

[Former Member]

Hi,

I have just upgraded BRTOOLS (6.4 to 7.10), but having following error while updating statistics for Oracle Dictionary, do you have any clue ?

oranq2> brconnect -u / -c -f stats -t ORADICT_STATS

BR0801I BRCONNECT 7.10 (24)

BR0805I Start of BRCONNECT processing: cebcpkml.sta 2009-07-27 21.12.35

BR0484I BRCONNECT log file: /oracle/NQ2/sapcheck/cebcpkml.sta

BR0280I BRCONNECT time stamp: 2009-07-27 21.12.37

BR0807I Name of database instance: NQ2

BR0808I BRCONNECT action ID: cebcpkml

BR0809I BRCONNECT function ID: sta

BR0810I BRCONNECT function: stats

BR0812I Database objects for processing: ORADICT_STATS

BR1314I Oracle dictionary statistics will be collected with default options

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRCONNECT time stamp: 2009-07-27 21.12.37

BR1311I Starting collection of Oracle dictionary statistics...

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRCONNECT time stamp: 2009-07-27 21.13.04

BR0301E SQL error -20000 at location stats_oradict_collect-4, SQL statement:

'BEGIN DBMS_STATS.GATHER_DICTIONARY_STATS (ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE AUTO', GRANULAR ITY => 'ALL', CASCADE => TRUE, OPTIONS => 'GATHER', NO_INVALIDATE => FALSE); END;'

ORA-20000: Insufficient privileges to analyze an object in Dictionary Schema

ORA-06512: at "SYS.DBMS_STATS", line 13367

ORA-06512: at "SYS.DBMS_STATS", line 13726

ORA-06512: at "SYS.DBMS_STATS", line 16029

ORA-06512: at "SYS.DBMS_STATS", line 16071

ORA-06512: at line 1

BR1313E Collection of Oracle dictionary statistics failed

BR0806I End of BRCONNECT processing: cebcpkml.sta 2009-07-27 21.13.04

BR0280I BRCONNECT time stamp: 2009-07-27 21.13.04

BR0804I BRCONNECT terminated with errors

[Former Member]

Mamun,

Try by executing catalog.sql. Also check below mention sap note & thread.

SAP Note 948197 Merge fix for DBMS_STATS package on Oracle 9.2.x and 10.2.x

Thanks,

Sushil

[former_member204746]

Read these SAP notes, especially the 3rd one.

8734917 Oracle Database 10g: New database role SAPCONN

1028220 ORA-01031: Insufficient privileges despite SAPCONN role

963760 'ORA-20000: Insufficient privileges' for creating statistics

[anindya_bose]

Hi Mamun

Hi Mamun

I guess you have upgraded to Oracle 10g...did you?

Check the notes below.

You have to add one role...

https://service.sap.com/sap/support/notes/963760 834917 and 948197