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.
Leave a Reply