[Solved] Issue while applying EBS 12.2.8 patch ‘26787767’

This post covers solution for the issue while applying Oracle E-Business Suite 12.2.8 patch ‘ 26787767’ and how to troubleshoot it with complete solution.

If you have not yet gone through with FREE video from Oracle ACE & Author Atul Kumar on Online Patching (ADOP) in Oracle E-Business Suite (Apps) R12.2 for Apps DBAs  then I suggest you look here

If you are looking for Oracle E-Business 12.2.8 software: how to download, upgrade path to 12.2.8, and new features that come with EBS 12.2.8 then look here

Issue:

While applying Oracle E-Business Suite 12.2.8 patch ‘ 26787767’ as

adop phase=apply apply_mode=downtime  patches= 26787767  workers=2

Note: When you run patch in downtime mode i.e. option apply_downtime (as done for 12.2.8), patch will directly be applied on RUN edition and you run clean up & fs_clone to clone from RUN Edition to Patch Edition.

Error in logs:

/u01/oracle/PRD122/fs_ne/EBSapps/log/adop/2/20181226_055055/apply/1812ebs10/26787767/log/u26787767.log

AutoPatch error:

adphistExecAdFileUtilPackage: Unexpected Database Error

AutoPatch error:

ORA-01653: unable to extend table APPLSYS.AD_FILE_VERSIONS by 16 in tablespace APPS_TS_TX_DATA

ORA-06512: at “APPS.AD_FILE_UTIL”, line 1119

ORA-06512: at line 3

AutoPatch error:

Error Calling adphistExecAdFileUtilPackage

Error in calling adphistUpdateCheckFileTemp().

AutoPatch error:

Unable to upload Java Classes to Database

Error calling adphistStoreCurPatchHistInDB2

AutoPatch warning:

Unable to save Patch History information to Database

AutoPatch error:

adptaskStoreTimInfoToHist: Error while inserting into AD_PROGRAM_RUN_TASKS.

AutoPatch error:

ORA-01653: unable to extend table APPLSYS.AD_PROGRAM_RUN_TASKS by 16 in tablespace APPS_TS_TX_DATA

AutoPatch error:

adpmrp: Error calling adptaskStoreTimInfoToHist(2).

Cause:

There is not enough space in tablespace APPS_TS_TX_DATA.

Fix:

1. Check the existing datafile location for tablespace APPS_TS_TX_DATA by running:

SQL> select tablespace_name,file_name from dba_data_files where TABLESPACE_NAME=’APPS_TS_TX_DATA’;

TABLESPACE_NAME FILE_NAME
—————————— ——————————————————————————–

APPS_TS_TX_DATA /u01/oracle/PRD122/data/a_txn_data03.dbf

APPS_TS_TX_DATA /u01/oracle/PRD122/data/a_txn_data02.dbf

APPS_TS_TX_DATA /u01/oracle/PRD122/data/a_txn_data01.dbf

APPS_TS_TX_DATA /u01/oracle/PRD122/data/a_txn_data04.dbf

2. Check a_txn_data04.dbf current size by running the following SQL:

SQL> select bytes from V$DATAFILE where NAME=’/u01/oracle/PRD122/data/a_txn_data04.dbf’;

BYTES
———-
1828716544

3. Resizing the tablespace:

SQL> alter database datafile ‘/u01/oracle/PRD122/data/a_txn_data04.dbf’ resize 2000M;

Database altered.

4. After increasing the tablespace for APPS_TS_TX_DATA, one should be able to re-run 12.2.8 patch ‘26787767’ successfully.

adop phase=apply apply_mode=downtime patches=26787767 workers=2 restart=yes abandon=no

After increasing size of tablespace APPS_TS_TX_DATA, we are able to proceed further and 12.2.8 patch ‘26787767’ completed successfully.

OR

1. Update tablespace ‘APPS_TS_TX_DATA’ with autoextend on option before to apply EBS 12.2.8 patch ‘26787767’ else you will hit above issue

SQL> alter database datafile ‘/u01/oracle/PRD122/data/a_txn_data04.dbf’ autoextend on next 100M maxsize 30g;

Note: It will do for all datafiles.

SQL> select sum(bytes)/1024/1024/1024, sum(maxbytes)/1024/1024/1024 from dba_data_files where tablespace_name=’&1′;

The difference should be 20gb between the 2 column output

Related/Further Readings

• Oracle E-Business Suite (EBS) 12.2.8 Now Available: Documentation & Download Software
• Steps to Download Oracle EBS R12 Software from the delivery site
• [Solved] Oracle EBS (R12) Installation Issue: Could not find the main class: oracle.apps.ad.rapidwiz.RIWizard
• Oracle AppsDBA (R12): Step by step Activity Guides 
• Oracle AppsDBA (R12.2): Install | Patch | Clone | Maintain

Next Task For You

We cover Oracle E-Business R12.2 Architecture & concepts in our Oracle Apps DBA For Beginners Training along with the Installation, Patching, Cloning, and Troubleshooting and also, Database upgrade to 19c  and much more including the hands-on labs you must perform to upgrade your skills and get a good job with a high package.

Begin your journey towards becoming an Apps DBA by joining our FREE Masterclass on How To Learn Oracle Apps DBA (R12) & It’s New Features.