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 JULY 06, 2020
Applies to:
Oracle E-Business Suite 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 R12 Applications Technology Stack, Database for Applications Technology related issues
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
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |