adstats.sql Fails With ORA-20011 and ORA-600

Performing database upgrade from 11.2.0.4 to 12.1.0.2 with EBS version R12.1.3. When I'm executing post DB upgrade step adstats.sql, its failed with following ORA internal error.

declare
*
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 36906
ORA-06512: at line 3
ORA-06512: at line 33
 

Looking at V$NLS_VALID_VALUES and it 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], [3], [23], [60], [AMERICAN],
[0], [], [], [], [], [], []

SQL>
 

Follow below steps to fix this issue:

1) Source the database environment file and check PERL5LIB variable is set correctly. If you are using RAC, then check all the nodes of a RAC environment.

Example:
 
 $ export 
 PERL5LIB=/u01/app/12102/perl/lib/5.10.0:/u01/app/12102/perl/lib/site_perl/5.10.0:/u01/app/12102/appsutil/perl
 

2) Run "perl $ORACLE_HOME/nls/data/old/cr9idata.pl" to create 9idata directory and set ORA_NLS10 parameter.

Example:
  
  $ export ORA_NLS10=/u01/app/12102/nls/data/9idata
 

3) Restart the database

4) Now run adstats.sql and also check at V$NLS_VALID_VALUES. If still issue exists please check with oracle support team.

That's it, hope this article will help you :).

Thanks,
Chowdari

ORA-1166 file number 101 is larger than MAXDATAFILES (100)

I am in the process of upgrading EBS R12 DB from 11.2.0.3 to 11.2.0.4 using DBUA. The end of the upgrade, DBUA fails with following error message.

During the DBUA, I have selected option 'move the database files location'.

ORA-1503: CREATE CONTROLFILE failed
ORA-1166: file number 101 is larger than MAXDATAFILES (100)
ORA-1110: data file 101: '/u01/EBS/data/opmor01.dbf'

So then I have verified oracle documentation and support docs. There is a bug in DBUA, the problem is Database Upgrade Assistant (DBUA) tries to re-create the control file with MAXDATAFILES set to 100 instead of using the value from the old control file.

To fix this issue one of the following workarounds should be used:

1) Upgrade the database using DBUA (without moving the database files option) and If you are using ASM, after completed the upgrade use RMAN to move the database files to ASM.
2) Manually upgrade the database and manually re-create the control file (setting MAXDATAFILES to a higher value).

Thats it..Hope this will helps you..:)

Thanks,
Chowdari.