ADSTATS.SQL FAILS On 12.1.3 With ORA-20011 ORA-00600: internal error code, arguments: [1350] On V$NLS_VALID_VALUES (Doc ID 2044698.1)

Last updated on OCTOBER 01, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.1.3, Database for Applications Technology:

Running adstats as sys / sysdba fails with ORA-20011 (Ref. <Note 1058763.1> - Step 25):

--------------------------------------------------
--- adstats.sql started at 2015-06-17 08:50:36 ---


Checking for the DB version and collecting statistics ...

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


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

$
 

Looking at V$NLS_VALID_VALUES shows as,

SQL> select count(*) from V$NLS_VALID_VALUES;
select count(*) from V$NLS_VALID_VALUES
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [1350], [1], [23], [], [], [], [],
[], [], [], [], []"

STEPS
-----------------------
The issue can be reproduced via the following steps:
1. ran adstats.sql failed with error
2. V$NLS_VALID_VALUES showed internal error code

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms