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


Error :

After DB upgrade , as part of R12 dbtier post-installation procedure, required to run adstats.sql and getting the following error

declare
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:
[1350], [1], [23], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 25335
ORA-06512: at "SYS.DBMS_STATS", line 25877
ORA-06512: at line 3
ORA-06512: at line 33

Cause:

ORA_NLS10 variable not set.

Solution :

1. Make sure that $ORACLE_HOME/nls/data/old/cr9idata.pl executed to create $ORACLE_HOME/nls/data/9idata as per Database upgrading notes.

2. Make sure that the ORA_NLS10 environment variable is set to the full path of the nls/data/9idata directory:

echo $ORA_NLS10
export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

3- If the instance was not started with ORA_NLS10 set correctly restart it.

4- Retest the issue by running adstats.sql again as it should run successfully now.