Error in Update Statistics – SQL error -20003 at location stats_tab_collect

Posted on Leave a commentPosted in Oracle Database, Update

Hello, I just want to share a solution for the error SQL error -20003 at location stats_tab_collect. The issue occurs on DB13 update statistics. It began occur after a BW system refresh done through Oracle database backup from PRD. Symptom BR0301E SQL error -20003 at location stats_tab_collect-78, SQL statement BR0886E Collecting statistics failed for table […]

Update Statistics Error on DB13 – SQL error -20000 at location stats_ind_collect-3

Posted on Leave a commentPosted in Oracle Database

Hello all, I want to share a simple solution for the issue below, when scheduled “Update Statistics” on DB13: Error details log: BR0301E SQL error -20000 at location stats_ind_collect-3, SQL statement: ‘BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => ‘”SAPSR3″‘, INDNAME => ‘”/ABC/INDEXNAME~010″‘, ESTIMATE_PERCENT => 3, DEGREE => NULL, NO_INVALIDATE => FALSE); END;’ ORA-20000: index “SAPSR3”.”/ABC/INDEXNAME~010″  or partition of […]

Change the redundancy of the Disk Group of the ASM instance

Posted on Leave a commentPosted in ASM, Oracle Database

You want to change the redundancy of the Disk Group of the ASM instance. Current situation:   If you try to dismount/drop: Why? Because the ASM instance has its spfile on it: [grid@ora-asm:+ASM ~]$ asmcmd ASMCMD> spget +DATA/asm/asmparameterfile/registry.253.907250463 How to procede then Firts, you need to add another diskgroup (VOL3): [root@ora-asm ~]# oracleasm createdisk VOL3 […]