Author Archives: Vasudev Seeram - Page 4

ORA-20011: Approximate NDV failed: ORA-00600: internal error code Running adstats.sql

Problem:While running adstats.sql, the following error occurs:

--------------------------------------------------
--- adstats.sql started at 2013-09-03 14:08:43 ---


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 24889
ORA-06512: at "SYS.DBMS_STATS", line 25430
ORA-06512: at line 3
ORA-06512: at line 33


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options

D:\ORACLE\MFGPR12\db\tech_st\11.2.0> 

Solution: Bounce database, then retry script.

Note: Make sure that you have at least 1.5 GB of free default temporary tablespace.

Problem: While running adbldxml.pl, the following error occurs:

D:\ORACLE\PRODR12\db\tech_st\11.2.0>perl D:\ORACLE\PRODR12\db\tech_st\11.2.0\appsutil\bin\adbldxml.pl

Starting context file generation for db tier..

D:ORACLEPRODR12dbtech_st11.2.0binsqlplus.exe: not found

D:ORACLEPRODR12dbtech_st11.2.0bintnsping.exe: not found

ERROR: while running command : D:\ORACLE\PRODR12\db\tech_st\11.2.0\bin\tnsping.exe

Failed to execute the specified command.

Verify that the command can be executed from the command prompt.

Solution: Use perl located in %ORACLE_HOME%\perl\bin. Do not use perl bundled with MKS Toolkit.

e.g. D:\ORACLE\PRODR12\db\tech_st\11.2.0\perl\bin\perl D:\ORACLE\PRODR12\db\tech_st\11.2.0\appsutil\bin\adbldxml.pl

RC-20200: Fatal: Could not find Unzip

Problem: While running admkappsutil.pl, the following error occurs:

D:\ORACLE\PRODR12\apps\apps_st\appl>perl D:\ORACLE\PRODR12\apps\apps_st\appl\ad\12.0.0\bin\admkappsutil.pl
Starting the generation of appsutil.zip

Log file located at D:\oracle\PRODR12\inst\apps\PROD_vasusrv\admin\log\MakeAppsUtil_09031037.log
output located at D:\oracle\PRODR12\inst\apps\PROD_vasusrv\admin\out\appsutil.zip

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again...
MakeAppsUtil completed with errors, Please check logfile for more information.

Solution: Download unzip for your platform from Info-Zip (http://www.info-zip.org). For Windows 2003, download unz552xn.exe). For Windows 2008 64-bit, download the 64-bit version (unz552xn-x64.exe). Or see the readme: ftp://ftp.info-zip.org/pub/infozip/win32/readme

ftp://ftp.info-zip.org/pub/infozip/win32/

 

FAILED: File czhist.sql While Running Patch 6678700

Problem: While running patch 6678700, the following error occurs:

FAILED: file czhist.sql   on worker  1.

Solution: Execute the following commands:

sqlplus / as sysdba 
EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('APPLSYS','FND_STATTAB');

Then retest issue (use adctrl option 2 restart failed worker)

Reference: Script Czhist.Sql Fails During Application Of Patch 6678700 (Doc ID 1281478.1)

FAILED: File fem_bal_nacc_hier_l2_mv.xdf While Running Patch 6678700

Problem: While running patch 6678700, the following error occurs:

FAILED: file fem_bal_nacc_hier_l2_mv.xdf on worker  1.

Solution: Use adctrl hidden option ‘8’ to skip the failed worker and complete the upgrade. Then, apply patch 10406817  “ORA-54015 APPLYING FEM_BAL_NACC_HIER_L2_MV.XDF ON ORACLE 11GR2 DATABASE” after the upgrade.

Reference: Patch Fails on Fem_bal_nacc_hier_l2_mv.xdf After Upgrade to Oracle 11.2.0.2 Database (Doc ID 1284055.1)

 

FAILED: File apaphuhf.sql While Running Patch 6678700

Problem: While running patch 6678700, the following error occurs:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file apaphuhf.sql on worker  2.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Checking the worker log file showed:

sqlplus -s APPS/***** @D:\oracle\MFGP\apps\apps_st\appl\ap\12.0.0\patch\115\sql\

apaphuhf.sql &un_ap &batchsize 2 2

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this 
operating system.

DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (AP.AP_PAYMENT_HISTORY_U2) violated
ORA-06512: at line 55

Solution: There is a duplicate value in the “REV_PMT_HIST_ID” column in the AP_PAYMENT_HISTORY_U2. Locate the duplicate value and set it to null.

 

FAILED: File xlaraslg4.sql While Running Patch 6678700

Problem: While running patch 6678700, the following error occurs:

FAILED: file xlaraslg4.sql on worker  1.

Check adwork001.log  for more information regarding the error:

sqlplus -s APPS/***** @D:\oracle\MFGPR12\apps\apps_st\appl\xla\12.0.0\patch\115\sql\xlaraslg4.sql &un_ax

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.
Action: Check your installation manual for the meaning of this code on this operating system.DECLARE
*
ERROR at line 1:
ORA-20100: glraslg4.sql: status_code=SETUP_PL_SLA_OPTIONS error_msg=ORA-20001:
-: XLA-95103: An internal error occurred.  Please inform your system 
administrator or support representative that:
An internal error has occurred in the program xla_acct_setup_pkg.insert_launch_options.  
ORA-01658: unable to create INITIAL extent for segment in tablespace APPS_TS_SEED.
ORA-06512: at line 97

Solution: Add another datafile to APPS_TS_SEED tablespace:

select * from dba_data_files where tablespace_name = 'APPS_TS_SEED';

alter tablespace apps_ts_seed add datafile 
'D:\ORACLE\MFGP\MFGPDB\ORADATA\MFGP\A_REF03.DBF' size 1000M;

 

FAILED: File GMIG3MIB.sql While Running Patch 6678700

Problem: While running patch 6678700, the following error occurs:

FAILED: file GMIG3MIB.sql on worker  1.

Solution: If OPM is not used, the script is not relevant and can be skipped.

If the table IC_LOCT_INV doesn’t exist or the query below returns no rows, the script can be ignored.

select whse_code,migrated_ind,count(*) from
ic_locT_inv
where loct_onhand <>0 or
loct_onhand2 <>0
group by whse_code,migrated_ind;

Use adctrl option 8 to skip and restart.

Reference: GMIG3MIB.sql Is Stuck While Applying 12.1.1 Upgrade Patch 6678700 (Doc ID 1550457.1)

FAILED: File jaircvdff.sql While Running Patch 6678700

Problem: While running patch 6678700, the following error occurs:

FAILED: file jaircvdff.sql on worker  1.

Check adworker log in D:\ORACLE\MFGPR12\apps\apps_st\appl\admin\MFGP\log.

Solution: The cause of the issue is wrong parameter passed to script. Source the database tier environment and change directory to D:\ORACLE\MFGPR12\apps\apps_st\appl\ja\12.0.0\sql. Run jaircvff.sql and provide the following parameters while running the script manually:-

Enter value for 3: 1

Enter value for 4: 1

Enter value for 1: PO

Enter value for 2: 1000

Once the script completes successfully then skip the worker using adctrl and continue with patching.

Reference: JAIRCVDFF.SQL FAILS ON 12.1.1 UPGRADE PATCH 6678700 (Doc ID 1473255.1)

FAILED: File igipayup.sql While Running Patch 6678700

Problem:

ERROR: While running patch 6678700, the following error occurs:

FAILED: file igipayup.sql on worker  1.

Check adworker log in D:\ORACLE\MFGPR12\apps\apps_st\appl\admin\MFGP\log.

Solution:

To implement the solution, please execute the following steps:

1. The error message you are seeing indicates that the table IGI_UPGRADE_LOG does not exist. Verify this is true by running the following command:

SELECT COUNT(*) FROM IGI_UPGRADE_LOG;

2. Assuming that the table does not exist, look in %IGI_TOP%/patch/115/odf and see if you have a file called ‘igiupg.odf’ in there.

3. If the file exists, use the utility ‘adodfcmp’ to create the missing table.

4. If the file does not exist, download and unzip the patch:10074551:R12.IGI.B and copy ‘igiupg.odf’ into directory $IGI_TOP/patch/115/odf

5. To create the missing object(s) use the following commands:

adodfcmp userid=IGI/igi touser=APPS/apps priv_schema=SYSTEM/manager changedb=YES odffile=%IGI_TOP%\patch\115\odf\igiupg.odf mode=sequences
adodfcmp userid=IGI/igi touser=APPS/apps priv_schema=SYSTEM/manager changedb=YES odffile=%IGI_TOP%\patch\115\odf\igiupg.odf mode=tables

6. Use adctrl (option 2) to continue patch 6678700 from the point of failure and run the script IGIPAYUP.sql.

Reference: R12 Upgrade Patch 6678700 Failed In IGIPAYUP.sql With INSERT INTO IGI_UPGRADE_LOG ORA-00942 Table Or View Does Not Exist (Doc ID 1489757.1)