After upgrading database from 12.2.0.1 to 19.13.0.0.0 database stats gathering failing

Feb 8, 2022 6:12AM

SQL> EXEC DBMS_STATS.gather_database_stats;

BEGIN DBMS_STATS.gather_database_stats; END;

*

ERROR at line 1:

ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:

[qerandvRop.opnp.cvl], [80], [60], [1], [12], [], [], [], [], [], [], []

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

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

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

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

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

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

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

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

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

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

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

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

Database Install/Upgrade/Opatch (MOSC)