ORA-00600: internal error code, arguments: [1350], [3], [23], [60], [AMERICAN]... when select from v
Hi All:
I have Oracle eBs R12.2.5 instance with Oracle database version 12.1.0.2 on Linux 6 OS.
When I execute "SQL> select * from v$nls_valid_values;" I get the error:
ERROR at line 1:
ORA-00600: internal error code, arguments: [1350], [3], [23], [60], [AMERICAN],
[0], [], [], [], [], [], []
Or when I execute:
SQL> exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:
[1350], [3], [23], [60], [AMERICAN], [0], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 37011
ORA-06512: at line 1
Here is the more information:
$ env | grep ORA_NLS
ORA_NLS10=$ORACLE_HOME/nls/data/9idata
$ echo $ORA_NLS10
$ORACLE_HOME/nls/data/9idata
Since my instance is Ooracle eBs (E-Business Suite) R12.2.5, ORA_NLS10 is required to point to: $ORACLE_HOME/nls/data/9idata.